• Online, Self-Paced
Course Description

SQL Server AlwaysOn Availability Groups are built on Windows Server Failover Clusters and AlwaysOn Failover Cluster Instances (FCI). This course covers configuration of Windows Server Failover Clusters, SQL Server Failover Cluster Instances, and AlwaysOn Availability Groups. This course is part of a series of Skillsoft courses that covers the objectives for exam 70-465. This exam is required for the certification MCSE: Data Platform.

Learning Objectives

Windows Server Failover Clustering

  • start the course
  • identify the components of Windows Server Failover Clusters
  • identify the processes of Windows Server Failover Clusters
  • recognize the characteristics of Windows Server Failover Cluster quorum
  • identify the characteristics of Windows Server Failover Cluster storage
  • create a Windows Server Failover Cluster

SQL Server AlwaysOn FCI and Availability Groups

  • identify the interrelationship between AlwaysOn Availability Groups and clustering
  • list the prerequisites for AlwaysOn Availability Groups
  • identify the characteristics of active secondary replicas in AlwaysOn Availability Groups
  • identify the availability modes of AlwaysOn Availability Groups
  • identify the failover modes of AlwaysOn Availability Groups

Creating and Configuring Availability Groups

  • create an AlwaysOn Availability Group using the SSMS wizard
  • create an AlwaysOn Availability Group using the SSMS dialog box
  • create an AlwaysOn Availability Group using Transact-SQL
  • join a secondary replica to an AlwaysOn Availability Group
  • manage jobs and logins for an AlwaysOn Availability Group

Managing Availability Groups

  • perform a manual failover for an AlwaysOn Availability Group
  • suspend and resume an AlwaysOn Availability Database
  • remove a primary from an AlwaysOn Availability Group, and remove a secondary from an AlwaysOn Availability Group
  • take an AlwaysOn Availability Group offline
  • remove an AlwaysOn Availability Group

Practice: Clustering and AlwaysOn

  • configure SQL Server infrastructure

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.