SQL Server: The complete course on Indexes (4 h of class)
Improve SQL server performance with proper index setup. Learn the differences between clustered and non-clustered indexes, covering indexes, and more. This course is perfect for DBAs, developers, and BI consultants looking to optimize their SQL queries and stand out technically. Don’t waste money on unnecessary disk storage when the issue may be with your index setup. Take this course and enhance your skills today!
What you’ll learn
- Improve performance, through the implementation of indexes on your tables 🙂
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 🙂
Who this course is for:
- 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
User Reviews
Be the first to review “SQL Server: The complete course on Indexes (4 h of class)”
You must be logged in to post a review.
There are no reviews yet.