Course Catalog > Always On Availability Groups Boot Camp

Always On Availability Groups (AGs) is a popular choice for those who want highly available databases in a SQL Server instance. Prior to SQL Server 2016, AGs were limited to Enterprise Edition. With AGs now supported in SQL Server 2016 Standard Edition, it is more important than ever for everyone to understand how to plan, deploy, and administer AGs as anyone implementing SQL Server can now take advantage of this key feature

SQLHAU’s immersive Always On Availability Groups Boot Camp prepares attendees for success whether you are using SQL Server 2012, 2014, or 2016. Over the course of three days, students will learn:

  • How AGs work
  • How AGs are different from the other SQL Server availability features, and why AGs still matter in a world with virtualization and the public cloud
  • How to plan, deploy, and administer a Windows Server failover cluster, including quorum, since it is the foundation of all AG configurations
  • How to design AG solutions whether they are on premises (physical or virtual) or in the public cloud, including network, storage, multi-subnet/site, and hybrid configurations
  • How to take advantage of the additional capabilities offered by AGs such as backups and read only replicas
  • When and how to take advantage of Distributed Availability Groups
  • How to administer, monitor, and troubleshoot AGs
  • What is coming in SQL Server v.Next as it relates to AGs, including how Linux fits into the picture
  • Best practices, tips, and tricks that can be put to use immediately

No boot camp would be complete without hands on experience. Each student gets their own lab environment with virtual machines to work through lab exercises specifically designed to reinforce the instructional content, and provide experience based on real world scenarios. Where possible, the lab exercises offer multiple levels of difficulty since we recognize each student may be at different places in their experience with AGs.

Whether you are an accidental DBA or new to SQL Server, someone looking to brush up their existing skills, or just want to learn the latest and greatest, there is no better class for achieving your goals than Always On Availability Groups Boot Camp. Check our Events calendar to see when this class is being offered and register today. Don’t see it being offered? Contact us to inquire as to when it will be offered next, or let us know if you are interested in having us come onsite or want a virtual delivery.

Need More Info on why SQLHAU® Offers The Best Training?

If you would like to know more of what sets us apart from everyone else, download the document Benefits of Choosing SQLHAU® for Training. Share it with your manager if you need to justify coming to one of our classes.