Associate Professor
2 bookings across all services

Your SQL round is coming up and you don't have time to re-read a whole course? This 3-page cheat sheet has everything freshers get asked, in one place.
What's inside:
- The order SQL actually runs your query (the reason behind most interview errors)
- Everyday commands: WHERE, IN, BETWEEN, LIKE, IS NULL, CASE, COALESCE
- GROUP BY vs HAVING, with the one rule that avoids the most common error
- All joins in one table, plus the LEFT JOIN trap
- Subqueries and CTEs
- Window functions: ROW_NUMBER, RANK, DENSE_RANK, LAG, running totals
- 10 classic interview questions with tested answers: 2nd highest salary, duplicates, top earner per department, customers with no orders, running total and more
- 8 mistakes that cost freshers the job
Prepared by Dr. SVN Kumar, Associate Professor with 14+ years of teaching SQL. Instant PDF download. For more practice, see the 50-problem SQL Interview Practice Pack on this page.