Indexes and the Microsoft SQL Server

Indexes and the Microsoft SQL Server

With time databases continue to grow. And along with this problems emerge. The response time is longer and longer, and meanwhile the user is falling asleep in front of their screen.

Indices can be used as accelerators, due to them assisting the database servers navigation through the existing data.Data can be found faster and the response time significantly reduced. It has occurred, that one or two well-chosen indices can reduce the response time of a query from several hours to a few minutes. This also has an impact on the used hardware. Which therefore can be considerably smaller, or rather reduce utilization.

Good knowledge of indices and their use are rare. but it’s potential yet enormous.

This course will teach you what indices are and how they can be applied. We will go over the different types of indices and we will also take a closer look at execution plans.

Upon completion of this course, you will be able to analyze exact situation on your SQL server and determine necessary improvements.

If you apply the knowledge of this course correctly, you can surely score at your next salary negotiation. 

Speed up your sql queries with a jetpack.

Url: View Details

What you will learn

• What indices are and how they work.
• What types of indexes exist and how do they work?
• How must indices be designed to maximally speed up queries?

Rating: 4.4

Level: Intermediate Level

Duration: 1.5 hours

Instructor: Harald Dobner