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
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.
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.
Instructor Details
- 4.7 Rating
2,854 Reviews
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.
More courses by Raphael Asghar
Learn T-SQL From Scratch For SQL Server Administrator (2020)
4.6 (2,904 Reviews)
Provider: Udemy
Time: 8.7h
$10.99
SQL Server Reporting Services Part 1 (SSRS) (2017)
4.6 (2,497 Reviews)
Provider: Udemy
Time: 6.1h
$69.99
More SQL courses
SQL - The Complete Developer's Guide (MySQL, PostgreSQL) (2025)
4.8 (2,153 Reviews)
Provider: Udemy
Time: 19.7h
$94.99
SQL Server High Availability and Disaster Recovery (HA/DR) (2026)
4.8 (1,810 Reviews)
Provider: Udemy
Time: 88.3h
$16.99
70-461 Session 3: Querying Microsoft SQL Server (T-SQL code) (2025)
4.8 (1,094 Reviews)
Provider: Udemy
Time: 3.6h
$12.99
Modern Event-Driven Spring Boot: Kafka & Spring Cloud Stream (2026)
4.8 (494 Reviews)
Provider: Udemy
Time: 13.4h
$10.99
Oracle Database 12c Backup and Recovery using RMAN (2024)
4.8 (428 Reviews)
Provider: Udemy
Time: 20.1h
$34.99
Reviews
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!!!!!!
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 94 / 100












