SQLiteracy · Advanced course · Plus
Window functions, set operations, CTEs, and a route-analysis capstone over 18 months of traffic.
For learners fluent in joins and GROUP BY. The 18-month data window exists for these modules: rankings, month-over-month and year-over-year change, moving averages, and eventually the route-analysis capstone.
This course ships with Plus, alongside the full course library. Browse the modules freely; the labs unlock when you upgrade.
Module 1 · ~20 min
Set operations and self-comparison
UNION, INTERSECT, EXCEPT, and the routes that only fly one way
Module 2 · ~22 min
Subqueries and CTEs
WITH clauses, staged thinking, and queries you can read next month
Module 3 · ~22 min
Window functions
Rankings, trends, and time, without collapsing your rows
Module 4 · ~22 min
Grain, scope, and honest averages
When an average answers a different question than the one asked
Module 5 · ~35 min
Capstone: the route analysis brief
One airport, six questions, every module you've finished
Finished the modules? Take the final exam: five fresh questions, no hints, and the SQLiteracy Advanced badge when you pass them all.
Start the examWondering what you've actually learned? Review your skills across every course.
Data: OurAirports (public domain) and U.S. Bureau of Transportation Statistics, T-100 Segment (public domain). Refreshed monthly.