55246: SQL Always On High Availability with SQL 2016

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Mar 13, 202309:0005:00EDTIn Class or by Video Conference3$2,695 USDPurchase
Apr 3, 202309:0005:00EDTIn Class or by Video Conference3$2,695 USDPurchase


55246

SQL AlwaysOn High Availability with SQL 2016

This 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. The design for the course was based on better experiences with single-concept labs, such as Adding a Replica or Transferring Logons. The assumption is that you are new to the technology and that the instructor is knowledgeable in it.

Duration: 3 Days

Prerequisites

  • Experience as a SQL Database Administrator
  • Experience as a Windows IT Professional

Audience

  • Experienced Database Administrators
  • Experienced Windows Server Professionals
  • Experienced Team Leads

Learning Objectives

  • Understand AlwaysOn High Availability
  • Employ Windows Server 2016 failover clustering
  • Deploy SQL 2016 failover clusters
  • Work with availability groups
  • Perform maintenance
  • Monitor and troubleshoot availability groups

Topics

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