Description
This course teaches students how to migrate open source data workloads, specifically MySQL and PostgreSQL, to Azure SQL Database. It covers the architecture, migration processes, and post-migration considerations through hands-on labs.
Learning Outcomes
- Understand the benefits and architecture of Azure SQL DB
- Migrate on-premises MySQL workloads to Azure SQL DB
- Migrate on-premises PostgreSQL workloads to Azure SQL DB
- Configure and manage Azure SQL DB for MySQL and PostgreSQL
- Handle application migration and post-migration considerations
Prerequisites
Fundamental knowledge of cloud computing concepts, experience with open source relational database management systems (PostgreSQL and/or MySQL), skills in backup and recovery techniques, and SQL administration.
Prerequisite Courses
- Core cloud services – Azure compute options
- Deploy MariaDB, MySQL, and PostgreSQL on Azure
- Introduction to Azure SQL
- Introduction to open source database migration to Azure Cosmos DB
Target Audiences
- Database developers and administrators with experience in MySQL or PostgreSQL who are planning to migrate workloads to Azure SQL Database. This includes those seeking to understand the migration process and benefits of Azure SQL DB.
Featured Review
"This course equipped me with the skills to seamlessly migrate our MySQL databases to Azure, improving efficiency and reducing operational costs. - Raj Kumar, Senior Database Developer at a multinational corporation"