

Write advanced Transact SQL queries
- Offered byMicrosoft
Write advanced Transact SQL queries at Microsoft Overview
Duration | 3 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Advanced |
Official Website | Explore Free Course |
Credential | Certificate |
Write advanced Transact SQL queries at Microsoft Course details
- Create tables, views, and temporary objects
- Combine query results with set operators
- Write queries that use window functions
- Transform data by implementing pivot, unpivot, rollup, and cube
- Learn how to use advanced Transact-SQL features to fetch and transform data in your databases
- Learn how to use Transact-SQL to create tables, views, and temporary objects for your databases
- Learn how to use Transact-SQL to combine query results
Write advanced Transact SQL queries at Microsoft Curriculum
Create tables, views, and temporary objects
Introduction
Create and query tables
Create and query views
Use temporary tables
Use Common Table Expressions
Write queries that use derived tables
Exercise: Create queries with table expressions
Knowledge check
Summary
Combine query results with set operators
Introduction
Use the UNION operator
Use the INTERSECT and EXCEPT operators
Use the APPLY operator
Exercise: Combine query results with set operators
Knowledge check
Summary
Write queries that use window functions
Introduction
Describe window functions
Use the OVER clause
Use RANK, AGGREGATE, and OFFSET functions
Exercise: Use window functions
Knowledge check
Summary
Transform data by implementing pivot, unpivot, rollup, and cube
Introduction
Write queries that pivot and unpivot result sets
Write queries that specify multiple groupings with grouping sets
Exercise: Pivoting and grouping sets
Knowledge check
Summary