SQL Server Performance: Indexing Basics
Offered By: Pluralsight
Course Description
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.
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
Related Courses
Database Administration and SQL Language BasicsA Cloud Guru PostgreSQL Administration Deep Dive
A Cloud Guru Administering an AlloyDB Database
Google via Google Cloud Skills Boost Advanced Data Modeling
Meta via Coursera Amazon Aurora MySQL - Migration (Korean)
Amazon Web Services via AWS Skill Builder