DP-080: Querying Data with Microsoft Transact-SQL (01406)

Agenda

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