SQL Server Performance: Indexing Basics
Offered By: Pluralsight
Course Description
Overview
This course teaches you how to master the art of performance tuning SQL Server by better understanding indexes.
Indexes are the most crucial objects of the database. They are the first stop for any DBA and Developer when it is about performance tuning. There is good side as well evil side of the indexes. To master the art of performance tuning one has to understand the fundamentals of the indexes and the best practices associated with the same. This course is for every DBA and Developer who deals with performance tuning and wants to use indexes to improve the performance of server.
Indexes are the most crucial objects of the database. They are the first stop for any DBA and Developer when it is about performance tuning. There is good side as well evil side of the indexes. To master the art of performance tuning one has to understand the fundamentals of the indexes and the best practices associated with the same. This course is for every DBA and Developer who deals with performance tuning and wants to use indexes to improve the performance of server.
Syllabus
- Introduction 2mins
- Fundamentals of Indexing 22mins
- Practical Indexing Implementation Techniques 37mins
- Index Maintenance 16mins
- Introduction to Columnstore Index 8mins
- Indexing Practical Performance Tips and Tricks 24mins
- Checklist: Index and Performance 7mins
Taught by
Pinal Dave
Related Courses
MongoDB for DBAsMongoDB University MongoDB Advanced Deployment and Operations
MongoDB University 内存数据库管理
openHPI Data Cleansing with Data Quality Services (DQS)
Microsoft via edX Recovering Data in Azure and SQL Server
Microsoft via edX