Designing and Implementing Cloud Data Platform Solutions

//, Data: Management & Analytics, Microsoft/Designing and Implementing Cloud Data Platform Solutions

Designing and Implementing Cloud Data Platform Solutions

Course ID: 40441A 3 Days Singapore

Designing and Implementing Cloud Data Platform Solutions


The focus of this three-day instructor-led Microsoft Training course is on designing and implementing cloud data platform solutions with the Microsoft Data Platform by using SQL Server on-premises, hybrid and cloud data platform solutions. It describes how to design and implement and optimize workloads in hybrid scenarios with both on-premises and Microsoft Azure cloud-based solutions, and how to implement high availability and disaster recovery solutions.



The primary audience for this course are database professionals who want to enhance their existing SQL Server skills with hybrid solutions and cloud solution architecture using the Microsoft Data Platform.


MCSA: Cloud Platform
MCSE: Cloud Platform & Infrastructure
MCSE: Data Management and Analytics





Students must have a good understanding of SQL Server and pre-existing MCSE Data Platform certification or equivalent professional experience.


  • Position Microsoft Cloud Data Platform Solutions
  • Design and implement solutions on Azure using SQL Server
  • Design and implement solutions on Azure using SQL Database
  • Design and implement security, access and auditing for cloud data platform solutions
  • Design highly scalable mission critical solutions using the Microsoft Data Platform
  • Design and implement cloud data platform solutions.


Module 1: Microsoft Cloud Data Platform Overview

  • Considerations for Upgrades and Migrations
  • Creating a Server Upgrade and Migration Plan
  • Planning for Virtualization

Module 2: Implement SQL Server on Azure VM

  • Selecting an Appropriate Server Deployment Strategy
  • Implementing an Automated Deployment Strategy

Module 3: Implement SQL Database

  • System Center 2012 R2 Virtual Machine Manager Overview
  • Implementing a Virtual Machine Manager Library and Profiles
  • Planning and Deploying Virtual Machine Manager Services

Module 4: SQL Database High Availability and disaster recovery

  • Designing DHCP Servers
  • Planning DHCP Scopes
  • Designing an IPAM Provisioning Strategy
  • Managing Servers and Address Spaces by Using IPAM

Module 5: Hybrid HA/DR scenarios with SQL Server

  • Designing a DNS Server Implementation Strategy
  • Designing the DNS Namespace
  • Designing DNS Zones
  • Designing DNS Zone Replication and Delegation
  • Optimizing DNS Servers
  • Designing DNS for High Availability and Security

Module 6: Design and Implement Security

  • Design a Domain Name System (DNS) server-implementation strategy.
  • Design a DNS namespace.
  • Design and implement a DNS zone strategy.
  • Design and configure DNS zone replication and delegation.
  • Optimize the DNS server configuration.
  • Design DNS for high availability and security.

Module 7: Monitor and manage implementations on Azure

  • Designing an Active Directory Forest
  • Designing and Implementing Active Directory Forest Trusts
  • Designing Active Directory Integration with Windows Azure Active Directory
  • Designing and Implementing Active Directory Domains
  • Designing DNS Namespaces in Active Directory Environments
  • Designing Active Directory Domain Trusts

Module 8: Design and implement database solutions for SQL Server and SQL Database

  • Planning the Active Directory Administrative Tasks Delegation Model
  • Designing an OU Structure
  • Designing and Implementing an AD DS Group Strategy

What’s Next

Subscribe to our mailing list for special offers and promotions.

Thank you! Your subscription has been confirmed. You'll hear from us soon.