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:
    Country: DE
    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

Austria

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

Germany
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)
Hamburg This is an German language FLEX course.
Time zone: Central European Time (CET)
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 Central European Time (CET)
Online Training Time zone: Central European Summer Time (CEST) 2 days Course language: German Guaranteed date!
Online Training Time zone: Central European Summer Time (CEST) 2 days Course language: German
Online Training Time zone: Central European Summer Time (CEST) Course language: German
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 Time (CET)
Guaranteed date:   iTLS will carry out all guaranteed training regardless of the number of attendees, exempt from force majeure or other unexpected events, like e.g. accidents or illness of the trainer, which prevent the course from being conducted.
Instructor-led Online Training:   This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
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.