MS-DP-080T00 - Querying Data with Microsoft Transact-SQL

This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

Student Testimonials

Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus. Student
Excellent presentation skills, subject matter knowledge, and command of the environment. Student
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect. Student

Click here to print this page »


Detailed Class Syllabus

Module 1: Getting Started with Transact-SQL

Introduction to Transact-SQL
Using the SELECT statement

Module 2: Sorting and Filtering Query Results

Sorting query results
Filtering the data

Module 3: Using Joins and Subqueries

Using JOIN operations
Using subqueries

Module 4: Using Built-in Functions

Getting started with scalar functions
Grouping aggregated results

Module 5: Modifying Data

Inserting data into tables
Modifying and deleting data