Test series

SQL Interview Test Series

Ten timed mock tests that mirror real SQL interview rounds for .NET developers, from querying fundamentals to senior-level depth. The main dialect is SQL Server (T-SQL). Every mock mixes the topics interviewers actually ask about: joins and NULL behaviour, GROUP BY and HAVING, subqueries and CTEs, window functions (ROW_NUMBER, RANK, LAG/LEAD, running totals), set operators, indexes and sargability, execution plans, transactions and isolation levels, locking and deadlocks, normalization, keys and constraints, views, procedures and functions, query tuning, pagination, and classic puzzles such as the nth highest salary, duplicates, and gaps and islands. Questions combine theory, "what does this query return?", find-the-bug and pick-the-correct-query formats. Difficulty climbs from Mock 1 to Mock 10. Each answer comes with a full teaching explanation (sample data, result sets, tables and a 30-second interview answer) checked against Microsoft Learn and by running every query on SQL Server 2022. Mocks 1 and 2 are free, and Mocks 3–6 are live in Full Access. More mocks are being added: Mocks 7–10 will also be part of Full Access.

6 mock tests · 2 free · 90 questions · 2 h 15 min in all

Sign in to keep your scores and see how far you are in this series.