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


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/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.

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 (hours)
2.5

Lesson Objectives

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

  • 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
  • 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
  • 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
  • recognize the options and requirements for Windows Azure SQL Database security
  • configure Windows Azure SQL Database security
  • 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
  • Implementing SQL solutions with Windows Azure

    • Course Number:
    md_ddsa_a03_it_enus

    Expertise Level
    Intermediate