0 to Hero SQL — Stage 3: Design and production
Constraints and types, indexes and query plans, isolation levels and locking, and the patterns a live database needs — upserts, keyset pagination, batched deletes and online migrations.
Twenty questions on the last stage: schema and types, indexes and plans, transactions and isolation, and the patterns a live database needs.
This is the stage where the two engines diverge most, and where the divergence is operational rather than syntactic — different defaults for isolation, different storage layouts, different things that happen when a migration fails halfway.
You get a score, not a list of what you missed.
Leaderboard
…
Grading happens on the server, so this part needs a connection.
Taking the quiz needs an account, so the score is yours and can reach the leaderboard. Sign in with GitHub or Google — reading this page does not need it.
Sign in if you want your score on this board.