Description
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
- Teacher : Vikas Munjal
- Language: English
- Level : All Levels
- Lectures : 79
- Duration : 9 hours and 0 minutes
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
Installation Guide
After Extract, view with your favorite player.
Subtitles: Englsih
Quality: 1080p
The 2026/1 version has increased the number of lessons by 30 and the duration increased by 3 hours 59 minutes compared to 2023/12.
Download link
File(s) password: www.downloadly.ir
File size
2.76 GB
