When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Designing and Implementing SQL Server Database Indexes
This course is an introduction to SQL Server indexes. In this course, you will be covering common index types and discussing how to index to support your workloads.
This Course Includes
pluralsight
4 (146 reviews )
2 hour 11 minutes 
english
Online - Self Paced
core courses
pluralsight
About Designing and Implementing SQL Server Database Indexes
Poor database performance is a problem for applications and annoys users. Poor performance often comes down to poor indexing of critical tables. In this course, Designing and Implementing SQL Server Database Indexes, you'll gain knowledge on how to avoid these issues through the effective use of SQL Server database indexes. First, you'll discover the main index types that SQL Server has. Next, you'll explore considerations for their use. Finally, you'll learn how to choose indexes and index keys to best support your applications. When you've finished this course, you'll be in a good position to optimize all of your SQL Server databases and improve your applications' speed and throughput.
What You Will Learn?
- Course Overview : 1min.
- General Indexing Guidelines : 6mins.
- Understanding Basic Index Architecture and Index Usage : 11mins.
- Designing Indexes to Organize Tables : 18mins.
- Designing Indexes to Improve Query Performance: Part 1 : 33mins.
- Designing Indexes to Improve Query Performance: Part 2 : 18mins.
- Designing Indexed Views : 12mins.
- Designing Columnstore Indexes for Analytic Queries : 23mins.
- Summary and Further Reading : 7mins.