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.
Course info
Level
Intermediate
Updated
Aug 13, 2019
Duration
2h 12m
Table of contents
Description
Course info
Level
Intermediate
Updated
Aug 13, 2019
Duration
2h 12m
Description

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.

About the author
About the author

Gail Shaw is a Data Platform MVP and holds the MCM certification for SQL Server. Her specialties are in performance tuning and database recovery for SQL Server. She is a frequent poster on the SQL Server Central forums, writes articles for both SQLServerCentral.com and Simple-Talk.com, and often speaks at SQLBits and the PASS Community Summit.

More from the author
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name's Gail Shaw. Welcome to my course on designing implementing Secret Server database in Texas. I'm a technical lead in the dead of solutions division intellect, software, they said. JOHANNESBURG, South Africa Good indexing is critical for well performing databases, but very few databases I see and production have anything resembling good indexing. Learning how to create indexes. Sport your database workload. We'll allow you to ensure that your applications are performing to their peak. In this course, we're going to have a look at several types of indexes that sequel server has. We're going to look at how to choose a clustered index on what the trade offs are for various choices there. Well, look a non classes and excess indexes. Would you created to support your workload? Well, look at index views and see where they're useful, and we'll look a column store and exits how they differ from traditional indexes on way they excel. By the end of this course, you'll be able to create effective indexes for almost any sequel server workload. This is an introductory course, so no prior experience in indexing is required, but you should be familiar with secrets over table sign and basic close familiarity with execution plans is about. I hope you'll join me on this journey to learn all about indexing with the designing and implementing Sequel Server database Indexes course at your site.