Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Designing and Implementing SQL Server Database Indexes

via Pluralsight

Overview

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.

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.

Topics:
  • Course Overview
  • General Indexing Guidelines
  • Understanding Basic Index Architecture and Index Usage
  • Designing Indexes to Organize Tables
  • Designing Indexes to Improve Query Performance: Part 1
  • Designing Indexes to Improve Query Performance: Part 2
  • Designing Indexed Views
  • Designing Columnstore Indexes for Analytic Queries
  • Summary and Further Reading

Taught by

Gail Shaw

Related Courses

Reviews

Start your review of Designing and Implementing SQL Server Database Indexes

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free