We offer a learning path of three SQL Courses. The foundation course is for beginners to SQL. It covers the basics to retrieve data from a SQL database: the SELECT statement to retrieve data, the WHERE clause to filter data, the ORDER BY clause to sort data, the GROUP BY clause and aggregation functions such as COUNT() and SUM() to summarise data, creating calculated columns, and an introduction to joining tables to return a dataset that combines data from more than one table.
There is a half day overview course that covers much of the foundation course. The difference is that it is more of a demonstration by the instructor rather than hands-on exercises for the attendees.
The intermediate course follows on from the foundation course and covers more detailed examples of joining tables e.g. LEFT and OUTER joins, sub-queries, common table expressions (CTEs), temporary tables, the CASE statement, and dealing with NULLs (missing values).
The advanced course follows on from the intermediate course and covers Window functions and their uses e.g., ratio calculations, cumulative totals, finding the top N items in each category. It also covers creating and using tally tables.
SQL is best learned through hands-on practice and real-world examples. In all our courses, attendees practise writing SQL in a proper professional SQL environment from the start of the course.