SQL Server Queries Practice Tests: 199 Questions Explained
Can you write correct T-SQL queries for Microsoft SQL Server - and predict what they return? These practice tests check the everyday querying knowledge of a developer, analyst or DBA: SELECT, joins and filtering, changing data, built-in functions, grouping, subqueries and table expressions, set operators, window functions, and the T-SQL programming behind stored procedures and transactions.
You get 4 practice tests with 199 questions in total (50, 50, 49, 50). Every question was checked twice before release: once by the author against the official documentation, and once by an independent reviewer who answered it blind - any disagreement was settled with a source.
What makes the explanations useful
Each answer tells you why the right option is right and why each wrong option is wrong. The wrong options are real features, commands and settings that are easy to pick by mistake - that is where most of the learning is.
How the tests are built
- Practice Test 1: T-SQL Fundamentals, Joins, Filtering and Modifying Data: T-SQL elements, logical query processing, SELECT, CASE, inner, outer, cross and self joins, predicates, sorting, TOP and OFFSET-FETCH, NULLs, data types, INSERT, UPDATE, DELETE and MERGE.
- Practice Test 2: Functions, Grouping, Subqueries and Set Operators: date, string and conversion functions, IIF, CHOOSE, ISNULL and COALESCE, aggregates, GROUP BY and HAVING, subqueries, EXISTS, views, derived tables, CTEs, UNION, INTERSECT, EXCEPT and APPLY.
- Practice Test 3: Window Functions, Pivoting and T-SQL Programming: OVER, PARTITION BY and window frames, ranking and offset functions, PIVOT and UNPIVOT, grouping sets, recursive CTEs, stored procedures, dynamic SQL, TRY...CATCH and transactions.
- Practice Test 4: Full Mock Exam: a mixed exam across all three areas - take it last, in one sitting.
Questions use single-answer and multiple-answer formats; the number of answers to pick is always stated. Suggested time: 75 minutes per test.
Versions: Microsoft SQL Server 2022 and SQL Server 2025 Transact-SQL (also valid for Azure SQL Database), SQL Server Management Studio and sqlcmd, as of October 2026.
Please note: these are original practice questions written by an instructor. This course is not affiliated with or endorsed by Microsoft; Microsoft SQL Server, Transact-SQL and Azure are Microsoft trademarks.
Affiliate disclosure: Course Kingdom participates in affiliate programmes (including Udemy via the Cuelinks network). Some links on this page are affiliate links — if you click and enroll, we may earn a small commission at no extra cost to you. Learn more.




