Zomalex | Data and AI Training
SQL Intermediate Course Outline
Who should attend
People who have attended the foundation course and want to improve their SQL skills.
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. Completion of the foundation course.
Snapshots from the course exercises
SQL Server Management Studio in use