Type
Virtual
Classroom ILT
Skill Level

Available dates
Learning Path
Virtual
Duration
1 Day

TYPE
Virtual
Classroom ILT
LEARNING PATH
SKILL LEVEL

DURATION
AVAILABLE DATES
Introduction:
This 3-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.
Audience profile:
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.
Pre-requisites:
Before attending this course, students must have the following technical knowledge:
- Experience as SQL DBA
- Experience as Windows IT PRO
Course Objectives
After completing this course, students will be able to:
- Understand AlwaysOn High Availability
- Employ Server 2016 Failover Clustering
- Deploy SQL Failover Clusters
- Work with Availability Groups
- Perform maintenance
- Monitor and Troubleshoot Availability Groups
Module 1: Introduction |
This module explains the course and objectives.
Lessons: |
|
Module 2: AlwaysOn and High Availability Concepts And Terminology |
This module will introduce the participants to the concepts and terminology used in the course.
Lessons: |
|
After completing this module, students will be able to: |
|
Module 3: Windows Server 2016 Failover Clustering |
Failover clustering is covered in this module and is a critical feature of AlwaysOn High Availability.
Lessons: |
|
Lab: Set up iSCSI Server
Lab: Install the iSCSI VMS Lab: Add Servers to Server Manager for Ease of Management Lab: Add the Windows Cluster Feature to SQL1, SQL2 And SQL3 Lab: Create the iSCSI Initators to add the shared storage Lab: Create the Windows Cluster Lab: Add a Clustered Service Lab: Test The Failover Of The Windows Service Lab: Delete Role Lab: Examine the Quorum Settings |
After completing this module, students will be able to: |
|
Module 4: SQL 2016 Failover Cluster Instances |
In this module we move from the generic failover clustering to the specifics involving SQL.
Lessons: |
|
Lab: Create A Configuration File By Running The Advanced Cluster Preparation Wizard
Lab: Complete The SQL Cluster Installation On SQL1 Lab: Install The Cluster On SQL2 And SQL3 Lab: Test the SQL Cluster |
After completing this module, students will be able to: |
|
Module 5: SQL 2016 AlwaysOn Availability Groups |
Within the failover clusters of SQL are the concept of Availability groups and their enhancements with the release of SQL 2016 which is the focus of this module.
Lessons: |
|
Lab: Create a SQL Instance For The Availability Group
Lab: Enable the SQL Server AlwaysOn Availability Group Feature Lab: Set Up For Availability Groups Lab: The Availability Group Wizard Lab: SSMS and Availability Groups |
|
After completing this module, students will be able to: |
|
Module 6: The Dashboard |
Managing AlwaysOn High Availability groups with SQL 2016 is accomplished with the Dashboard. This module will demonstrate the skills necessary for the accomplishment of the management tasks
Lessons: |
|
Lab: The Dashboard
Lab: Replicating Logins and Jobs Lab: Contained or Partially Contained Databases |
After completing this module, students will be able to: |
|
Module 7: Active Secondary Availability Group Actions |
Within Availability groups you may have Active secondary SQL which is covered and demonstrated in this module.
Lessons: |
|
Lab: Database Backup Using Secondary Replica
Lab: Configure a Read-Only secondary |
After completing this module, students will be able to: |
|
Module 8: Maintenance |
In this module you explore maintenance procedures for AlwaysOn High Availability Groups.
Lessons: |
|
Lab: Add a Database
Lab: Remove a Database Lab: Add a Replica Lab: Remove a Replica |
After completing this module, students will be able to: |
|
Module 9: Monitoring And Troubleshooting Availability Groups |
In this the final module you will learn how to monitor the clusters and Availability groups and various
common troubleshooting procedures. Lessons: |
|
Lab: Dashboard Wizards
Lab: Create an Extended Event Session Lab: Using T-SQL Lab: Policy based management for Availability Groups Lab: Observe a Policy In Action Lab: Create Three Conditions To Be Used In The RTO And RPO Policies Lab: Create Two Policies RTO and RPO Lab: Test The Policies Lab: Change Endpoint Owner |
After completing this module, students will be able to: |
|
Associated certifications and exam:
On successful completion of this course students will receive a Torque IT attendance certificate.

Microsoft overview
Skilled Microsoft engineers add significant value to the marketplace by reducing the cost of technology solutions whilst improving efficiency and fuelling innovation. Through authorized Microsoft training, Torque IT empowers engineers, developers and end-users to realise their full potential by providing them with the necessary knowledge and skills to optimise the adoption and use of Microsoft solutions.
Torque IT considers authorised Microsoft training to be an integral part of any Microsoft implementation. Microsoft authorised training, and associated certification, ensures that you get the most from your technology investment and that you are able to operate above the technology curve. Microsoft career certifications are universally recognised as demonstrating a high level of expertise and credibility for individuals and the organisations that employ them.
Authorized Microsoft training and certification is the industry standard for any solution that includes designing, selling, implementing, upgrading, managing, and operating Microsoft solutions.
For 19 years, Torque IT has maintained the status of Gold Learning Partner for Microsoft in South Africa. This is the highest level of accreditation that Microsoft awards to Learning Partners that specialize in technical, product, sales, development, end-user and solutions training.
These achievements reflect our commitment to providing our customers with quality skills development, enablement, training, and certification solutions that demonstrate exceptional depth, breadth, and expertise across Windows Server, Windows Client, Microsoft Virtualization, Microsoft Azure, Office 365, Exchange Server, SharePoint Server, Skype for Business, System Centre Server, Visual Studio and Microsoft Office technologies.
Torque is recognized by Microsoft, and the industry, as having met rigorous standards for educational competency, service, customer satisfaction and investment in Microsoft technologies that will prepare the next generation of IT industry professionals.