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 OperationPassthrough property in Nested LoopSubtree 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 Patterns Aggregate Patterns Parallelism PatternsWarnings in Execution Plan