Plan and implement data platform resources

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

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

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

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.

• 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

• 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

• 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

• Introduction
• Understand compatibility level
• Understand Azure preview features
• Describe Azure database migration options
• Knowledge check
• Summary