At the end of this course, the students will have learned:
- Migrate on-premises MySQL to Azure SQL DB for MySQL
- Migrate on-premises PostgreSQL to Azure SQL DB for PostgreSQL
- OSS databases overview
- Common OSS database workloads
- Customer challenges in migration
- Configure and Manage Azure SQL DB for MySQL
- Migrate on-premises MySQL to SQL DB for MySQL
- Application Migration
- Post-migration considerations
- Configure and Manage Azure SQL DB for PostgreSQL
- Migrate on-premises MySQL to SQL DB for PostgreSQL
- Application Migration
- Post-migration considerations
The primary audience for this course is database developers who plan to migrate their MySQL or Postgres DB workloads to Azure SQL DB. The secondary audience for this course is MySQL/Postgres administrators to raise awareness of the features and benefits of Azure SQL DB.
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
- Some knowledge of open source relational database management systems such as Postgres and/or MySQL, SQL administration, backup and recovery techniques i.e. dumping table data