Azure Database for MySQL

By the end of this module, you should be able to:

• Evaluate whether Azure Database for MySQL is appropriate to handle your organization's workloads.
• Describe how predictable performance and dynamic scalability of Azure Database for MySQL make it ideal to host your database workloads.

By the end of this module, you should be able to:

• Describe the core functionality of Azure Database for MySQL.
• Deploy and connect to an Azure Database for MySQL flexible server.
• Integrate applications with an Azure Database for MySQL flexible server.

By the end of this module, you should be able to:

• Connect to and query Azure Database for MySQL flexible server from your app developed in the language of your choice.
• Choose a hosting option suitable for your MySQL app.
• Deploy your app on Azure services like Azure App Service and Azure Kubernetes Service (AKS).
• Build a sample PHP app connecting to MySQL Flexible Server and deploy it on Azure App Service.
• Apply best practices for application development with Azure Database for MySQL.

In this module, you'll learn about Azure Database for MySQL - Flexible Server features that you can use to support your mission-critical workloads. You'll:

• "Explore security features in Azure Database for MySQL – Flexible Server."
• "Compare business continuity and disaster recovery options in Azure Database for MySQL – Flexible Server."
• "Evaluate performance features in Azure Database for MySQL – Flexible Server."

By the end of this module, you should be able to:

• "Configure networking and security features in Azure Database for MySQL - Flexible Server."
• "Enable business continuity and disaster recovery options in Azure Database for MySQL - Flexible Server."
• "Choose the right scaling options for your Azure Database for MySQL flexible server."

By the end of this module, you should be able to:

• "Choose an online or offline migration."
• "Review available migration tools and select one."
• "Migrate an on-premises MySQL server into an Azure Database for MySQL flexible server."

• What is Azure Database for MySQL?
• Exploring Azure Database for MySQL
• How Azure Database for MySQL works
• When to use Azure Database for MySQL
• Knowledge check
• Summary

• Introduction
• Azure Database for MySQL
• How to deploy and connect to Azure Database for MySQL
• Exercise - Deploy an Azure Database for MySQL flexible server
• Exercise - Connect to an Azure Database for MySQL flexible server
• Knowledge check
• Summary

• Introduction
• Connect to and query an Azure Database for MySQL flexible server from your app
• Choose a suitable hosting option for your MySQL app
• Deploy your app and integrate with other Azure services
• Exercise - Deploy a PHP and MySQL - Flexible Server app on Azure App Service
• Consider best practices for app development
• Knowledge check
• Summary

• Introduction
• Describe security features
• Compare business continuity and disaster recovery options
• Azure Database for MySQL - Flexible Server performance features
• Knowledge check
• Summary

• Introduction
• Configure networking and security features
• Configure business continuity and disaster recovery
• Determine Azure Database for MySQL server scaling needs
• Knowledge check
• Summary

• Introduction
• Migration phases and considerations
• Explore migration tool options
• Decide the migration approach and tool
• Exercise: Use the Azure Database for MySQL import CLI from an on-premises MySQL
• Knowledge check
• Summary