Skip to content
UdemySqlPaid courseBeginner levelCertificate

SQL Server Administration Part 3 (Udemy.com)

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

Created by: Raphael Asghar

Last updated April 2020

icon
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.

icon
Course Description

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.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Raphael Asghar

Worked as a Production SQL Database Administrator and developer for over 15 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen.  Want to help those students that want more that the basic SQL Language.  Creating real life courses for those students who want a simple path to becoming a SQL DBA.  I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.

icon
More courses by Raphael Asghar

$11.99

$11.99

$69.99

$10.99

$10.99

$69.99

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

icon
Reviews

4.7

2,854 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Ricardo Ortiz on 11/13/2025

en lo relativo a sql todo es muy claro y muy practico, la documentación y teoría entendible. me resultó un poco complicado preparar el ambiente, por desconocimiento de los conceptos de redes. pero una vez teniendo eso listo el curso fluye a muy buen ritmo.

By Vivek Singh on 9/19/2025

A really great course. I feel Rapheal could have gone into more depth in Clustering and AG concepts. May be even talk about Distributed AG, which also really great feature. But all in all it is a good. Learnt a lot. Now I would revise what I have learnt in course 1,2,3 before jumping into any other future courses. Thanks!!!

By Zachary Reese on 8/27/2025

Key points were left out, such as needing at least three machines for a quorum to successfully transfer primary to a secondary server in WSFCs. In Raphael's set-up, only two machines are ever used within an AG. Lots of speaking mistakes throughout this course especially that made things hard to follow.

By Joel Lopez on 4/14/2022

it can be hard to find an instructor on these things that can resonate with and understand. The subject matter in itself can be complicated to someone with little to no experience with the concepts. follow along, take notes and practice, will leave with a much better understanding of this, also go back review, practice will be surprised of what can achieve.

By Daniel Alberto Romo Alonso on 2/26/2020

The course was great. However, regarding high availability technologies, I think it would have been very useful to know of some examples of different scenarios where one technology would be a better choice over the other ones. Specifically I couldn't get which are the most significant disadvantages of peer to peer replication since it was not included in the comparison table. I know we can later investigate that by ourselves but it would have been good to know the instructor's opinion based on his experience.

By Haritha Gurram on 12/18/2019

This is the only course that is available with perfect hands on for DR and HA. Truly loved it. No one will be disappointed for purchasing this series of SQL server. All the resources used in the videos are given in so Organized way. Oh! So many good things to say!!

By Casmir Azih on 8/22/2019

This is most definitely above expectation. I have been dabbling into database administration on my own, learning one topic and another from Youtube, but it was not making complete sense as to how those topics tie together to the skill set of a DBA. Taking Mr Asghar courses from TSQL from scratch and SQL Server Administration part 1 thru 3 completely gave me direction, and I feel seriously armed with knowledge to get a job as a DBA. But I will be continuing my education with you by looking into your other courses and purchasing your SSIS, SSRS and other relevant courses that will make me even better. Your style of teaching is awesome and it is amazing how you take complex topics and make it so easy that anybody can understand it. Thank you so much Mr Asghar.

By L Chowdhury on 9/18/2018

Raphael is the best DBA teacher I have ever come across. Love his teaching style. The only suggestion I have for the course is to improve video quality 1080p instead of 720p, kinda hard to watch these small fonts for so any hours on days. You will never regret taking his course.

By Rohit Ranjan on 5/31/2017

I have taken all of Raphael's courses. I would highly recommend his courses. Within months of taking his courses I got multiple offers for positions. I took a senior dB admin position and was immediately able to apply concepts in my job. Not only that, I was able to recommend different HA/DR solutions to my employers as well. Whether you are starting your career, looking for a career change or are looking to advance your career, his courses are a must. As he says in his lectures, set aside a little time for self reading from internet after taking his lectures, you will be amazed at the level of knowledge you'll gain. I wish all of you all the best and Raphael -- I cannot thank you enough. You are doing a great job with these, keep it up. Sincerely appreciated.

By Kwaku Bediako on 4/21/2017

I landed my first SQL Server DBA job in just 1 year after I started taking Raphael's courses. They are so in-depth and apply to the real world. If you dedicate some time to these courses and take them in the order that he suggests, you'll be a pro in SQL Server in no time. Order: Learn T-SQL, SQL Admin Part 1, SQL Admin Part 2, SQL Admin Part 3, SQL SSRS Part 1, SQL SSRS 2, SSIS, Mock Program Part 1, Learn Advanced T-SQL All the best as we continue to learn and broaden our knowledge! Cheers!!!!!!

Showing all 10 reviews on CourseDuck

Read all 2,854 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 94 / 100