SQL Server Administration Part 2

Learn how to optimize, improve performance, review and analysis statistics, use monitoring tools, and create indexes

4.59 (2956 reviews)

Udemy

platform

English

language

Databases

What you will learn

At the end of SQL Administration Part 2, the student will be able to create indexes for to gain performance, use the SQL Profiler to find and trouble shoot expensive queries, use the activity monitor for analysis, deploy the performance monitor to find specific about SQL Server internals, use DTA utility, create and investigate issues with DMVs and extended events, look at SQL logs, monitor the health of the SQL Server more efficiently and much more.

Why take this course?

SQL Administration Part 2 will benefit the student by providing the necessary guide lines for enhancing SQL Server performance by utilizing indexes, reviewing DMVs for analysis, and setting up performance counters for gathering resource metrics; and also I will explain a handful of utilities to gather information about SQL Server internals, such as SQL Profiler, Database Tuning Advisor (DTA), Extended Events, SQL performance monitor, Activity monitor, and teach about partitions, creating contained database for recovery, reviewing SQL server logs and by installing SQL Server 2014 as the newer SQL version.The student will not only add to the knowledge gained bur SQL Administration Part 1, but get prepared for the next course SQL Administration Part 3 – the high availability solutions.

Reviews

Wojciech

January 14, 2024

Jestem zafascynowany przygotowaniem merytorycznym nauczyciela do kursu. Wspaniale rozpoczyna każda sesje poprzez wprowadzenie i kończy podsumowaniem. Mówi bardzo wyraźnie, co ważne jest dla ludzi, u których angielski nie jest językiem macierzystym. Wspaniale przygotowuje materiały dla studentów, aby mogli do nich wrócić po ukończonym kursie.

justin

January 8, 2024

Rafael is great explaining the content. Love how his videos are short but pack a lot of info with them.

Jason

September 7, 2023

Good content but presenters constant verbal fumbling caused confusion at times when he would say the wrong thing by mistake. It happens way too often.

Jhon

July 23, 2023

I appreciated how it built upon the knowledge gained in Part 1 and expanded on more complex concepts.

Andrei

July 21, 2023

The course is phenomenal. The instructor is knowledgeable and explains every single detail clearly and thoroughly. I feel a lot more confident now about my SQL Admin skills.

Carsten

May 30, 2023

Sehr umfangreich und gut erklärt. Es waren bis auf Übungen und Übungsfragen alles dabei, was ich erwartet hatte.

Pablo

May 24, 2023

Well the course is all the necessary information to give the initial steps to go more in detail about severals tools that SQL Server offer. And Obviosly to try by hands on experience.

Lamin

May 24, 2023

The course is very informative. It is given me a boost in my work place as the System and database administrator

Steve

May 11, 2023

Excellent presentation, articulate, useful. My only complaint - use powerpoint instead of freehand diagrams.

Nya

December 23, 2022

The ease at which the presenter is able the explain the concept of the course, makes understanding less cumbersome.

Adel

November 8, 2022

the best instractor i've ever had <3 love the way you teach honestly I can't imagine the amount of information i am getting everyday <3 God bless !!

Guilherme

November 7, 2022

Learned the most basic function of a real DBA in a corporate org. Really happy understanding what to look for in a Production Enviroment.

Rene

June 23, 2022

Learned a lot of basics for administrating SQL server, however now and then the video's are somewhat lenghty in showing the use of the gui, tha could be handled with less details.

Augustine

June 19, 2022

Its very helpful and to the point. However I do not know how to get the academic notes used in the lectures. Pls help

Chandraa

May 16, 2022

The Part2 course is really worth for me as per performance and knowledge. but if you provide the scripts and materials then it's much more easy to practice.

Charts

Price

Rating

Enrollment distribution

SQL Server Administration Part 2 - Distribution chart