Querying Data with Transact-SQL exam 70-761 OEM Certkit

T-SQL Querying
Course: 2 Hours, 9 Minutes

Course Introduction
SQL Server 2016 Architecture Overview
SQL Server 2016 Editions and Components
SQL Server 2016 Functions and Capabilities
SQL Server Management Studio

Filter and Modify Data in SQL Server 2016
Course: 2 Hours, 21 Minutes

Course Introduction
SELECT Statements Overview
Writing SELECT Statements in SQL Server 2016
Calculated Expressions

Microsoft SQL Server 2016: Querying
Course: 2 Hours, 14 Minutes

Course Introduction
ORDER BY Clause
Sorting Data
Filtering Data
WHERE Clause
Predicates and Operators

Microsoft SQL Server 2016: Querying
Course: 1 Hour, 36 Minutes

Course Introduction
ORDER BY Clause
Sorting Data
Filtering Data
WHERE Clause
Predicates and Operators

Microsoft SQL Server 2016: Querying
Course: 2 Hours, 20 Minutes

Course Introduction
Aggregate Functions Overview
SUM Aggregate Function
AVG Aggregate Function
MIN Aggregate Function
MAX Aggregate Function
COUNT Aggregate Fuction
Aggregating Distinct Valuesnction
NULL and Aggregate Functions

Microsoft SQL Server 2016: Querying
Course: 1 Hour, 36 Minutes

Course Introduction
Subqueries Overview
Scalar Subqueries
Writing Effective Scalar Subqueries
Multi-valued Subqueries

Microsoft SQL Server 2016: Querying
Course: 1 Hour, 35 Minutes

Course Introduction
UNION vs. UNION ALL Operators
Writing Queries That Use the UNION Operator
Writing Queries That Use the UNION ALL Operator
Mixed UNION and UNION ALL Operators

Microsoft SQL Server 2016: Querying
Course: 1 Hour, 57 Minutes

Course Introduction
Understanding Stored Procedures
Using Stored Procedures
Input parameters
Output parameters
Table-valued Functions
Scalar-valued User-defined Functions
TRY...CATCH Error Handling
RAISERROR Statements

TestPrep 70-761 Querying Data with Transact SQL

 Test your knowledge on the skills and competencies measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.