SQL 70-761 Preparation Exam

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
Read more
Collapse
Loading...

What's New

First Version
Read more
Collapse

Additional Information

Eligible for Family Library
Eligible if bought after 7/2/2016. Learn More
Updated
October 17, 2019
Size
3.9M
Installs
0+
Current Version
1.00
Requires Android
4.0 and up
Content Rating
Everyone
Permissions
Offered By
Nikolaos Katsogridakis
Developer
28, Korai str Chalkida 34100 GREECE
©2019 GoogleSite Terms of ServicePrivacyDevelopersArtistsAbout Google|Location: United StatesLanguage: English (United States)
By purchasing this item, you are transacting with Google Payments and agreeing to the Google Payments Terms of Service and Privacy Notice.