Microsoft
Microsoft Logo

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 External Link Icon

Credential

Certificate

Write advanced Transact SQL queries
Table of content
Accordion Icon V3
  • Overview
  • Course Details
  • Curriculum
  • Entry Requirements
Details Icon

Write advanced Transact SQL queries
 at 
Microsoft 
Course details

What are the course deliverables?
  • 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
More about this course
  • 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

Write advanced Transact SQL queries
 at 
Microsoft 
Entry Requirements

Eligibility criteriaUp Arrow Icon
Conditional OfferUp Arrow Icon
  • Not mentioned

Other courses offered by Microsoft

Free
1 hours
Beginner
Free
3 hours
Intermediate
Free
14 hours
Beginner
Free
2 hours
Intermediate
View Other 1171 CoursesRight Arrow Icon
qna

Write advanced Transact SQL queries
 at 
Microsoft 

Student Forum

chatAnything you would want to ask experts?
Write here...