AlwaysOn Availability Groups End-to-End is an intermediate level course designed to provide an End-to-End knowledge of Availability Groups and how they can be used to achieve High Availability and/or Disaster Recoverability allowing the trainee to implement and monitor Availability Groups in the work place.
This 1-day course is instructor led with hands on lab sessions taking you through the following modules:
Course Outline
MODULE 1: Introduction to HA & DR
This module will provide an introduction to High Availability and Disaster Recoverability with Microsoft SQL Server giving you an overview of:
- What is High Availability
- What is Disaster Recoverability
- What are the 9’s
- What constitutes downtime
- Technologies
- Capabilities
MODULE 2: Introduction to Availability Groups
This module takes you through what Availability Groups are, how they came about in SQL Server and why you would consider using Availability Groups by considering the following:
- Where did they come from
- What are Availability Groups
- Why use Availability Groups
MODULE 3: Building Availability Groups
This module takes you from start to finish on building an Availability Group. It introduces you to what you need to think about and consider before undertaking the process of building and Availability Group through to how to perform a failover once it is built.
MODULE 4: Additional Availability Group Considerations
It is not a simple case that we build an Availability Group and it magically works for all scenarios. In this module we look at additional considerations that need to be considered and catered for to meet the requirements of the environment that will be using the Availability Groups. We will look at things like but not limited to:
- Backups
- Security
- SQL Server Features
MODULE 5: Monitoring Availability Groups
In This module we look at the different ways of monitoring Availability Groups to provide the different results required for an Administrator to stay on top of the environment.
MODULE 6: Availability Groups and the Cloud
With things rapidly changing, we need to know how Availability Groups work in a Hybrid or Cloud environment. In this module we will look at both scenarios.