
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.
Why choose Core Tech?
Course Insight
Suitable for intermediate learners. Works well as a continuation after mastering Software Development fundamentals. It bridges the gap toward advanced, production-level engineering.
SKILLS TO
MASTER
Quick Facts
What You’ll Learn
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.
Outcomes
- 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.
FAQs
Top Alternatives
Highly-rated courses worth your attention

