SQL Server Administration Part 3

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

4.63 (2620 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.

Loading charts...

Comidoc Review

Our Verdict

SQL Server Administration Part 3, with its deep dive into high availability solutions and clear explanation of various HA technologies, appeals particularly to aspiring or new DBAs who wish to upskill. Despite minor shortcomings such as a few outdated sections and the absence of failover clustering in this specific installment, the course's benefits far exceed any limitations.

What We Liked

Comprehensive coverage of SQL Server high availability solutions focusing on log shipping, database mirroring, replication, and Always On Availability Groups
Well-structured course, starting from basic concepts to more advanced HA topics in a sequential manner
Instructor's expertise in the field ensures depth and context for every topic discussed
Real-world examples help learners understand how these technologies are applied in actual use cases

Potential Drawbacks

Some users might find the course content outdated, particularly sections on software versions that need updating
A few users mentioned occasional mistakes by the instructor while demonstrating techniques that could potentially confuse beginners
Lack of hands-on practice for some lessons with complex configurations; it's suggested to follow along and practice simultaneously
Minimal coverage of failover clustering in this third part, which may prompt learners to look into other resources for a more complete understanding