Plan and implement data platform resources

Go to class
Write Review

Free Online Course: Plan and implement data platform resources provided by Microsoft Learn is a comprehensive online course, which lasts for 3-4 hours worth of material. The course is taught in English and is free of charge.

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