MOC 20761 B: Querying Data with Transact-SQL

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 and 5 teach the remaining skills required to take exam 70-761.

5 Days/Lecture & Lab

The main purpose of the course is to give students 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. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.

  • • Introduction to Microsoft SQL Server 2016 • Introduction to T-SQL Querying • Writing SELECT Queries • Querying Multiple Tables • Sorting and Filtering Data • Working with SQL Server 2016 Data Types • Using DML to Modify Data • Using Built-In Functions • Grouping and Aggregating Data • Using Subqueries • Using Table Expressions • Using Set Operators • Using Windows Ranking, Offset, and Aggregate Functions • Pivoting and Grouping Sets • Executing Stored Procedures • Programming with T-SQL

Before taking this course, students should have a basic knowledge of the Microsoft Windows operating system and its core functionality, and a working knowledge of relational databases.

Copyright © 2017 ProTech. All Rights Reserved.

Sign In Create Account


Social Media