


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
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.