SQL 70-761 Preparation Exam

This app is a preparation quiz for the SQL exam: 70-761

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