• Online, Self-Paced
Course Description

In addition to Windows Azure SQL Database, Windows Azure enables you to configure and manage a VM dedicated to running an instance of SQL Server. High availability is the ability of a service to continue after a failure, and SQL Server 2014 has a number of options for implementing high availability. This course covers VMs on Windows Azure, and how to install, configure and manage SQL on a VM, and high availability in SQL 2014 including Windows Server Failover Clusters, AlwaysOn 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 Azure VMs

  • start the course
  • recognize the function and features of Windows Azure virtual machines
  • recognize how virtual disks are configured and stored on Windows Azure
  • create a VM on Windows Azure
  • connect to a VM that you have created on Windows Azure
  • configure security for a VM on Windows Azure

Creating Databases on VMs

  • create a TCP endpoint on Windows Azure
  • configure a VM with SQL Server on Windows Azure
  • connect to a configured VM with SQL Server on Windows Azure

High Availability in SQL Server 2014

  • recognize the options for SQL Server 2014 high availability and when each is appropriate
  • recognize the characteristics of AlwaysOn Failover Cluster Instances (FCI) in SQL Server 2014
  • recognize the characteristics of AlwaysOn Availability Groups in SQL Server 2014
  • recognize log shipping features and functionality in SQL Server 2014

SQL Server 2014 Log Shipping

  • configure log shipping using SQL Server Management Studio on SQL Server 2014
  • configure log shipping using T-SQL on SQL Server 2014
  • test a log shipping configuration that you have created in SQL Server 2014
  • test a log shipping failover on a log shipping configuration that you have created in SQL Server 2014

Practice: SQL Server 2014 Log Shipping

  • Configure high availability

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.