SQL Question Sheets
Topic-wise SQL question sheets — 200 questions across 8 topics. Open each sheet online and tick questions as you solve them.
SQL Basics Interview Questions
Learn SELECT, WHERE, ORDER BY, LIMIT, data types, NULL handling, CASE, LIKE, DISTINCT and UNION, along with DDL, DML, DCL and TCL commands.…
Joins Interview Questions
Joins combine data from multiple tables. Practise inner, left, right, full outer, cross and self joins, plus semi and anti joins with EXISTS. Learn…
Aggregation and Grouping Interview Questions
Summarise data with COUNT, SUM, AVG, MIN, MAX, GROUP BY and HAVING. Learn conditional aggregation with CASE, ROLLUP and GROUPING SETS for subtotals,…
Subqueries and CTEs Interview Questions
Break complex problems into steps with scalar, list, table and correlated subqueries and Common Table Expressions. Learn IN versus EXISTS, the NOT IN…
Window Functions Interview Questions
Window functions are the most important advanced SQL topic in analyst and data engineer interviews. Master ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD,…
Database Design Interview Questions
Design reliable schemas with primary, foreign, unique and composite keys, constraints and normalisation from 1NF to BCNF. Understand denormalisation,…
Indexes and Performance Interview Questions
Make queries fast with clustered, non-clustered, composite, covering and unique indexes. Learn to read execution plans, write SARGable predicates,…
Transactions and Advanced SQL Interview Questions
Learn transactions, ACID properties, isolation levels, read anomalies, locking, MVCC and deadlocks. Work with views, materialised views, stored…
Frequently asked questions
What are question sheets?
Topic-wise lists of SQL interview questions with answers — 200 questions across 8 topics. Tick questions as you solve them; progress is saved in your browser.
Which sheet should I start with?
Start with SQL Basics, then Joins. Use the role-wise pages to see which topics matter most for the job you want.