70-761: Querying Data with Transact-SQL eLearning

Course Description

In this instructor-led, online training course, students will be introduced to Transact-SQL. Students will be given a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

Exam Number: 70-761

Course Curriculum

Module 1: Introduction to Microsoft SQL Server
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 data types
Module 7: Using DML to modify data
Module 8: Using built-in functions
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