YoVDO

Write advanced Transact-SQL queries

Offered By: Microsoft via Microsoft Learn

Tags

Transact-SQL (T-SQL) Courses Relational Databases Courses Data Transformation Courses Set Operators Courses

Course Description

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

Related Courses

Introduction to Databases
Meta via Coursera Intro to Relational Databases
Udacity Fundamentals of database systems
Indian Institute of Technology Kanpur via Swayam Capstone: Photo Tourist Web Application
Johns Hopkins University via Coursera Web Application Development: Basic Concepts
University of New Mexico via Coursera