learnhero
ExplorePricingBlog
learnhero

Your goal, turned into a clear mission.

We use one cookie to remember how you found us.

PrivacyTermsFAQ
Sign inSign up
  1. Study plan
  2. /
  3. SQL interview in one week

SQL interview in one week: what to practice each day

A SQL screen tends to test a short list of patterns, under time, while you explain your thinking. A week is enough to drill them in order. Enter your interview date, and we'll map the days.

Quick fills

Days 1–2: JOINs and grouping.

INNER vs LEFT JOIN, what a WHERE on the right table does to a LEFT JOIN, self-joins, GROUP BY with HAVING. Write each from memory before checking.

Day 3: window functions.

ROW_NUMBER, RANK vs DENSE_RANK, LAG/LEAD, and the top-N-per-group pattern with a CTE.

Day 4: CTEs, subqueries, dates and NULLs.

Break multi-step questions into two or three CTEs. Practice NULL comparisons, COUNT(*) vs COUNT(column), and date truncation.

Days 5–6: timed sets and talk-through.

Medium questions at about 20 minutes each, said out loud: restate the question, name the output columns, write, then test edge cases (ties, NULLs, empty groups).

Day 7: redo misses, rest.

Redo every question you missed this week, from scratch. Stop early.

FAQ

What SQL topics come up in interviews?+–

Commonly JOINs, aggregation, window functions, CTEs and NULL/date edge cases. Check the job post and recruiter notes for the dialect and level.

Is a week enough?+–

If you've written SQL before, a week is enough to sharpen these patterns. If you're new to it, set a later date in the planner and add hours.

Should I practice out loud?+–

Yes. Screens often grade how you reason, not just the final query.

Build your SQL week from your interview date

Build my plan

Free preview, no account.

Related

  • Ace data interviews with confidence (ready-made mission; first lesson free, no account)
  • Data interview preparation