Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Plan and implement data platform resources

Microsoft via Microsoft Learn

Overview

  • Module 1: Deploy SQL Server in a virtual machine
  • After completing this module, you will be able to:

    • Explore the basics of SQL Server in an Infrastructure as a Service (IaaS) offering
    • Learn the available options for provisioning and deployment
    • Deploy SQL Server into an Azure Virtual Machine
  • Module 2: Deploy Azure SQL Database
  • After completing this module, you will be able to:

    • Gain an understanding SQL Server in a Platform as a Service (PaaS) offering
    • Understand PaaS provisioning and deployment options
    • Understand elastic pools
    • Examine Managed Instances
    • Configure a template for PaaS deployment
  • Module 3: Deploy MariaDB, MySQL, and PostgreSQL on Azure
  • After completing this module, you will be able to:

    • Understand the service tiers available for open source database platforms
    • Deploy MySQL, MariaDB, and PostgreSQL
    • Configure high availability option for MySQL and MariaDB
    • Configure Scale Out reads for MySQL and MariaDB
    • Describe the SSL Options for MySQL and MariaDB
  • Module 4: Evaluate strategies for migrating SQL Databases to Azure
  • After completing this module, you will be able to:

    • Evaluate different Azure migration options when moving your on-premises SQL environment to the cloud.
    • Understand how SQL Server compatibility level affects database behavior.
    • Understand the differences between private and public preview options.

Syllabus

  • Module 1: Deploy SQL Server in a virtual machine
    • Introduction
    • Explain IaaS options for deploying SQL Server in Azure
    • Describe Azure platform availability
    • Explain SQL Server high availability options
    • Explain SQL Server disaster recovery options
    • Provision and deploy SQL Server to Azure virtual machines
    • Exercise: Provision a SQL Server on an Azure virtual machine
    • Knowledge check
    • Summary
  • Module 2: Deploy Azure SQL Database
    • Introduction
    • Explain PaaS options for deploying SQL Server in Azure
    • Deploy single SQL database
    • Deploy SQL database elastic pool
    • Deploy SQL managed instance
    • Exercise: Deploy an Azure SQL Database
    • Knowledge check
    • Summary
  • Module 3: Deploy MariaDB, MySQL, and PostgreSQL on Azure
    • Introduction
    • Describe open source offerings
    • Explain how to deploy PostgreSQL to Azure
    • Deploy MySQL and MariaDB to Azure
    • Exercise: Deploy a PostgreSQL database server to Azure
    • Knowledge check
    • Summary
  • Module 4: Evaluate strategies for migrating SQL Databases to Azure
    • Introduction
    • Understand compatibility level
    • Understand Azure preview features
    • Describe Azure database migration options
    • Knowledge check
    • Summary

Reviews

Start your review of Plan and implement data platform resources

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.