Workspace Orientation and First Run
not startedUse the product without interface uncertainty; run, edit, check, and recover a first query.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Curriculum
Each module introduces one main idea, then fades scaffolding through prediction, guided edits, scratch SQL, debugging, and transfer.
A - Foundations
From local execution and first SELECT statements to precise one-table output contracts.
Tables, Rows, Columns, Keys, and Grain
not startedState row grain, distinguish identifiers from labels, and preview relationships.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M00 before this module.
SELECT and FROM
not startedRetrieve columns from one table and diagnose table or column identifiers.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M01 before this module.
Multiple Columns, Column Order, and Aliases
not startedMatch exact output contracts for columns, order, and report-friendly aliases.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M02 before this module.
Row-Level Expressions
not startedCreate arithmetic and text-derived values while preserving input row grain.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M03 before this module.
WHERE Comparisons and Precise Boundaries
not startedFilter source rows using equality and ordered comparisons with explicit boundary wording.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M04 before this module.
B - Filtering and Deterministic Output
Control surviving rows, null logic, duplicate semantics, and stable top-N output.
AND, OR, NOT, and Parentheses
not startedCompose Boolean conditions and make mixed precedence explicit.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M05 before this module.
IN, BETWEEN, and Range Semantics
not startedExpress membership, inclusive ranges, and half-open alternatives deliberately.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M06 before this module.
Text Matching and Normalization
not startedDistinguish exact text, patterns, case-insensitive matching, and deliberate normalization.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M07 before this module.
NULL and Three-Valued Logic
not startedReason about missing information with IS NULL and unknown Boolean results.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M08 before this module.
DISTINCT, ORDER BY, LIMIT, and Stable Top-N
not startedControl duplicate output tuples and deterministic sorted/limited results.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M09 before this module.
C - Expressions and Summaries
Move from row-level calculations to reliable grouped business metrics.
Scalar Functions, Types, and Casting
not startedApply scalar functions and explicit casts with type-sensitive behavior.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M10 before this module.
CASE, COALESCE, and Conditional Labels
not startedExpress ordered conditional logic and deliberate null fallback.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M11 before this module.
Aggregate Functions and Null Semantics
not startedSummarize filtered input with COUNT, SUM, AVG, MIN, and MAX correctly.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M12 before this module.
GROUP BY and Report Grain
not startedCreate one summary row per requested dimension and predict output grain.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M13 before this module.
HAVING, Conditional Aggregation, and Safe Ratios
not startedFilter groups, compute conditional metrics, and calculate safe rates.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M14 before this module.
D - Relational Reasoning
Plan relationship paths, joins, optionality, and fan-out-safe grain.
Keys, Relationships, Cardinality, and Join Planning
not startedPlan a join path and predict row multiplication before writing JOIN syntax.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M15 before this module.
INNER JOIN and Qualified Columns
not startedCombine matching rows on verified keys with readable aliases and qualified references.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M16 before this module.
LEFT JOIN, Missing Relationships, and Zero Counts
not startedPreserve unmatched left rows and calculate zero-related counts correctly.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M17 before this module.
Multi-Table Joins and Fact Grain
not startedNavigate multiple tables while preserving fact grain and metric source.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M18 before this module.
Fan-Out, Pre-Aggregation, Self Joins, and Non-Equi Joins
not startedDetect independent one-to-many fan-out and pre-aggregate to a common grain.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M19 before this module.
E - Query Composition
Use subqueries, existence checks, CTEs, and set operations with auditable stages.
Scalar and Set Subqueries
not startedUse nested queries when scalar or one-column set shape is clearest.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M20 before this module.
EXISTS, NOT EXISTS, and Correlation
not startedExpress presence and absence with correlated existence tests and null-safe anti-logic.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M21 before this module.
Common Table Expressions and Query Pipelines
not startedBuild readable multi-stage queries with named intermediate grains.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M22 before this module.
Set Operations and Compatible Result Shapes
not startedCombine and compare compatible result sets while controlling duplicate semantics.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M23 before this module.
F - Time and Analytical Windows
Analyze periods, cohorts, ranking, adjacent change, frames, and contribution.
Dates, Timestamps, Time Zones, and Half-Open Ranges
not startedFilter and calculate time using explicit type, zone, and boundary policy.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M24 before this module.
Period Grouping, Complete Calendars, Cohorts, and Retention Foundations
not startedCreate complete period series and calculate basic retention without dropping quiet periods.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M25 before this module.
Window Foundations and Ranking
not startedAdd partition context without collapsing detail rows and rank deterministically.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M26 before this module.
LAG, LEAD, and Period Change
not startedCompare rows to prior or next rows after staging at the intended grain.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M27 before this module.
Running Totals, Frames, Rolling Metrics, and Percent of Total
not startedUse explicit frames for cumulative and rolling calculations.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M28 before this module.
G - Reliability and Engineering
Debug systematically, change state safely, enforce integrity, and read basic plans.
Logical Processing Order, Systematic Debugging, and Data Quality
not startedDebug complex SQL by isolating stages, validating grain, and testing suspicious metrics.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M29 before this module.
INSERT, UPDATE, DELETE, and RETURNING
not startedMake targeted state changes and inspect affected rows inside rollback-safe checks.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M30 before this module.
Transactions, Constraints, and Upserts
not startedProtect multi-step changes with transactions and rely on constraints for integrity.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M31 before this module.
EXPLAIN, Index Fundamentals, and Query Quality
not startedRead basic plan shapes and form evidence-based optimization hypotheses.
- Lessons
- 0/2 independent
- Checkpoint
- 0%
Recommended prep: finish targeted work from M32 before this module.