SQL
Move from precise relational thinking to explainable analysis and safe, production-minded database work.
Curriculum
Phase 1Think Relationally0/3
Phase 2Ask Precise Questions0/3
Phase 3Shape Analytical Results0/3
Phase 4Work Safely at Scale0/3
Tables and Data Types
One meaning per row
Understand the building blocks and choices behind Tables and Data Types.
0 of 5 completeAppropriate column types
Use this part of Tables and Data Types in a realistic workflow.
0 of 6 completePrecision and timezone rules
Handle the boundaries and prove the result for Tables and Data Types.
0 of 7 completeKeys and Relationships
Primary and unique keys
Understand the building blocks and choices behind Keys and Relationships.
0 of 6 completeForeign key relationships
Use this part of Keys and Relationships in a realistic workflow.
0 of 5 completeDelete action choices
Handle the boundaries and prove the result for Keys and Relationships.
0 of 7 completeConstraints and Nullability
NOT NULL and CHECK
Understand the building blocks and choices behind Constraints and Nullability.
0 of 5 completeUnique business rules
Use this part of Constraints and Nullability in a realistic workflow.
0 of 5 completeThree-valued NULL logic
Handle the boundaries and prove the result for Constraints and Nullability.
0 of 8 completeSelection and Filtering
Explicit selected columns
Understand the building blocks and choices behind Selection and Filtering.
0 of 5 completeWHERE predicate choices
Use this part of Selection and Filtering in a realistic workflow.
0 of 6 completeDeterministic ORDER BY
Handle the boundaries and prove the result for Selection and Filtering.
0 of 7 completeJoins
INNER versus LEFT JOIN
Understand the building blocks and choices behind Joins.
0 of 5 completeComplete relationship keys
Use this part of Joins in a realistic workflow.
0 of 4 completeJoin fanout checks
Handle the boundaries and prove the result for Joins.
0 of 8 completeAggregation
GROUP BY output grain
Understand the building blocks and choices behind Aggregation.
0 of 5 completeAggregate NULL behavior
Use this part of Aggregation in a realistic workflow.
0 of 6 completeWHERE versus HAVING
Handle the boundaries and prove the result for Aggregation.
0 of 6 completeSubqueries and CTEs
Scalar and EXISTS subqueries
Understand the building blocks and choices behind Subqueries and CTEs.
0 of 5 completeNamed CTE stages
Use this part of Subqueries and CTEs in a realistic workflow.
0 of 5 completeWindow Functions
PARTITION BY and ordering
Understand the building blocks and choices behind Window Functions.
0 of 5 completeRanking with tie policies
Use this part of Window Functions in a realistic workflow.
0 of 5 completeExplicit running-value frames
Handle the boundaries and prove the result for Window Functions.
0 of 7 completeData Quality Checks
Duplicate business keys
Understand the building blocks and choices behind Data Quality Checks.
0 of 5 completeMissing and orphan records
Use this part of Data Quality Checks in a realistic workflow.
0 of 5 completeSource total reconciliation
Handle the boundaries and prove the result for Data Quality Checks.
0 of 7 completeTransactions and Mutations
BEGIN COMMIT ROLLBACK
Understand the building blocks and choices behind Transactions and Mutations.
0 of 5 completeAtomic dependent writes
Use this part of Transactions and Mutations in a realistic workflow.
0 of 5 completeConcurrent update behavior
Handle the boundaries and prove the result for Transactions and Mutations.
0 of 8 completeIndexes and Query Plans
EXPLAIN plan reading
Understand the building blocks and choices behind Indexes and Query Plans.
0 of 5 completeComposite index order
Use this part of Indexes and Query Plans in a realistic workflow.
0 of 5 completeRead and write costs
Handle the boundaries and prove the result for Indexes and Query Plans.
0 of 7 completeSchema Evolution
Versioned schema migrations
Understand the building blocks and choices behind Schema Evolution.
0 of 5 completeExpand backfill contract
Use this part of Schema Evolution in a realistic workflow.
0 of 5 completeCompatibility and recovery
Handle the boundaries and prove the result for Schema Evolution.
0 of 7 complete