Welcome to ONLC Training Centers

MPP On-Demand: Querying Data with Transact-SQL (DAT201x) Course Outline

 (4 days)

*** Note: This is an On-Demand Self Study Class ***
You can take this class at any time; there are no set dates. It features hands-on labs so you can practice new skills at your workstation. Other parts of the course include video lectures that you can view on-the-go from your phone or tablet. In all cases, customers must call us directly to register this class at 800-288-8221.

MPP On-Demand Series
This course is part of the Microsoft Professional Program Series, MPP: Data Science Track and MPP: Big Data Track. It can be taken individually or as part of either 9-course series, plus a capstone project. You will need to purchase a validated certificate to get credit for this class as part of the MPP. Request the certificate at time of registration.

On-Demand Learner Profiles
MPP On-Demand is a self-study training solution that was designed for two types of learners. First, MPP On-Demand is a great fit for experienced IT professionals who don't need traditional 5-day classes to upgrade their existing skills. They can pick and choose topics to make the most effective use of their time. Second, MPP On-Demand is perfect for highly-motivated individuals who are new to a technology and need to space their learning over a period of weeks or months. These learners can take their time and repeat sections as needed until they master the new concepts.

Verified Certificate Included!
If you plan to use your course for job applications, promotions, or school applications, an MPP certificate will help you get recognized. The certificate is verifiable and is included in all MPP purchases. Itís also a great way to give yourself an incentive to complete the course and celebrate your success. For more information regarding Verified Certificates, go to
MPP Verified Certificates

From querying and modifying data in SQL Server or Azure SQL to programming with Transact-SQL, learn essential skills that employers need.

This Microsoft authorized class is an online elearning course that should take between 24 to 30 hours of effort, depending on your background.

Course Outline

Introduction to Transact-SQL
Lab 1: Introduction to Transact-SQL

Querying Tables with SELECT
Lab 2: Querying Tables with SELECT

Querying Multiple Tables with Joins
Lab 3: Querying Multiple Tables with Joins

Using Set Operators
Lab 4: Using Set Operators

Using Functions and Aggregating Data
Lab 5: Using Functions and Aggregating Data

Using Subqueries and APPLY
Lab 6: Using Subqueries and APPLY

Using Table Expressions
Lab 7: Using Table Expressions

Grouping Sets and Pivoting Data
Lab 8: Grouping Sets and Pivoting Data

Modifying Data
Lab 9: Modifying Data

Programming with Transact-SQL
Lab 10: Programming with Transact-SQL

Error Handling and Transactions
Lab 11: Error Handling and Transactions

View outline in Word


Attend hands-on, instructor-led MPP On-Demand: Querying Data with Transact-SQL (DAT201x) training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.

Microsoft Gold Partner
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Attend computer classes from ONLC Training Centers Request a copy via mail


Class Format
Class Policies
Student Reviews

Bookmark and Share

First Name

Last Name