SQL Always On High Availability with SQL 2014

Session Detail:    Classroom 2 Day

This 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.

Prerequisites

There are no prerequisites for this course.

Who Can Benefit

This course is intended for SQL DBAs and IT Professionals.

Session Outline

Class Outline

Module 1: Course Overview

  • Lesson 1: Introduction
  • Lesson 2: Course Materials
  • Lesson 3: Facilities
  • Lesson 4: Prerequisites
  • Lesson 5: What We’ll Be Discussing

After completing this module, students will be able to:

  • Successfully log into their virtual machine
  • Have a full understanding of what the course intends to cover

Module 2: AlwaysOn and High Availability Concepts and Terminology

  • Lesson 1: Concepts and Terminology
  • Lesson 2: Edition Changes from SQL 2012
  • Lesson 3: Failover Clusters
  • Lesson 4: Log Shipping
  • Lesson 5: Replication
  • Lesson 6: Database Mirroring
  • Lesson 7: Database Snapshots

After completing this module, students will be able to:

  • Understand and utilize AlwaysOn and high availability concepts and terminology
  • Understand edition changes from SQL 2012
  • Understand failover clusters
  • Understand log shipping

Module 3: AlwaysOn

  • Lesson 1: SQL Failover Cluster Implementation
  • Lesson 2: Multi-Site Clustering
  • Lesson 3: Flexible Failover Policy

After completing this module, students will be able to:

  • Understand SQL failover cluster implementation
  • Understand multi-site clustering
  • Understand flexible failover policy
  • Understand and utilize AlwaysOn

Module 4: Understanding Quorums

  • Lesson 1: Node Majority
  • Lesson 2: Node and Disk Majority
  • Lesson 3: Node and File Share Majority
  • Lesson 4: No Majority
  • Lesson 5: Configuration

After completing this module, students will be able to:

  • Understand node majority
  • Understand node and disk majority
  • Understand node and file share majority
  • Understand no majority
  • Understand configuration options
  • Understand and utilize quorums

Module 5: AlwaysOn Availability Groups

  • Lesson 1: Application Failover
  • Lesson 2: Availability Group (AG)
  • Lesson 3: Availability Replica

After completing this module, students will be able to:

  • Understand application failover
  • Understand availability groups
  • Understand availability replicas
  • Understand and utilize AlwaysOn availability groups

Module 6: Secondary Availability Group Actions

  • Lesson 1: Active Secondary Replicas
  • Lesson 2: Readable Secondary Replicas
  • Lesson 3: Backups on Secondary Replicas

After completing this module, students will be able to:

  • Understand active secondary replicas
  • Understand readable secondary replicas
  • Understand backups on secondary replicas
  • Understand and utilize secondary availability group actions

Module 7: Monitoring

  • Lesson 1: Monitoring AlwaysOn Availability Groups
  • Lesson 2: Dashboard
  • Lesson 3: Troubleshooting Tools

After completing this module, students will be able to:

  • Understand how to monitor AlwaysOn Availability Groups
  • Understand how to utilize the Dashboard
  • Understand the tools available for troubleshooting

Need to train your team?

All of our sessions can be customized to meet your team’s specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

SQL Always On High Availability with SQL 2014

2 Day
Classroom

$1,090.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now