SQL Server Administration Part 3

Learn High Availability Solutions like Log Shipping, Database Mirroring, Replication and Always On Availability Group

4.46 (2302 reviews)

Udemy

platform

English

language

Databases

What you will learn

At the end of the course, the student will be able to understand, configure and monitor various high availability (HA) solutions such as log shipping, database mirroring, replication, peer to peer replication, and the great always on availability group technology. This experience will help the student gain a better understanding of how and when to utilize each technology depending on the needs of the company. This knowledge will enhance the opportunity for each student to progress faster within a company and promote his skill set to a higher level.

Why take this course?

This SQL Server Administration Part 3 course is designed for the student who has already taken or is taking Part 1 and Part 2, which are prerequisite courses. This course will cover High Availability solutions such as log shipping, database mirroring, replication, peer to peer replication and always on availability group technologies. Upon completing this course, the student will be well versed in configuring, managing, and monitoring virtually all tasks that a SQL SBA does in his daily, weekly and monthly duties. The materials that the student will need such as documents and SQL scripts will be provided via a zip file that the student requests via email. Upon completion of this course, the student will have the training, education and knowledge that a college provides in their courses about SQL Server Administration.

Reviews

Takeyasu

April 1, 2024

Very easy to understand and I believe this course will let me go to one stop forward. Thank you very much.

Timilehin

March 5, 2024

It's a good match for me taking this course ranging from the part 1, 2 and now 3. have learnt lot of things to straighten my path as a DBAs.

Farid

February 28, 2024

you should mention the permission for the cluster to create a computer to create a listener on AO HA other ways it will fail and i believe it`s very important point. Thank you

justin

January 30, 2024

Love the vids. Trying to save some money to get the rest of the videos but for now trying to get a Prod DBA job at the Casino I work at as they have an opening. I believe these videos can get you a Level one in a production DBA setting.

Pablo

January 4, 2024

This is my Third course with Rphael, and really hope to continue finding more courses done for him. THanks Raphael

November 17, 2023

Excellent tutor, I am happy to learn from this platform. Because this tutor teaches with very honesty.

Kannan

October 16, 2023

The steps are not matching when we do. And also skipping lots of steps in replication and mirroring concepts. Not satisfied.

Andreas

September 28, 2023

I have obtain all three parts together and I believe that these should not be available for sale as they are outdated. I was not able to find software like SQL SERVER 2014. There were several gaps between the videos and the whole lesson was not building up going from one point to the next, show how to move back and take another path. It was indicated how to do things but there was not a explanation why and when to choose one thing and not another I have learned things but that could have been done in less time and more organized

Dean

August 15, 2023

Good content .... server installation is a repeat of the earlier 2 courses ... understand why they are there but can be done much quicker now with the use of tools like Vagrant so be nice for this to be updated ... again :)

Nathan

July 21, 2023

The instructor is solid, I believe he did a really good job. As a consulting, and likely because this is a beginner course, he excluded, but getting the AG listener created is dependent on the ability of the service account to write to AD. And that is sometimes the most complicated especially with all the security hardening being implemented throughout companies.

RAVI

July 8, 2023

Excellent but not complete without monitoring and scenarios regarding replica and always-on. It would be more better if you add scenarios and monitoring videos.

Johnny

April 30, 2023

Great course, but Server 1 did not connect to the DC like the sequence of videos says. I spent over 3 hrs troubleshooting and was not able to join Server 1 to the DC. I was not able to follow along with rest of videos in the course with the hands-on portion.

Miranda

April 13, 2023

Enjoyed this course as well as Part 1 and Part 2. Very helpful and easy to understand the demonstrations being used.

Venkata

November 24, 2022

it is very good, you can make it excellent, by providing introduction using graphical PPT before you start hands-on working

Julia

October 25, 2022

Thank you for this course Raphael. I've learned a lot and even more. Thanks to your course my onboarding into DBA role went smooth and fast. I do really appreciate I could buy this course and get through these all lessons with you. Really good explanation, at least at the stage to become familiar with all mostly used functions and properties of SQL Server. I have just finished all 3 parts of the course and I became much more confident with my work now. With a great pleasure I will buy your another courses, like for SSRS. I would like to recommend this course to all of the people who has doubts if they are ready to become SQL DBA - after this course for sure you will be!

Charts

Price

Rating

Enrollment distribution

SQL Server Administration Part 3 - Distribution chart