SQL Server: The complete course on Indexes (4 h of class)

Learn in this course how to set up a real indexing strategy on your tables to get better performance

3.55 (18 reviews)
Udemy
platform
English
language
Databases
category
130
students
3.5 hours
content
Jul 2023
last update
$39.99
regular price

What you will learn

Improve performance, through the implementation of indexes on your tables :)

Description

You have problems of slowness on your SQL servers, and you suspect the implementation of your indexes?

You haven't set up indexes on your tables, because you don't know the differences between a clustered and a non-clustered index? 

In this 4 hour course, come and discover the importance of a good index setup on your tables.

Don't go on a spending spree buying disk storage, when it may be the index setup that is wrong! It's simple, indexes are the first reason, of your performance improvements on a SQL server.

The training in detail:

  • The structure of a clustered and a non-clustered index.

  • The Table SCAN and the Table SEEK

  • The covering index and Why you should not index the whole table (Over indexing).

  • Remove duplicate indexes, and see the definition of a SINGLE index.

  • Remember to consolidate indexes, and the columnstore index.

  • Beware of filtered indexes and their associated cache plan, and see what is the term SARGABLE?

  • How to choose the right Clustered Index

  • Why fragmentation is important, and how to remove it

  • Tracking page splits and the FILLFACTOR definition

  • Rebuild Index Vs REORGANIZE and the ABORT_AFTER_WAIT option


This course is for all DBAs and developers who deal with performance optimization and want to use indexes to improve server performance.

Look at the average of my other courses (4.4/5), and you will see that my courses are quality courses :)

Take this course, will help you to stand out technically from your colleagues, or during a job interview.

I also made sure that the videos are not longer than 10 minutes, so that it's not too boring :)

Content

Introduction

What is a index ?
Setting up databases
Démo : Définition and création of a clustered index
Définition and création of a non clustered index
Démo : The table SCAN
Démo : The table SEEK
Démo : Do you know the covering Index ?
Démo : Be careful about the duplicate index !
Démo : Learn the INCLUDE clause on your index
Démo : Let's discover the UNIQUE index
Learn to consolidate your indexes!
Démo : Indexing and column order
Démo : Improve performance by deactivating the indexes
Démo : Filtered indexes and the cache plan
How to choice your clustered index ?
Avoid an index clustered on a NEWID column !

Performance Part 2 :Other performance topics

Do you know the term SARGABLE on SQL Server?

Screenshots

SQL Server: The complete course on Indexes (4 h of class) - Screenshot_01SQL Server: The complete course on Indexes (4 h of class) - Screenshot_02SQL Server: The complete course on Indexes (4 h of class) - Screenshot_03SQL Server: The complete course on Indexes (4 h of class) - Screenshot_04

Reviews

marionM
July 21, 2023
If you are looking for a course to progress quickly and easily, this is the one. The extra videos are really great, and the trainer very friendly. thanks again
Jonathan
October 25, 2022
This is not a good course. The explanations are not clear, the instructor is jumping around, his accent is WAAAYYY too thick. Maybe he can do a course in french. Not english. Waste of money and time. REFUND.
Mike12
July 26, 2022
Very good course, very fluid, it's perfect. I really like Mr. Thuillier's courses, they are of very high quality.
Matthew
May 31, 2022
What a wonderful course I really like this trainer, I follow all his courses, they are really high quality. I subscribed to his platform ELOA FORMATION, and I find all these courses for only 25 euros per year, I made a great deal :) thanks again!!!

Charts

Price

SQL Server: The complete course on Indexes (4 h of class) - Price chart

Rating

SQL Server: The complete course on Indexes (4 h of class) - Ratings chart

Enrollment distribution

SQL Server: The complete course on Indexes (4 h of class) - Distribution chart
3901978
udemy ID
3/9/2021
course created date
3/21/2021
course indexed date
Bot
course submited by