Microsoft SQL Server 2014 – Designing Solutions: Windows Azure SQL Database

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

Prerequisite
None

Expected Duration
150 minutes

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.

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.