Microsoft SQL Server 2014 - Designing Solutions: Clustering and AlwaysOn


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/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.

Target Audience
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

Prerequisites
None

Expected Duration (hours)
2.5

Lesson Objectives

Microsoft SQL Server 2014 - Designing Solutions: Clustering and AlwaysOn

  • 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
  • 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
  • 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
  • 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
  • configure SQL Server infrastructure

    • Course Number:
    md_ddsa_a05_it_enus

    Expertise Level
    Intermediate