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

5 modules

Scalar Subqueries

Learn to use subqueries that return a single value.

3 exercises15m

IN and NOT IN Subqueries

Filter data using subqueries with IN and NOT IN.

2 exercises12m

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

5 modules

Scalar Subqueries

Learn to use subqueries that return a single value.

3 exercises15m

IN and NOT IN Subqueries

Filter data using subqueries with IN and NOT IN.

2 exercises12m

SQL Subqueries & CTEs

Recommended prerequisites

Course modules

Introduction to Subqueries

Scalar Subqueries

IN and NOT IN Subqueries

EXISTS and Correlated Subqueries

Common Table Expressions (CTEs)

Advanced CTE Patterns

Capstone Project

SQL Subqueries & CTEs

Recommended prerequisites

Course modules

Introduction to Subqueries

Scalar Subqueries

IN and NOT IN Subqueries

EXISTS and Correlated Subqueries

Common Table Expressions (CTEs)

Advanced CTE Patterns

Capstone Project