7-Day SQL Interview Preparation Plan
Your saved questions plus a day-by-day plan. Add questions with Save to → 7-Day Job Prep on any question page.
Day-by-day plan
Day 1Basics and query order
- Revise SELECT, WHERE, ORDER BY, CASE and NULL handling
- Explain logical query execution order aloud
- Practise DELETE versus TRUNCATE versus DROP answers
- Solve 10 easy practice problems
Day 2Joins
- Write inner, left, full, self and cross join examples
- Solve customers without orders and employee-manager problems
- Test ON versus WHERE in a LEFT JOIN
- Reproduce and fix a join fan-out issue
Day 3Aggregation and subqueries
- Practise GROUP BY, HAVING and conditional aggregation
- Solve duplicate detection and second highest salary
- Compare IN, EXISTS and NOT IN with NULLs
- Write one ROLLUP report
Day 4CTEs and window functions
- Rewrite a nested query using CTEs
- Practise ROW_NUMBER, RANK, DENSE_RANK on the same data
- Solve top N per group and running total problems
- Write a month-over-month growth query with LAG
Day 5Advanced problems
- Solve consecutive login days and sessionisation
- Build a recursive CTE for an org chart
- Write a retention cohort query
- Time yourself on three medium problems
Day 6Design and performance
- Revise keys, constraints and 1NF to 3NF with examples
- Design a schema for an e-commerce app on paper
- Read EXPLAIN output for three of your queries
- List ten query tuning techniques
Day 7Transactions and mock interview
- Revise ACID, isolation levels and deadlocks
- Write a transaction, upsert and simple procedure
- Prepare three STAR stories about SQL work
- Take a timed mock interview and review mistakes
Frequently asked questions
Can I prepare for a SQL interview in 7 days?
Seven days is enough to revise and sharpen, not to learn from zero. Use the plan to cover each core topic once, practise questions daily and finish with a mock interview.
How do I add questions to the plan?
On any question page choose Save to → 7-Day Job Prep. Saved questions show up at the top of this page.
How many hours a day should I study?
Two to four focused hours a day works for most people: one hour of revision, one to two hours of questions, and the rest on projects or mock answers.
Questions to practise each day
Company-wise SQL questionsExperience-wise SQL questionsRole-wise SQL questionsCity-wise SQL questionsMost asked SQL questionsScenario-based questionsPractical / hands-on questionsHR & behavioural questionsSQL mock interviewOnline assessment questionsTechnical round questionsManagerial round questionsSQL topic sheets