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