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

Write review
Coursera Ad

40% Off All Coursera Courses

Learn More → Corporate Finance Institute Ad

Get 35% Off CFI Certifications - Code CFI35

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it


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 712 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.

Sign up for free
Someone learning on their laptop while sitting on the floor.