Microsoft SQL AlwaysOn and High Availability

Enhance your database administration skills with our Microsoft SQL AlwaysOn and High Availability course, designed specifically for SQL DBAs and IT Professionals to master high availability solutions using SQL 2014.

Course Thumbnail

Essential Skills Gained

Checkmark

Understand AlwaysOn and high availability concepts

Checkmark

Implement SQL failover clusters and multi-site clustering

Checkmark

Configure and utilize availability groups and replicas

Checkmark

Monitor and troubleshoot AlwaysOn environments effectively

Format

  • Instructor-led
  • 2 days with lectures and hands-on labs.

Audience

  • SQL DBAs
  • IT Professionals
  • Database Administrators
  • System Engineers

Description

This two-day instructor-led course is designed for database administrators to familiarize them with the concepts in SQL AlwaysOn and High Availability. The course utilizes SQL 2014, but explains the differences from SQL 2012.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Module 1: Course Overview

  1. Introduction

  2. Course Materials

  3. Facilities

  4. Prerequisites

  5. Course Overview

Module 2: AlwaysOn and High Availability Concepts and Terminology

  1. Concepts and Terminology

  2. Edition Changes from SQL 2012

  3. Failover Clusters

  4. Log Shipping

  5. Replication

  6. Database Mirroring

  7. Database Snapshots

Module 3: AlwaysOn

  1. SQL Failover Cluster Implementation

  2. Multi-Site Clustering

  3. Flexible Failover Policy

Module 4: Understanding Quorums

  1. Node Majority

  2. Node and Disk Majority

  3. Node and File Share Majority

  4. No Majority

  5. Configuration

Module 5: AlwaysOn Availability Groups

  1. Application Failover

  2. Availability Group (AG)

  3. Availability Replica

Module 6: Secondary Availability Group Actions

  1. Active Secondary Replicas

  2. Readable Secondary Replicas

  3. Backups on Secondary Replicas

Module 7: Monitoring

  1. Monitoring AlwaysOn Availability Groups

  2. Dashboard

  3. Troubleshooting Tools

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.