Wir beraten Sie gerne!
+49 40 253346-10     Kontakt

Online-Trainings im virtuellen Klassenraum,
E-Learning-Angebote und mehr

Jetzt informieren

SQL 2016 AlwaysOn High Availability (MOC 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

Dauer 3 Tage

Preis (exkl. MwSt.)
  • 1.990,- €
  • SA Voucher: 3
    hardcoded default SA
Digitale Kursunterlagen

Sprache der Kursunterlagen: Englisch

Classroom Training

Dauer 3 Tage

Preis (exkl. MwSt.)
  • Deutschland: 1.990,- €
  • SA Voucher: 3
    hardcoded default SA
inkl. Verpflegung
Verpflegung umfasst:

  • Kaffee, Tee, Saft, Wasser, Cola
  • Gebäck und Süßigkeiten
  • Frisches Obst
  • Mittagessen in einem der naheliegenden Restaurants

Gilt nur bei Durchführung durch Fast Lane. Termine, die von unseren Partnern durchgeführt werden, beinhalten ggf. ein abweichendes Verpflegungsangebot.


Digitale Kursunterlagen

Sprache der Kursunterlagen: Englisch

Kurstermine

FLEX Classroom Training (Hybrid-Kurs):   Kursteilnahme wahlweise vor Ort im Klassenraum oder online vom Arbeitsplatz oder von zu Hause aus.
Deutsch
Zeitzone MEZ
Online Training Zeitzone: Central European Time (CET)
Online Training Zeitzone: Central European Summer Time (CEST)
Online Training Zeitzone: Central European Summer Time (CEST)
Online Training Zeitzone: Central European Summer Time (CEST)
Online Training Zeitzone: Central European Summer Time (CEST)
Online Training Zeitzone: Central European Time (CET)
FLEX Classroom Training (Hybrid-Kurs):   Kursteilnahme wahlweise vor Ort im Klassenraum oder online vom Arbeitsplatz oder von zu Hause aus.
Deutschland
Berlin
Stuttgart
Düsseldorf
Münster
Frankfurt
Hamburg