We are happy to advise you!
+43 1 6000 880-0     Contact

SQL 2016 AlwaysOn High Availability (55246)

 

Course Overview

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.

Who should attend

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 ?click streams?. We assume the student is new to the technology and that the instructor is knowledgeable in it.

Prerequisites

Before attending this course, students must have:

  • Experience as SQL DBA
  • Experience as Windows IT PRO

Course Objectives

  • Understaand AlwasyOn High Availability
  • Employ Server 2016 Failover Clustering
  • Deploy SQL Failover Clusters
  • Work with Availability Groups
  • Perform maintenance
  • Monitor and Troubleshoot Availability Groups

Course Content

Introduction Always-on and High-Availability Concepts and Terminology Windows Server 2016 Failover Clustering SQL 2016 Failover Cluster Instances SQL 2016 Always-on Availability Groups The Dasboard Active Secondary Availability Group Actions Maintenance Monitoring and Troubleshooting Availability Groups

Online Training

Duration 3 days

Digital courseware
Classroom Training

Duration 3 days

Price (excl. tax)
  • Germany: 1,990.- €
  • SA Voucher: 3
    hardcoded default SA
incl. catering
Catering includes:

  • Coffee, Tea, Juice, Water, Soft drinks
  • Pastry and Sweets
  • Bread
  • Fresh fruits
  • Lunch in a nearby restaurant

* Catering information only valid for courses delivered by iTLS.


Digital courseware

Schedule

This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO). Until 30.06. we offer our courses also as online trainings.
Austria

Currently no local training dates available.  For enquiries please write to info@itls.at.

Germany
Berlin This is an German language FLEX course.
Time zone: Central European Time (CET)
Stuttgart This is an German language FLEX course.
Time zone: Central European Summer Time (CEST)
Düsseldorf This is an German language FLEX course.
Time zone: Central European Summer Time (CEST)
Münster This is an German language FLEX course.
Time zone: Central European Summer Time (CEST)
Frankfurt This is an German language FLEX course.
Time zone: Central European Summer Time (CEST)
This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO). Until 30.06. we offer our courses also as online trainings.
German
Time zone CET
Online Training This is an German language FLEX course.
Time zone: Central European Time (CET)
Online Training This is an German language FLEX course.
Time zone: Central European Summer Time (CEST)
Online Training This is an German language FLEX course.
Time zone: Central European Summer Time (CEST)
Online Training This is an German language FLEX course.
Time zone: Central European Summer Time (CEST)
Online Training This is an German language FLEX course.
Time zone: Central European Summer Time (CEST)