DP-080T00 Querying Data with Microsoft Transact-SQL

Module 1: Introduction to Transact-SQL

– Understanding schemas

– Exploring the structure of SQL statements

– Examining the SELECT statement

– Working with data types

– Handling NULLs

Module 2: Sorting and Filtering Results in T-SQL

– Sorting results

– Limiting sorted results

– Paging results

– Removing duplicates

– Filtering data with predicates

Module 3: Combining Multiple Tables with JOINs in T-SQL

– Understanding join concepts and syntax

– Using inner joins

– Using outer joins

– Using cross joins

– Using self joins

Module 4: Writing Subqueries in T-SQL

– Understanding subqueries

– Using scalar or multi-valued subqueries

– Using self-contained or correlated subqueries

Module 5: Using Built-in Functions and GROUP BY in Transact-SQL

– Categorizing built-in functions

– Using scalar functions

– Using ranking and rowset functions

– Using aggregate functions

– Summarizing data with GROUP BY

– Filtering groups with HAVING

Module 6: Modifying Data with T-SQL

– Inserting data

– Generating automatic values

– Updating data

– Deleting data

– Merging data based on multiple tables