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