Overview
-
- Module 1: Create tables, views, and temporary objects
- Create and query tables using Transact-SQL
- Create and query views using Transact-SQL
- Create queries using Common Table Expressions (CTE)
- Write queries that use derived tables
- Module 2: Combine query results with set operators
- Use the UNION operator.
- Use the INTERSECT and EXCEPT operators.
- Use the APPLY operator.
- Module 3: Write queries that use window functions
- Describe window functions.
- Use the OVER clause.
- Use RANK, AGGREGATE, and OFFSET functions.
- Module 4: Transform data by implementing pivot, unpivot, rollup, and cube
- Write queries that pivot and unpivot result sets.
- Write queries that specify multiple groups with GROUPING SET, CUBE, and ROLLUP.
After completing this module, you should be able to:
After completing this module, you’ll be able to:
After completing this module, you’ll be able to:
After completing this module, you'll be able to:
