Quizzes
One quiz per module — 7 quizzes, 68 questions in total. Every question comes from a lesson, so anything you get wrong points at what to reread.
Foundations & querying — quiz
14 questions covering this module. Relational concepts, SELECT, filtering, sorting, nulls and duplicates.
Aggregation & summary — quiz
8 questions covering this module. Aggregate functions, GROUP BY, HAVING and conditional aggregation.
Combining data — quiz
12 questions covering this module. Every join type, multi-table joins, and set operations.
Functions & transformation — quiz
8 questions covering this module. String, numeric, date and null-handling functions.
Subqueries & CTEs — quiz
8 questions covering this module. Scalar subqueries, derived tables, WITH, and EXISTS versus IN.
Window functions — quiz
10 questions covering this module. OVER, partitioning, ranking, LAG/LEAD and running totals.
Creating & managing tables — quiz
8 questions covering this module. Data types, CREATE TABLE, INSERT/UPDATE/DELETE and views.