Reference
Cheat sheets, the interactive practice modules, class lectures, the original SQL lessons and earlier classroom activities. Nothing here is graded; Canvas has the assignments.
Database tables & cheat sheet
Every table and column in the database you are using, plus the SQL you need most. Printable.
OpenClass challenges
Twelve movie questions with a complete-result check. Good for warm-ups and exam practice.
OpenFirst interactive lecture
SQL, meet Rick & Morty: the guided eight-step introduction from the first week.
OpenFoundation examples
The September 10 demonstrations and try-it questions on SELECT and WHERE.
OpenFoundation studio
Short practice rounds on the basics, with a shared screen mode for class.
OpenTool basics: Excel
Sorting, filtering, formulas and pivot tables before the spreadsheet lab.
OpenPractice modules and class lectures
Each module has a class lecture to read and an interactive practice sequence in the browser: joins, CASE and UNION, CREATE TABLE and changes, analysis. Work through the steps in order or jump to one.
Choose useful columns, filter the right rows, and explain exactly what your result represents.
Move from individual records to totals, groups, and comparisons with a defensible denominator.
SQL functions & delivery evidence
Prepare for Lab 4: clean labels, read timestamps, handle missing senders, and trace package evidence with single-table SQL.
Read schemas, identify keys, and model relationships before combining or changing facts. Lab 13 adds a normalization workshop covering dependencies, anomalies, seven-table migration and reconciliation.
Answer questions across tables
Connect records with the right keys, preserve missing matches, and audit totals. Transfer Marathon pre-lab ideas to the Tool Library for Lab 8.
CASE & UNION: one report, many sources
Build Board Game Café business rules, preserve repeat activity, and reconcile reports across sources for Lab 9.
Predict the scope of a change, practice it on a disposable copy, and verify the outcome.
Develop and defend an analysis
Build readable reports and defend the results. Lab 11 covers views, ranking, running totals, LAG and transactions; Lab 12 adds CTE refactoring, recursive calendars, triggers and measured index experiments.
Original SQL lessons
The complete readings and exercises the learning path was built from. Use them when you want the long version of a topic.
Extra practice and workshops
Team investigations, SQL challenges and the desktop workshops. Optional, ungraded, and good for a second pass at a topic.