SQL for Real-World Data
16 lessons. Query synthetic data with SQLite: joins, grouped reports, CTEs, windows, and useful data-quality checks.
For learners who can read a table and follow basic programming examples. SQLite runs in your browser. Written lessons, at your own pace.
All standard catalog courses are included in the course purchase.
01Tables, rows, and output contractsSelect named columns while preserving the intended row grain.Free preview02Filtering with precise predicatesCombine filters without changing the requested boundaries.Free preview03NULL and missing valuesDistinguish SQL NULL from empty text and ordinary values.Course04Ordering, ties, and paginationProduce stable top-N and paginated results.Course05Expressions and safe normalizationCalculate output fields and apply only the stated normalization.Course06Aggregates and empty inputDefine how summaries handle missing values and empty tables.Course07Grouping and HAVINGChange the result grain and filter grouped summaries.Course08Joins and unmatched recordsChoose join behavior and count matches correctly.Course09Subqueries and existenceUse a scalar summary or a correlated existence test.Course10CTEs as named stagesCompose intermediate results with explicit grains.Course11Window functions and framesAdd ranks and running totals without collapsing rows.Course12Calendar dates and half-open rangesGroup fixed-format dates and select nonoverlapping periods.Course13Deduplication and deterministic winnersSeparate distinct values from selecting a representative record.Course14Data-quality checks as reportsIdentify missing and duplicate values without destructive repair.Course15Reports with stable schemasBuild summaries that retain zero groups and fixed counters.Course16Repeatable multi-stage SQL pipelinesPrevent join multiplication and validate report invariants.Course
Learn it. Then put it to work.
Pair the course with 42 challenges, progressive hints, and worked solutions.
Explore the complete bundle