SQL for Data Engineers
Data engineers write SQL that runs every day without anyone watching it. These are real SQL problems from data pipelines - reports, joins, upserts, slow queries, dbt models - on a real database in a live cloud workspace.
How data engineering SQL differs from analyst SQL
An analyst query runs once and someone reads the answer. A pipeline query runs on a schedule, so it has to be correct at the right grain, idempotent when it runs twice, and fast as the data grows. Window functions, upserts and query plans matter more here.
18 challenges to practice
What to practice
Aggregation and window functions first, then joins (and why they multiply rows), upserts with ON CONFLICT, reading EXPLAIN ANALYZE, and modeling with dbt.
Do real production work, free. Live cloud workspaces in your browser - every project you complete lands on your portfolio.
Get started - free