SQL Course: Level 2a
SQL. Work smarter, not harder.
Learn SQL the smart way with SQL training courses at CCE, The University of Sydney.
This SQL course will show you how to extract and change data in relational databases with SQL (Structured Query Language) that traverses multiple tables with Select, Insert, Update and Delete statements, functions and scripts. SQL is a current hot skill, valued by employers.
Microsoft SQL Server is used for hands on exercises during this course. However, the content of the SQL course is kept as close as possible to standard SQL.
Please note, there will be no instruction on how relational databases work in this course. If you do not understand how databases work or why databases are designed in the way they are or you have never written a simple SQL query from scratch, please complete SQL Course Level 1 training before you attempt this SQL training course.
This course is the first part of a two part coverage of the essentials of traditional and modern SQL, both of which you will need to employ to successfully interrogate and manipulate the structures of relational database management systems.
This SQL training course covers the following topics:
- A (very) brief recap of the SQL content of the SQL Level 1 course (no database design content of that course will be repeated) including an overview of SQL Server Management Studio, following scripting conventions, commenting, creating derived columns with arithmetic, concatenating data, aliases, DISTINCT and the * wildcard, the basic FROM clause and the basic WHERE clause (This recap is mainly for people who work in environments other than SQL Server Management Studio to allow them to get up to speed with SQL Server Management Studio by practicing some simple SQL and also to allow the people who did the SQL 1 course to get their “heads back into SQL”).
- Understand and use relational and logical operators (AND, OR, BETWEEN, NOT, IN, LIKE and IS NULL).
- Use FETCH, OFFSET to retrieve a subset rows relative to a row.
- Retrieve aggregated data into grand totals and subtotals using GROUP BY.
- Filter aggregated result sets with HAVING.
- UNION, INTERSECT and EXCEPT queries.
- Apply output selection logic to the select clause with simple and searched CASE.
- Join multiple tables in a query (INNER joins, OUTER (LEFT, RIGHT and FULL) joins, CROSS joins).
- Table aliasing.
- Further aggregation with multiple dimensions using ROLLUP, CUBE, the GROUPING function and the CASE statement combined.
- Queries that use sub-queries in the SELECT, FROM and WHERE clause.
- Use the view builder to form the basis of a SQL statement.
- Use SELECT INTO to create tables from existing data.
- Insert individual and multiple rows with INSERT.
- Modify individual and multiple rows with UPDATE.
- Remove individual and multiple rows with DELETE.
- The OUTPUT clause.
- The importance and use of intrinsic SQL functions.
- Understand common SQL Server data types, data type precedence and implicit versus explicit data type conversion.
- Scripting basics and variables.
- How indexes work.
- Essential DDL statements in SQL and their use in modifying tables, normalising data and increasing query execution speed.
- Identity columns.
- The basics of Windowed columns with the OVER clause using PARTITION BY and ORDER BY, Row numbering, tiling, aggregate and ranking functions.
This SQL Level 2 course is suitable for participants who have completed SQL Level 1 or those who have a prior understanding of relational database management.
This SQL Level 2 course is delivered as presenter-taught computer-based training.
- Free repeat class - Conditions apply
- Free USB flash drive
- Expert trainer
- Dedicated computer for every student
- Small class size
- Student notes – yours to keep
- Certificate of completion
What others say.
Just want to say this is a very valuable course and I will definitely recommend it to anyone interested in SQL. The instructor has made the course very interesting and easy to understand. I had some knowledge with SQL and have been using it at work before coming to this course. My aim was to fully utilise SQL at my workplace, the tutor has greatly fulfilled this during the course and assisted with lots of in class practice which made the class very vibrant.
The tutor has a knack for explaining concepts using easy to understand analogies. This course is a great follow-up to SQL 1.
The course was very well paced. Loved how the tutor broke down the SQL structure and made it simpler to read.
The tutor is very talented and has an excellent approach in breaking down complex matter into understandable blocks.
This is a well-structured course taught by an excellent tutor who aims for all his students to understand the material, without leaving anyone behind.
I got a lot out of this course, and would recommend it for those looking for a solid working knowledge of SQL.
Excellent course, would definitely recommend it to anyone wanting to get a good understanding of SQL. The Tutor was great.
The tutor was fantastic, obviously a real expert in the area. He did such a great job of presenting such a complex topic into manageable learning areas. Highly recommend this course for anyone who needs SQL skills.
Great balance between content and application – one of the best I’ve experienced. Teacher is clearly a pro.
The instructor has a perfect ability to explain every query in depth throughout the full course, and I am very satisfied with their teaching.
Excellent course and instructor. I’ve been to courses costing 10 times as much that paled in comparison.