Microsoft SQL Server 2014 – Designing Solutions: Clustering and AlwaysOn

Database professionals who design and build database solutions, create plans and designs for database structure, storage, objects and servers, and plan the environment in which the database solutions run

Prerequisite
None

Expected Duration
151 minutes

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.

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.