Understanding Execution Plans and Indexes in SQL Server

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

Requirements
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

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 topicsIndex Concepts in SQL ServerPage in SQL ServerExtent in SQL ServerHeap in SQL ServerClustered IndexNon Clustered IndexHeap with Non Clustered IndexIndexes are not very DeepComposite IndexIndex FragmentationIndex Creation using T-SQL CommandsIndex Rebuild and ReOrganizeFillFactorIncluded ColumnsData Type on Clustered IndexExecution PlanStatisticsActual Execution PlanEstimated Execution PlanCommon OperatorsTable Scan Index Scan Index Seek Key LookupRowID Lookup Nested Loop SortMerge JoinHash JoinCompute ScalarStream AggregateHash AggregateLeft Semi JoinRight Semi JoinLeft Anti Semi JoinRight Anti Semi JoinSegment Sequence ProjectLazy SpoolEager SpoolParallelism - Distribute Stream ,Gather Stream & Repartition StreamMore on Execution PlansHalloween ProblemExecution Plan of Insert OperationExecution Plan of Delete OperationExecution Plan of Update OperationSubtree cost related to ParallelismSubtree Cost of Stream and Hash AggregateIndex supports Wild CardPatterns to Note to Tune QueriesParameter Sniffing Parameter Sensitive Plan Optimization in Sql Server 2022MergeJoin PatternsHash Join PatternsKey Lookup PatternsSort Indicators Aggregate IndicatorsParallelism IndicatorsWarnings 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.