Exam 70-761: Query data with advanced Transact-SQL Component
Learn how to query data using subqueries and table expressions, group and pivot data, and understand constraints in this comprehensive course. Perfect for anyone looking to build a career in Information Technology. Prior knowledge of Windows Operating System is required.
What you’ll learn
- How to Query Data Using Subquery and APPLY
- How to Query Data Using Table Expression
- About Group and Pivot Data
- What are Constraints
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
Who this course is for:
- Anyone who wants to build career in Information Technology. The subscriber needs to have working knowledge of Windows Operating System.
User Reviews
Be the first to review “Exam 70-761: Query data with advanced Transact-SQL Component”
You must be logged in to post a review.
There are no reviews yet.