Day 7 of 45 · SQL Masterclass · Free

Day 7: SQL Interview Day

Complete the 35-problem Phase 1 SQL exam and write post-mortem reviews for every missed question.

About 60 minutes of learning and 120 minutes of practice. It runs in your browser, with no install.

What you will be able to do

  • Solve DE1 SQL interview problems live under timed pressure without external hints.
  • Systematically classify and eliminate errors across syntax, join grain, NULL logic, and performance.
  • Defend query trade-offs and explain execution plans verbally to an interviewer.

Questions you should be able to answer afterwards

  • How do you solve a 'Top N per category' SQL problem cleanly?
  • How do you detect gaps and islands in user activity logs?
  • What is your step-by-step strategy when an interviewer presents a query with unexpected duplicate rows?

Practice this day's skills

Each page shows the idea moving, then lists problems from easiest.

Builds on Day 6.

Days 1 to 7 are free. Days 8 to 45 need a pass; the plan page lists what each day covers, and the glossary defines each term.