Practice database internals, not just SQL.
A correct query isn’t enough. On ten million rows, the wrong plan never finishes. QueryCrack runs every challenge on real MySQL 8 and grades it on the rows the engine reads. You learn indexes and query plans by hitting them.
Grading reads Handler_read_* session-status deltas from MySQL 8.0: the rows the storage engine actually touched. Never wall-clock time, never the planner estimate. Each challenge ships a fixed schema and indexes; a correct query that reads more rows than the budget gets TIME_LIMIT.
Challenges
- What are the categories of bugs we have? · Warm-up
- Count em bugs · Boss
- Find the title · Core
- The first deleted bug · Core
- Late or lost · Core
- Late at store 7 · Warm-up
- Late returns dashboard · Boss
- Everyone's latest report · Boss
- Load more · Core
- Find the most popular course · Warm-up
- Where did I rank? · Warm-up
- The iPhone X bug closest to New Year · Boss
- The five newest bugs · Warm-up
- Latest rentals from Egypt · Core
- A reporter's 2020 · Core
- Generate students grade report · Warm-up
- Find the top 100 students · Warm-up