Udemy – Understanding Execution Plans and Indexes in SQL Server 2023-12

Understanding Execution Plans and Indexes in SQL Server course. This course helps participants improve the performance of Transact-SQL queries by analyzing Execution Plans and Indexes in SQL Server. This course is not designed for beginners and requires a basic knowledge of T-SQL commands. Key topics include index concepts such as Clustered and Non-Clustered Index, data structures such as Page and Heap, and index management techniques such as Rebuild and Reorganize. It also covers various Execution Plan operators such as Table Scan, Index Seek, and various Joins. Participants learn how to analyze Actual and Estimated Execution Plans, identify common problems such as Parameter Sniffing, and use optimization techniques in SQL Server 2022. This course teaches the skills needed to tune queries and improve database performance by providing practical examples and application patterns.

What you will learn

• They gain deeper knowledge about Clustered, Non-Clustered indexes, and Fragmentation concepts.
• They learn common execution plans.
• They learn to find patterns that may degrade query performance.
• This course helps participants fine-tune pre-written queries or write T-SQL in a better way.

This course is suitable for people who:

• Participants who have prior knowledge of T-SQL commands.
• This course is suitable for SQL Server developers, SQL Server DBAs, .NET developers who write T-SQL statements, data analysts, etc.

Course Description: Understanding Execution Plans and Indexes in SQL Server

• Publisher:  Udemy
• Instructor:  Vikas Munjal
• Training level: Beginner to advanced
• Training duration: 5 hours and 1 minute
• Number of lessons: 49

Course syllabus in 2024/12

Prerequisites for the Understanding Execution Plans and Indexes in SQL Server course

• 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

Course images

Sample course video

Download link

Download Part 1 – 1 GB

Download Part 2 – 899 MB

File(s) password: www.downloadly.ir

File size

1.8 GB