Tracks/SQL Track/SQL Subqueries & CTEs
Intermediate

SQL Subqueries & CTEs

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

5
Modules
9
Lessons
25
Exercises
~10h
Duration
Scalar subqueriesIN/EXISTS patternsCorrelated subqueriesCommon Table ExpressionsQuery refactoring
Start Course

Recommended Prerequisites

sql for analysis
1

Scalar Subqueries

Learn to use subqueries that return a single value.

315m
2

IN and NOT IN Subqueries

Filter data using subqueries with IN and NOT IN.

212m