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

Pluralsight

SQL Server Performance: Indexing Basics

via Pluralsight

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.

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

Reviews

3.6 rating at Pluralsight based on 711 ratings

Start your review of SQL Server Performance: Indexing Basics

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.