Your Course Materials

Querying Data with Transact-SQL

Course Outline
Module 1, “Introduction to Microsoft SQL Server 2016"
Module 2, “Introduction to T-SQL Querying"
Module 3, “Writing SELECT Queries"
Module 4, “Querying Multiple Tables"
Module 5, “Sorting and Filtering Data"
Module 6, “Working with SQL Server 2016 Data Types"
Module 7, “Using DML to Modify Data"
Module 8, “Using Built-In Functions"

Course Outline
Module 9, “Grouping and Aggregating Data"
Module 10, “Using Subqueries"
Module 11, “Using Table Expressions"
Module 12, “Using Set Operators"
Module 13, “Using Windows Ranking, Offset, and Aggregate
Functions"
Module 14, “Pivoting and Grouping Sets"
Module 15, “Executing Stored Procedures"
Module 16, “Programming with T-SQL“
Module 17, “Implementing Error Handling”
Module 18, “Implementing Transactions”

Microsoft Certification Program
Get trained. Get certified.
Get ahead.
Microsoft Certifications demonstrate you have the skills to design, deploy, and optimize the latest technology solutions.
Ask your Microsoft Learning Partner how you can prepare for certification.
Also see:
http://www.microsoft.com/learning/
certification

Preparing for the Labs
Your lab activities will be centered around Adventure Works Cycles, a fictitious manufacturer and seller of cycles and related products.
To complete the labs, you will work in a virtual
machine (VM) environment.

Virtual Machine Environment
MIA-DC
MIA-SQL
MSL-TMG1
ADVENTUREWORKS.MSFT