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
