This Quiz is designed in order to prepare for the exam 761: Querying Data with Transact-SQL.

It covers the following topics:

Create Transact-SQL SELECT queries
Query multiple tables by using joins
Write queries with join statements based on provided tables, data, and requirements
Implement functions and aggregate data
Write INSERT, UPDATE, and DELETE statements;
Query data by using subqueries and APPLY
Determine the results of queries using subqueries and table joins
Evaluate performance differences between table joins and correlated subqueries based on provided data and query plans
Distinguish between the use of CROSS APPLY and OUTER APPLY,
Write APPLY statements that return a given data set based on supplied data
Query data by using table expressions
Group and pivot data by using queries
Use windowing functions to group and rank the results of a query
Construct complex GROUP BY clauses using GROUPING SETS, and CUBE
Query temporal data and non-relational data
Query historic data by using temporal tables
Query and output JSON data, query and output XML data
Create database programmability objects by using Transact-SQL
Create stored procedures, table-valued and scalar-valued user-defined functions, triggers and views
Distinguish between deterministic and non-deterministic functions; create indexed views
Implement error handling and transactions
Determine results of Data Definition Language (DDL) statements based on transaction control statements
Implement TRY…CATCH error handling with Transact-SQL, generate error messages with THROW and RAISERROR
Implement transaction control in conjunction with error handling in stored procedures
Implement data types and NULLs
Evaluate results of data type conversions