Course Description
Objectives
Migrate on-premises MySQL to Azure SQL DB for MySQL
Migrate on-premises PostgreSQL to Azure SQL DB for PostgreSQL
Prerequisites
Successful students start this role with a fundamental knowledge of cloud computing concepts and experience with open source relational database management systems.
Specifically:
- Working with PostgreSQL and/or MySQL
- Using backup and recovery techniques with open source data
- SQL administration
To gain these skills, take the following free online training before attending the course:
- 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
Curriculum for this course
23 Lessons
Module 1: Migrate to Azure SQL DB for MySQL & PostgreSQ
3 Lessons
-
OSS databases overview
.
-
Common OSS database workloads
.
-
Customer challenges in migration
.
Lab : Creating source OSS databases
4 Lessons
-
Installation of Postgres migration DB server
.
-
Installation of MySQL migration DB server
.
-
Backups / data dumps from Postgres / MySQL
.
-
Restore from data dumps
.
Module 2: Migrate on-premises MySQL to Azure SQL DB for MySQL
4 Lessons
-
Configure and Manage Azure SQL DB for MySQL
.
-
Migrate on-premises MySQL to SQL DB for MySQL
.
-
Application Migration
.
-
Post-migration considerations
.
Lab : Migrating MySQL DB Workloads to Azure SQL DB
4 Lessons
-
Migrating MySQL DB Workloads to Azure SQL DB
.
-
Define Source and Target DBs
.
-
Perform Migration
.
-
Verify Migration
.
Module 3: Migrate on-premises PostgreSQL to Azure SQL DB for PostgreSQL
4 Lessons
-
Configure and Manage Azure SQL DB for PostgreSQL
.
-
Migrate on-premises MySQL to SQL DB for PostgreSQL
.
-
Application Migration
.
-
Post-migration considerations
.
Lab : Migrating PostgreSQL DB Workloads to Azure SQL DB
4 Lessons
-
Configure Azure SQL DB for PostgreSQL
.
-
Define Source and Target DBs
.
-
Perform Migration
.
-
Verify Migration
.
