Advertisements

SQL Server Queries Practice Tests: 199 Questions Explained

Advertisements
SQL Server T-SQL practice tests: joins, functions, grouping, subqueries, CTEs, window functions - every answer explained
1
1/5
(80) Ratings
0 students
Created by Vitalii Shumylo
Advertisements

What you'll learn

  • Check your T-SQL querying knowledge for Microsoft SQL Server across four tests
  • Find your weak areas: joins and filtering, functions and grouping, or window functions and programming
  • Learn why each wrong option is wrong, not just which option is right
  • Predict what a query returns – NULLs, duplicates, row order and error cases included
  • Practise under time pressure with a full mixed mock exam
This course includes:
199 questions on-demand video
1 articles
0 downloadable resources
1 lessons
Full lifetime access
Access on mobile and TV
Certificate of completion
Advertisements

Course content

Requirements

  • Basic SQL knowledge or some experience writing SELECT queries
  • No lab is needed to take the tests

Description

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.

Who this course is for:

  • Developers, data analysts and DBAs who write T-SQL queries for SQL Server
  • Learners preparing for a SQL Server or T-SQL job interview
  • Students of T-SQL and SQL Server querying courses who want to test what they learned
Advertisements
94024CE42896995770EB
Advertisements
Advertisements
Free Online Courses with Certificates
Logo
Register New Account