Zomalex | Data and AI Training
SQL Intermediate Course Outline
Who should attend
People who 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
- Get data from several tables using JOINs. Create a SQL statement that retrieves data more than one table
- Use the JOIN clause to specify the common columns. The JOIN keyword. Types of JOIN (INNER, LEFT, others)
- Subqueries and CTEs. Subqueries and common table expressions (CTEs) increase the analytical power of our SQL statements.
- Temporary tables and their uses.
- CASE statements. The CASE statement gives great flexibility to create new calculated columns. The basic CASE WHEN THEN ELSE END structure.
- NULL values for missing data. Dealing with NULL
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