• 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 NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration