Indexes and the Microsoft SQL Server
What you'll 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?
- What are execution plans and how are they read?
- What strategies exist to clean up existing systems?
- Where are the limits of indices?
Requirements
- You should be familiar with the Microsoft SQL Server.
- You should be able to write queries in SQL.
Description
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.
Who this course is for:
- Programmers or administrators who have performance issues with the SQL Server.
Instructor
- 4.2 Instructor Rating
- 228 Reviews
- 1,537 Students
- 3 Courses
Hi, ich heiße Harald und bin Wirtschaftsinformatiker.
Ich beschäftige mich jetzt seit 20 Jahren sowohl hauptberuflich, als auch freiberuflich mit IT-Themen und vor allem Programmierung.
Mein hauptberuflicher Schwerpunkt liegt im Bereich Payment und Transaktionsabwicklung. Im Speziellen die Massenabwicklung von SEPA Direct Debit Transaktionen. Falls Du da Probleme hast, kannst Du Dich gerne an mich wenden.
In meiner freiberuflichen Tätigkeit bin ich auch für andere Firmen tätig. Das Spektrum reicht von Schulungen, Beratung und Anforderungsmanagement bis zur Programmierung.
Meine übergreifenden Branchenkenntnisse und meine autodidaktische Seite helfen mir, mich gut in andere Personen hinein zu versetzen und mich auf die wesentlichen Punkte eines Problems oder dessen Lösung zu konzentrieren.
Von daher ist es jetzt auch höchste Zeit meine Kenntnisse als auch Online Trainer weiter zu geben.
Viel Spaß mit meinen Kursen.
---------------------------------------------------------------------------------------------------------
Hi, my name is Harald and I am an IT specialist.
I have been working full-time as well as freelance with IT topics and above all programming for 20 years.
My main focus is on payment and transaction processing. In particular, the mass processing of SEPA Direct Debit transactions. If you have problems there, feel free to contact me.
I am also a freelancer for other companies. I offer tutorials, consultations as well as requirement management and programming/coding.
My cross-sector knowledge as well as being autodidact, are of great advantage when getting to understand others, while focusing on the main issue of the problems and solutions.
And that being the facts, the time has come for me to offer my knowledge as an online trainer as well.
Please enjoy the courses!