Zomalex | Data and AI Training
SQL Intermediate Course Outline
Who should attend
People who have completed a foundation SQL course and want to improve their SQL skills and learn the CASE statement, subqueries, CTEs and temporary tables, and practise JOINs.
Learning Objectives
You will learn how to combine data held across several tables and more powerful SQL techniques to help you retrieve exactly the data you need.
Course Content
- Create a SQL statement that retrieves data more than one table using JOINs. Understand different types of JOIN (INNER, LEFT, …).
- Introduction to subqueries. Self-contained subqueries that return scalar values and lists.
- Common table expressions (CTEs).
- Temporary tables and their uses.
- the CASE clause - These give great flexibility to create new calculated columns.
- Dealing with NULL (missing) values.
- Use an AI assistant to help write and learn SQL
Course Length
1 day (short version) or 2 days (preferred, full version)
Pre-requisites
Basic familiarity with the SQL SELECT statement and the WHERE, GROUP BY, ORDER BY clauses, for example by completion of the foundation course.
Snapshots from the course exercises
A snapshot of a SQL Intermediate course exercise