Data and AI Training

Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data

SQL Courses

We offer 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.

The intermediate course follows on from the foundation course. It 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. It 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

Course Resources

Here are the joining instructions for all SQL courses.

Here are the post-course resources for all SQL courses.

Here are the notes for for all SQL courses.

Here are the notes for a talk to introduce SQL.