<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

SQL Server High Availability

Understand High Availability in SQL Server. Learn key terms, concepts, and Microsoft's options. Course covers explanations, demos of each option. Essential for DBAs.

  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

High Availability is a broad term used and misused throughout online and offline discussions about up-time and application availability. For the DBA, it is critical to understand this topic and the technological underpinnings of the high availability options Microsoft provides within SQL Server. This course will begin by explaining key terms and concepts surrounding the idea of high availability. Following that, every SQL Server high availability option will be discussed and demoed and, by the end of course, students will have a firm idea of what high availability tools are presented within SQL Server as well as how to deploy those tools.

Course Outline ( Free Preview)

High Availability - What you need to get started

Module 01 - Introduction to High Availability

Module 02A - Replication (Snapshot Replication)

Module 02B - Replication (Transactional Replication) 10 min.

Module 02C - Replication (Monitor Replication) 9 min.

Module 02D - Replication (Summary) 5 min.

Module 03A - Log Shipping (Setting Up Log Shipping to Single Secondary) 14 min.

Module 03B - Log Shipping (Setting Up Log Shipping Monitor Server) 7 min.

Module 04 - Database Mirroring 17 min.

Module 05 - Windows Server Failover Cluster 16 min.

Module 06A - Availability Groups (Setup and Configuration) 18 min.

Module 06B - Availability Groups (Additional Considerations) 10 min.

Module 07 - Basic Availability Groups 13 min.

Module 08 - Clustering SQL Server 19 min.

This course includes:

  • 3+ hours of training
  • 14 Modules
  • * Access on mobile and browser
  • Certificate of Completion