SQL Always On High Availability with SQL 2016

Session Detail:    Classroom, Virtual 3 Day

This three-day instructor-led course is designed for database administrators and Windows engineers to familiarize them with the concepts in SQL AlwaysOn and High Availability. The course utilizes SQL 2016, but explains the differences from SQL 2012- SQL 2014.
We designed this course based on our experience of having taught hundreds of classes to literally thousands of students. We tried very hard to make the labs, of which there are over 30, very oriented to a single concept such as Adding a Replica or Transferring Logons. We did this because it is common in technical courses to write long labs with multiple exercises which in our opinion is not effective as they turn into clickstreams. We assume the student is new to the technology and that the instructor is knowledgeable in it.

Prerequisites

  • Experience as SQL DBA
  • Experience as Windows IT PRO

Who Can Benefit

Experienced DBAs, Windows Server pros, team leads. This is a lab intense course!
We designed this course based on our experience of having taught hundreds of classes to literally thousands of students. We tried very hard to make the labs, of which there are over 30, very oriented to a single concept such as Adding a Replica or Transferring Logons. We did this because it is common in technical courses to write long labs with multiple exercises which in our opinion is not effective as they turn into clickstreams. We assume the student is new to the technology and that the instructor is knowledgeable in it.

Session Outline

Class Outline

Module 1: Introduction

  • Lesson 1: Introduction

After completing this module, students will be able to:

  • Course introduction

Module 2: Always On and High Availability Concepts and Terminology

  • Lesson 1: Concepts and Terminology
  • Lesson 2: Table of Availability
  • Lesson 3: High Availability
  • Lesson 4: Causes of Downtime
  • Lesson 5: Planned downtime
  • Lesson 6: Unplanned downtime
  • Lesson 7: Disaster Recovery
  • Lesson 8: Recovery Time Objective (RTO)
  • Lesson 9: Recovery Point Objective (RPO)
  • Lesson 10: Recovery Level Objective (RLO)
  • Lesson 11: Storage Area Networks (SAN)
  • Lesson 12: Edition Changes from SQL 2012
  • Lesson 13: SQL Server 2014 Changes
  • Lesson 14: SQL Server 2016 Changes
  • Lesson 15: Legacy Solutions prior to Always On
  • Lesson 16: Failover Cluster Instances
  • Lesson 17: Log Shipping
  • Lesson 18: A Typical Log Shipping Configuration
  • Lesson 19: Monitor Server
  • Lesson 20: Replication
  • Lesson 21: Database Mirroring
  • Lesson 22: Database Mirroring Terminology
  • Lesson 23: Principle
  • Lesson 24: Mirror
  • Lesson 25: Witness
  • Lesson 26: Database Snapshots
  • Lesson 27: Limitations of legacy solutions:
  • Lesson 28: What do we mean by Always On?
  • Lesson 29: Table of Always On Comparison

After completing this module, students will be able to:

  • Terminology
  • SQL 2014 Changes
  • SQL2016 Changes
  • Understand the role of the SANS

Module 3: Windows Server 2016 Failover Clustering

  • Lesson 1: Understanding Failover Clustering in Server 2016
  • Lesson 2: Stateful High Availability Solution
  • Lesson 3: Supported in both Standard and Datacenter
  • Lesson 4: Servers should run similar hardware
  • Lesson 5: Should run the same edition
  • Lesson 6: Hyper-V best with datacenter
  • Lesson 7: Certified for Windows server logo
  • Lesson 8: Shared Storage
  • Lesson 9: Quorums
  • Lesson 10: Node Majority
  • Lesson 11: Node and Disk Majority configuration:
  • Lesson 12: Node and File Share Majority
  • Lesson 13: No Majority
  • Lesson 14: Configuration
  • Lesson 15: Cluster Networks Best Practices
  • Lesson 16: Connection to nodes to shared storage
  • Lesson 17: Private network for internal cluster
  • Lesson 18: Public network for client connections
  • Lesson 19: Cluster Aware Updating
  • Lesson 20: Virtual Machine Failover Clustering
  • Lesson 21: Preferred Owners
  • Lesson 22: Failover Failback
  • Lesson 23: Resources
  • Lesson 24: Dependences
  • Lesson 25: Heartbeat

After completing this module, students will be able to:

  • ISCSI Setup
  • Work with Roles
  • Understand Quorums
  • Understand Windows Failover
  • Understand Cluster Service
  • Understand Preferred Owners
  • Understand Node Majority

Module 4: SQL 2016 Failover Cluster Instances

  • Lesson 1: Failover Cluster Instance
  • Lesson 2: As A FCI Appears To A Client

After completing this module, students will be able to:

  • Cluster Testing
  • Understand Configuration Files
  • Install Clusters

Module 5: SQL 2016 Always On Availability Groups

  • Lesson 1: Availability Groups and Replicas
  • Lesson 2: Primary Replica
  • Lesson 3: Secondary Replicas
  • Lesson 4: Availability Group Listener
  • Lesson 5: Availability Mode
  • Lesson 6: Synchronous Commit Mode
  • Lesson 7: Asynchronous Commit Mode
  • Lesson 8: Failover Modes
  • Lesson 9: Automatic Failover Without Data Loss
  • Lesson 10: Automatic Failover Requirements:
  • Lesson 11: Manual
  • Lesson 12: Manual Failover Requirements
  • Lesson 13: Common Topologies

After completing this module, students will be able to:

  • Enable AlwaysOn
  • Understand and work with availability Groups

Module 6: The Dashboard

  • Lesson 1: The Dashboard
  • Lesson 2: How to view logs
  • Lesson 3: Using replication with Logins
  • Lesson 4: Using partially contained databases

After completing this module, students will be able to:

  • Understand the Dashboard
  • Perform Logon and Job replication

Module 7: Active Secondary Availability Group Actions

  • Lesson 1: Reporting with Secondary Replicas
  • Lesson 2: Configuring a Readable secondary
  • Lesson 3: Read-Only Routing
  • Lesson 4: Load Balancing
  • Lesson 5: Lab: Configure a Read-Only Secondary
  • Lesson 6: Database Backups with Secondary
  • Lesson 7: Steps of Backup Using secondary
  • Lesson 8: Backup Preference Options

After completing this module, students will be able to:

  • Perform backups with Secondary Replicas
  • Configure a Read-Only Replica

Module 8: Maintenance

  • Lesson 1: DBCC Checks
  • Lesson 2: Database Adding and Removing

After completing this module, students will be able to:

  • Add and Remove Databases
  • Add and Remove Replicas

Module 9: Monitoring and Troubleshooting Availability Groups

  • Lesson 1: The Dashboard in Depth
  • Lesson 2: Events
  • Lesson 3: Policy-Based Management for Availability Groups

After completing this module, students will be able to:

  • Change Owners
  • Work with Policies
  • Work with Extended Events

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 2016

3 Day
Classroom, Virtual

$2,295.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