SQL Server TrackCourse 6 of 7

Microsoft SQL Server High Availability and Disaster Recovery

This course equips IT professionals and database administrators with the essential skills to design, implement, and manage robust HADR solutions using AlwaysOn Availability Groups, Windows Clustering, Failover Cluster Instances, Log Shipping, Replication, and Distributed Availability Groups. Learn how to safeguard your data against downtime and disasters, optimise failover processes, and maintain continuous business operations.

15 hours · 10 sessionsCAD $427Beginner to AdvancedHands-On Learning
Enrol in This Course

What you'll learn

  • Understand the core concepts of SQL Server High Availability and Disaster Recovery
  • Configure and manage AlwaysOn Availability Groups for seamless failover and disaster recovery
  • Set up and administer Windows Server Failover Clustering and SQL Server Failover Cluster Instances
  • Evaluate and select appropriate HADR solutions based on organisational needs and infrastructure

Prerequisites

SQL Server Database Administration and SQL Server Security and Protection recommended.

Part of the SQL Server Track

Master Microsoft's enterprise database platform.

7 courses · approx. 20–28 weeksBeginner to Advanced
View full track

Course Modules

8 modules · instructor-led, hands-on delivery

01Introduction to High Availability and Disaster Recovery (HADR)
02Always On Availability Groups
03Windows Server Failover Clustering (WSFC)
04SQL Server Failover Cluster Instances (FCI)
05Log Shipping
06Replication
07Comparing HADR Solutions
08Best Practices and Maintenance

Other courses in this track

01
Microsoft SQL Server Querying Data16 hours · 11 sessionsCAD $275
02
Microsoft SQL Server Database Development34 hours · 22 sessionsCAD $519
03
Microsoft SQL Server Database Administration28 hours · 19 sessionsCAD $427
04
05
Microsoft SQL Server Security and Protection13 hours · 9 sessionsCAD $325
06

Microsoft SQL Server High Availability and Disaster Recovery(current)

15 hours · 10 sessionsCAD $427

Ready to Enrol?

CAD $427 · Get in touch and we'll get you started in Microsoft SQL Server High Availability and Disaster Recovery.

Send an Enquiry