Microsoft SQL Server 2014 – Designing Solutions: Clustering and AlwaysOn

This course is included in our On-demand training solution.

Overview

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

150 min.

Course Objectives

Course Introduction

WSFC Overview

  • identify the components of Windows Server Failover Clusters
  • WSFC Processes

  • identify the processes of Windows Server Failover Clusters
  • WSFC Quorum

  • recognize the characteristics of Windows Server Failover Cluster quorum
  • WSFC Cluster Storage

  • identify the characteristics of Windows Server Failover Cluster storage
  • Creating a Failover Cluster

  • create a Windows Server Failover Cluster
  • AlwaysOn Clustering

  • identify the interrelationship between AlwaysOn Availability Groups and clustering
  • AlwaysOn AG Prerequisites

  • list the prerequisites for AlwaysOn Availability Groups
  • Active Secondary Replicas

  • identify the characteristics of active secondary replicas in AlwaysOn Availability Groups
  • Availability Modes

  • identify the availability modes of AlwaysOn Availability Groups
  • Failover Modes

  • identify the failover modes of AlwaysOn Availability Groups
  • AlwaysOn AG: SSMS Wizard

  • create an AlwaysOn Availability Group using the SSMS wizard
  • AlwaysOn AG: SSMS Dialog box

  • create an AlwaysOn Availability Group using the SSMS dialog box
  • AlwaysOn AG: T-SQL

  • create an AlwaysOn Availability Group using Transact-SQL
  • Joining a Secondary Replica

  • join a secondary replica to an AlwaysOn Availability Group
  • Managing Jobs and Logins

  • manage jobs and logins for an AlwaysOn Availability Group
  • AlwaysOn AG: Manual Failover

  • perform a manual failover for an AlwaysOn Availability Group
  • Suspending and Resuming

  • suspend and resume an AlwaysOn Availability Database
  • Removing Primary and Secondary

  • remove a primary from an AlwaysOn Availability Group, and remove a secondary from an AlwaysOn Availability Group
  • Taking a Group Offline

  • take an AlwaysOn Availability Group offline
  • Removing an AlwaysOn AG

  • remove an AlwaysOn Availability Group
  • Exercise: Clustering and AlwaysOn

    SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?