Learning roadmap
Data & SQL Engineering
From analyst to data engineer: SQL that scales, models people trust, and pipelines that don't wake you up at 3 a.m.
5 stages~48 h
That leaves 5 stages, ~48 hours of focused work. You can clear it in any order, but the stages compound — try them top-to-bottom your first time.
- Conceptswindow-functionsctesset-operationsquery-plansindexesanti-joinsPractice quizzesLab task
Build a single-page SQL gym: an in-browser SQLite (sql.js) seeded with a mini e-commerce dataset, 12 graded challenges from JOINs to window functions, and instant result-checking with hints.
Build it in the LabCheckpointYou can take a 40-line analyst query, explain its plan, and rewrite it to run measurably faster — narrating every choice.
What you'll be able to do
- Write and review production-grade SQL — window functions, CTEs, and query plans hold no surprises.
- Design star schemas with the right grain — models analysts actually enjoy querying.
- Ship idempotent ELT pipelines where reruns are boring — exactly as they should be.
- Refactor SQL monoliths into tested, documented, lineage-tracked dbt-style models.
- Keep a warehouse fast, cheap, and trusted — and direct AI assistants to draft the SQL while you verify like a senior.
Or try a related path