Exam 70-761: Query data with advanced Transact-SQL Component - Udemy
In this course, you will learn-
· Query Data Using Subquery and APPLY
· Query Data Using Table Expression
· Group and PIVOT Data using Query
· Understanding Constraints
Sub-topics:
Query Data Using Subquery and APPLY
· Introduction to Subqueries
· Self-Contained Subqueries
· Co-related Sub Queries
· Using EXISTS predicate with subqueries
· Using APPLY
Query Data Using Table Expression
· Derived Table
· CTE (Common table expression)
· View
· TVF (Table valued function)
Group and Pivot Data
· Grouping sets
· Cube
· Rollup
· Handling and distinguishing NULLs in Result SET
· Introduction to Window Functions
· Window Aggregate Function
· Window Ranking Function
· Windows Offset Function
· Window Pivot/UnPivot Function
Constraints
· Types of constraints
· Unique
· Not NULL