Tracks/SQL Track/SQL Subqueries & CTEs
Intermediate
5 modules · ~10h

SQL Subqueries & CTEs

Master subqueries and Common Table Expressions to write powerful, readable SQL queries.

5 modules9 lessons25 exercises~10h
Scalar subqueriesIN/EXISTS patternsCorrelated subqueriesCommon Table ExpressionsQuery refactoring
Start course

Recommended prerequisites

SQL for Analysis
Content

Course modules

1

Scalar Subqueries

Learn to use subqueries that return a single value.

2

IN and NOT IN Subqueries

Filter data using subqueries with IN and NOT IN.