README

See the official handouts on GitHub https://github.com/MicrosoftLearning/QueryingT-SQL

About

See the associated two pdfs for more information

Contents

Before You Start

Section 1: Modules 1-2

01 | Introduction to Transact-SQL

02 | Querying Tables with SELECT

Section 2: Modules 3-5

03 | Querying Multiple Tables with Joins

04 | Using Set Operators

05 | Using Functions and Aggregating Data

Section 3: Modules 6-8

06 | Using Subqueries and APPLY

07 | Using Table Expressions

08 | Grouping Sets and Pivoting Data

Section 4: Modules 9-11

09 | Modifying Data

10 | Programming with Transact-SQL

11 | Error Handling and Transactions

Final Exam & Wrap-Up