Introduction to Transact-SQL
- Understand what SQL is for
- Identify database objects in schemas
- Identify SQL statement types
- Use the SELECT statement
- Work with data types
- Handle NULLs
- Lab: Work with SELECT statements
Sort and filter results in T-SQL
- Sort your results
- Limit the sorted results
- Return paged results
- Remove duplicates
- Filter data with predicates
- Lab: Sort and filter query results
Combine multiple tables with JOINs in T-SQL
- Describe join concepts and syntax
- Write queries that use inner and outer joins
- Write queries that use cross joins
- Write queries that use self-joins
- Lab: Query multiple tables with joins
Write Subqueries in T-SQL
- Understand what subqueries are
- Use scalar or multi-valued subqueries
- Use self-contained or correlated subqueries
- Lab: Use subqueries
Use built-in functions and GROUP BY in Transact-SQL
- Categorize built-in functions
- Use scalar functions
- Use ranking and rowset functions
- Use aggregate functions
- Summarize data with GROUP BY
- Filter groups with HAVING
- Lab: Use built-in functions
Modify data with T-SQL
- Insert data into a table
- Generate automatic values
- Update data in a table
- Delete data from a table
- Merge data based on multiple tables
- Lab: Modify data