MOC 55246 A: SQL 2016 AlwaysOn High Availability

Catalog Home Databases, Business Intelligence & Data Science Microsoft SQL Server
Your Training Location:  

MOC 55246 A: SQL 2016 AlwaysOn High Availability

  Add Course To Watch List
  View Full Course Outline
  Request A Public Course
         In Your Area

  Request A Quote For A
        Private Class

Delivery Options & Status:
Instructor Led
Loading Course Dates...
No available dates in this city.

  Available by Request
{{date.date_begin | date:'M/d'}} - {{date.date_end | date:'M/d/yyyy'}}
ViewHide Additional Dates

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.

Before attending this course, students must have experience as SQL DBA and experience as Windows IT PRO.

3 Days/Lecture & Lab

This course is designed for experienced DBAs, Windows Server pros, and 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 “click streams”. We assume the student is new to the technology and that the instructor is knowledgeable in it.


  • AlwaysOn and High Availability Concepts and Terminology
  • Windows Server 2016 Failover Clustering
  • SQL 2016 Failover Cluster Instances
  • SQL 2016 Always On Availability Groups
  • The Dashboard
  • Active Secondary Availability Group Actions
  • Maintenance
  • Monitoring and Troubleshooting Availability Groups

< >

Course is eligible for vouchers

Copyright © 2021 ProTech Professional Technical Services, Inc. All Rights Reserved.

Sign In Create Account


Social Media