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

SQL Server: The complete course on Indexes (4 h of class), available at $34.99, has an average rating of 3.55, with 33 lectures, based on 19 reviews, and has 133 subscribers.

You will learn about Improve performance, through the implementation of indexes on your tables 馃檪 This course is ideal for individuals who are Future Database Administrators (DBA) or Developers who want to learn about the performance of their SQL query. or BI consultants who work on other technologies than SQL Server (Oracle etc) or Students who want to get started on SQL or Tech leads (CRM, Web etc..) who want to discover TSQL It is particularly useful for Future Database Administrators (DBA) or Developers who want to learn about the performance of their SQL query. or BI consultants who work on other technologies than SQL Server (Oracle etc) or Students who want to get started on SQL or Tech leads (CRM, Web etc..) who want to discover TSQL.

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

Summary

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

Price: $34.99

Average Rating: 3.55

Number of Lectures: 33

Number of Published Lectures: 31

Number of Curriculum Items: 33

Number of Published Curriculum Objects: 31

Original Price: 鈧?9.99

Quality Status: approved

Status: Live

What You Will Learn

Improve performance, through the implementation of indexes on your tables 馃檪

Who Should Attend

Future Database Administrators (DBA)

Developers who want to learn about the performance of their SQL query.

BI consultants who work on other technologies than SQL Server (Oracle etc)

Students who want to get started on SQL

Tech leads (CRM, Web etc..) who want to discover TSQL

Target Audiences

Future Database Administrators (DBA)

Developers who want to learn about the performance of their SQL query.

BI consultants who work on other technologies than SQL Server (Oracle etc)

Students who want to get started on SQL

Tech leads (CRM, Web etc..) who want to discover TSQL

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 馃檪

Course Curriculum

Chapter 1: Introduction

Lecture 1: Small explanation on the subtitles

Lecture 2: What is a index ?

Lecture 3: Setting up databases

Lecture 4: D茅mo : D茅finition and cr茅ation of a clustered index

Lecture 5: D茅finition and cr茅ation of a non clustered index

Lecture 6: Structure of the clustered index with a non clustered index

Lecture 7: D茅mo : The table SEEK

Lecture 8: D茅mo : The table SCAN

Chapter 2: Practical cases on indexing

Lecture 1: D茅mo : Do you know the covering Index ?

Lecture 2: D茅mo : Learn the INCLUDE clause on your index

Lecture 3: Learn to consolidate your indexes!

Lecture 4: D茅mo : Lets discover the UNIQUE index

Lecture 5: D茅mo : Indexing and column order

Lecture 6: D茅mo : Be careful about the duplicate index !

Lecture 7: D茅mo : What is the OVER indexing ?

Lecture 8: D茅mo : In search of the perfect index

Lecture 9: D茅mo : Improve performance by deactivating the indexes

Lecture 10: Avoid an index clustered on a NEWID column !

Lecture 11: D茅mo : What is a filtered index ?

Lecture 12: D茅mo : Filtered indexes and the cache plan

Lecture 13: How to choice your clustered index ?

Lecture 14: D茅mo : The index columnstore

Lecture 15: D茅mo : Lets a create a indexed view !

Chapter 3: Fragmentation on indexes

Lecture 1: Why is fragmentation important?

Lecture 2: Example of fragmentation

Lecture 3: D茅mo : Tracking page splits

Lecture 4: What is the FILLFACTOR?

Lecture 5: Rebuild Index Vs REORGANIZE

Lecture 6: REBUILD INDEX with the option ABORT_AFTER_WAIT

Chapter 4: Performance Part 2 :Other performance topics

Lecture 1: Do you know the term SARGABLE on SQL Server?

Chapter 5: Conclusion on the Index

Lecture 1: Conclusion

Instructors

ELOA FORMATION | SQL | Postgres | Powershell| MySQL | Python | TSQL Administration,TSQL, and SQL Server performance.
Join the masterclass SQL Server course !

Rating Distribution

1 stars: 3 votes

2 stars: 1 votes

3 stars: 3 votes

4 stars: 4 votes

5 stars: 8 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!