SQL Courses
We offer a learning path of three SQL Courses. The foundation course is for beginners to SQL. It covers:
- the SELECT statement to retrieve data,
- column lists,
- the WHERE clause to filter data,
- the ORDER BY clause to sort data,
- creating calculated columns,
- the GROUP BY clause and aggregation functions such as COUNT() and SUM() to summarise data, 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
- 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 and
- 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.