Understanding Execution Plans and Indexes in SQL Server

Focused View

Vikas Munjal

5:02:04

10 View

1 - Introduction

1 - Introduction.mp4

03:55

2 - Page in SQL Server.mp4

03:17

3 - Extent in SQL Server.mp4

04:12

4 - Heap in SQL Server.mp4

05:22

5 - Clustered Index.mp4

08:46

6 - Non Clustered Index.mp4

05:34

7 - Heap with Non Clustered Index.mp4

03:33

8 - Indexes are not very Deep.mp4

02:39

9 - Composite Index Part 1.mp4

07:06

10 - Composite Index Part 2.mp4

01:46

11 - Index Fragmentation.mp4

08:45

12 - More on Fragmentation.mp4

02:45

13 - Index Creation using TSQL Commands.mp4

13:27

14 - Index Rebuild and ReOrganize.mp4

02:58

15 - Index Fragmentation Practical.mp4

12:11

16 - FillFactor.mp4

05:27

17 - TSQL Command to introduce FillFactor in an Index.html

18 - Included Columns.mp4

05:42

19 - Data Type on Clustered Index.mp4

06:13

2 - Execution Plans

20 - What are Estimated Actual Execution Plans along with Statistics.mp4

06:57

21 - Download and Restore AdventureWorks Database.mp4

04:09

22 - Table Scan Operator.mp4

03:40

23 - Index Scan Operator.mp4

02:30

24 - Index Seek Operator.mp4

01:51

25 - Key Lookup RowID Lookup Nested Loop Operators.mp4

14:59

26 - Index supports Wild Card.mp4

05:31

27 - Sort in Execution Plan.mp4

07:58

28 - Merge Join Operator.mp4

05:46

29 - Hash JoinMerge Join Nested Loop Operators.mp4

16:43

30 - Compute Scalar Operator.mp4

06:12

31 - Stream and Hash Aggregate Operators.mp4

04:56

32 - Subtree Cost of Stream and Hash Aggregate.mp4

00:36

33 - Semi Joins Anti Semi Joins in Execution Plan.mp4

12:44

34 - Merge using Left Anti Semi Join in Execution Plan.mp4

05:33

35 - Execution Plan of Insert Operation.mp4

12:13

36 - Passthrough property in Nested Loop.mp4

09:13

37 - Execution Plan of Delete Operation.mp4

02:59

38 - Parallelism in Execution Plan.mp4

08:03

39 - Distribute Stream Gather Stream Repartition Stream.mp4

03:50

40 - Segment Operator Sequence Project Operators in Execution Plan.mp4

06:18

41 - Lazy Spool in Execution Plan.mp4

11:09

42 - Eager Spool and Halloween Problem Practical.mp4

10:04

3 - Patterns to Notice in Execution Plans

43 - Parameter Sniffing vs Parameter Sensitive Plan Optimization in Sql Server 2022.mp4

06:07

44 - Parameter Sniffing vs Parameter Sensitive Plan Optimization Practical.mp4

11:25

45 - Merge Join Patterns.mp4

04:34

46 - Hash Join Patterns.mp4

04:00

47 - Key Lookup Patterns.mp4

03:12

48 - Sort Aggregate Parallelism Patterns.mp4

03:47

49 - Warnings in Execution Plan.mp4

01:27

Description

Learn Basic to Advanced Level Training of Indexes and Execution Plans using T-SQL Commands in Microsoft SQL Server

What You'll Learn?

Participants will get deeper knowledge on Clustered ,Non Clustered Indexes & Fragmentation Concepts
Participants will learn commonly used Execution Plans
Participants will learn to find the patterns which may be slowing down the query performance
This course will Help Participant to tune already written query or write T-SQL in a better way

Who is this for?

The partitcipants who have prior knowledge of T-SQL commands.

This course is for SQL Server Developers , SQL Server DBAs, .NET Developers who writes T-SQL Commands , Data Analysts etc.

What You Need to Know?

RDBMS concepts should be known & should have good hands-on on T-SQL Commands

SQL Server 2022 (lower version can work also) and SQL Server Management Studio should be installed already

More details

Description
This course is not for beginners. One should have prior knowledge on T-SQL commands before enrolling into this course.The course contains the following topics
Index Concepts in SQL Server
Page in SQL Server
Extent in SQL Server
Heap in SQL Server
Clustered Index
Non Clustered Index
Heap with Non Clustered Index
Indexes are not very Deep
Composite Index
Index Fragmentation
Index Creation using T-SQL Commands
Index Rebuild and ReOrganize
FillFactor
Included Columns
Data Type on Clustered Index

Execution Plan
Statistics
Actual Execution Plan
Estimated Execution Plan

Common Operators
Table Scan
Index Scan
Index Seek
Key Lookup
RowID Lookup
Nested Loop
Sort
Merge Join
Hash Join
Compute Scalar
Stream Aggregate
Hash Aggregate
Left Semi Join
Right Semi Join
Left Anti Semi Join
Right Anti Semi Join
Segment
Sequence Project
Lazy Spool
Eager Spool
Parallelism - Distribute Stream ,Gather Stream & Repartition Stream

More on Execution Plans
Halloween Problem
Execution Plan of Insert Operation
Execution Plan of Delete Operation
Execution Plan of Update Operation
Subtree cost related to Parallelism
Subtree Cost of Stream and Hash Aggregate
Index supports Wild Card

Patterns to Note to Tune Queries
Parameter Sniffing
Parameter Sensitive Plan Optimization in Sql Server 2022
MergeJoin Patterns
Hash Join Patterns
Key Lookup Patterns
Sort Indicators
Aggregate Indicators
Parallelism Indicators
Warnings in Execution Plan

From this course you will learn how to read and understand execution plans which will help in tuning Transact SQL Commands

Who this course is for:
The partitcipants who have prior knowledge of T-SQL commands.
This course is for SQL Server Developers , SQL Server DBAs, .NET Developers who writes T-SQL Commands , Data Analysts etc.

User Reviews

Rating

average 0

Total votes0

Focused display

Having more than 15 Years of rich experience.Successfully self-employed, i am a trusted consultant for businesses large and small. Currently working as a Corporate Trainer & Consultant for SQL Server and Microsoft Business Intelligence . Also worked as a SQL Server Developer. Lives in Delhi,India.My style is to teach in such a way so that student should be able to create images or diagrams of the concept in his/her mind . Because i believe we understand , remember and learn all the things in pictures , diagrams or images . This is the science of learning.My Microsoft Certifications are:Microsoft Certified Solution Expert Data PlatformMicrosoft Certified Solution Expert Business IntelligenceMicrosoft Certified Solution Expert Data Management and AnalyticsMicrosoft Certified Solution Associate SQL Server 2012/2014Microsoft Certified Professional

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.