Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
- This content is a part of Create tables, views, and temporary objects.
After completing this module, you should be able to:
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
- Combine query results with set operators using Transact-SQL.
After completing this module, you’ll be able to:
Use the UNION operator.
Use the INTERSECT and EXCEPT operators.
Use the APPLY operator.
- This content is a part of Write queries that use window functions.
After completing this module, you’ll be able to:
Describe window functions.
Use the OVER clause.
Use RANK, AGGREGATE, and OFFSET functions.
- This content is a part of Transform data by implementing pivot, unpivot, rollup, and cube.
After completing this module, you'll be able to:
Write queries that pivot and unpivot result sets.
Write queries that specify multiple groups with GROUPING SET, CUBE, and ROLLUP.
