Indexes and the Microsoft SQL Server

Name: Indexes and the Microsoft SQL Server
Brand: Udemy
SKU: 59149
Price: 9.99 USD
Availability: InStock
Rating: 4.2 (5 reviews)

$9.99Track price

Harald Dobner 22 SQL Udemy

★★★★★

(5 customer reviews)

Description
Instructor Details
Additional information
Reviews (5)

8.1/10 (Our Score)

Product is rated as #163 in category SQL

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.

Instructor Details

Harald DobnerWirtschaftsinformatiker

Votes: 0

Courses : 1

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!

Specification: Indexes and the Microsoft SQL Server

Duration	1.5 hours
Year	2020
Level	Intermediate
Certificate	Yes
Quizzes	Yes

5 reviews for Indexes and the Microsoft SQL Server

4.2 out of 5

★★★★★

Write a review

Show all Most Helpful Highest Rating Lowest Rating

★★★★★
Squirrelpatrick – December 6, 2018
I feel that I have greatly improved my SQL knowledge after this relatively short course and highly recommend it. Harald is an excellent teacher.
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Patrick Chin – May 26, 2019
A good match with clear explanations. The Excel example walkthrough was especially helpful in reenforcing what indexes do.
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Paulo Luiz Siqueira – April 17, 2020
Exemplos e situa es de forma an loga, bem interessante.
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Carmelo L pez Ayala – June 20, 2020
A excellent course to learn about Indexes and how to apply them.
Helpful(0) Unhelpful(0)You have already voted this
★★★★★
Adam Bacon – March 10, 2021
Covers course at a nice pace, some gramatical errors, but nothing that has prevented me from understanding what is being said
Helpful(0) Unhelpful(0)You have already voted this