• Online, Self-Paced
Course Description

Microsoft Windows Azure is a cloud computing offering which includes cloud storage, VMs, and applications. Windows Azure SQL Database is the public cloud SQL service. This course covers the Windows Azure offering, where SQL sits in the offering interaction between SQL and the cloud, and Windows Azure SQL Database. 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 Overview

  • start the course
  • identify the architecture components of Windows Azure public cloud
  • recognize the services offered as part the Windows Azure public cloud product
  • create a storage account in the Windows Azure public cloud service

Windows Azure Storage

  • recognize the features of the Windows Azure Storage service, part of the Windows Azure public cloud product
  • recognize the features and functionality offered by the Windows Azure Storage Table Service
  • use the Windows Azure Storage Table Service to create cloud hosted table data stores
  • recognize the features and functionality offered by the Windows Azure Storage Blob Service
  • use the Windows Azure Storage Blob Service to create cloud hosted table data stores

Windows Azure SQL Database

  • recognize the features of Windows Azure SQL Database
  • identify the function and interrelationship of the components of Windows Azure SQL Database
  • provision a Windows Azure SQL Database
  • provision a Windows Azure SQL Database server
  • manage a Windows Azure SQL Database using the Windows Azure Management Portal

Windows Azure SQL Database Security

  • recognize the options and requirements for Windows Azure SQL Database security
  • configure Windows Azure SQL Database security

Windows Azure SQL Database Migration

  • migrate an existing SQL on-premises database to Windows Azure SQL Database by generating a T-SQL script
  • migrate an existing SQL on-premises database to Windows Azure SQL Database by running a T-SQL script that you have generated
  • migrate an existing SQL on-premises database to Windows Azure SQL Database by using the Microsoft Sync Framework 2.1
  • migrate an existing SQL on-premises database to Windows Azure SQL Database by using the export and import options

Practice: Windows Azure SQL Database Migration

  • Implementing SQL solutions with Windows Azure

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.