Search 6,000+ CA Community College Courses

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Write advanced Transact-SQL queries

Microsoft via Microsoft Learn

Go to class Write review

Overview

  • Module 1: 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
  • Module 2: Combine query results with set operators

    • After completing this module, you’ll be able to:

    • Use the UNION operator.
    • Use the INTERSECT and EXCEPT operators.
    • Use the APPLY operator.
  • Module 3: 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.
  • Module 4: 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.

Syllabus

  • Module 1: 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
  • Module 2: 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
  • Module 3: 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
  • Module 4: 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

Tags

Reviews

Start your review of Write advanced Transact-SQL queries

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.