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.

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.


After completing this course, students will gain the skills to:

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


  • Experience as SQL DBA
  •  Experience as Windows IT PRO

Onsite training?

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.

User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

Next Step

Enquire Now
Tell a Friend
Email Course Outline