YoVDO

Migrate open-source databases to Azure

Offered By: Microsoft via Microsoft Learn

Tags

Microsoft Azure Courses Databases Courses Cloud Computing Courses MySQL Courses PostgreSQL Courses Database Administration Courses Database Migration Courses Database Monitoring Courses

Course Description

Overview

  • Module 1: Introduction to open-source database migration on Azure

    • By the end of this module, you'll be able to:

    • Describe the features and services available in Azure for hosting an open-source database.
    • Explain the key considerations for implementing a migration project.
    • Describe different approaches that you can take for migrating databases.
  • Module 2: Migrate on-premises MySQL databases to Azure Database for MySQL

    • By the end of this module, you'll be able to:

    • Describe the features and limitations of Azure Database for MySQL.
    • Migrate an on-premises MySQL database to Azure Database for MySQL.
    • Reconfigure existing applications that use your on-premises MySQL databases to connect to Azure Database for MySQL.
  • Module 3: Migrate on-premises PostgreSQL databases to Azure Database for PostgreSQL

    • By the end of this module, you'll be able to:

    • Describe the features and limitations of Azure Database for PostgreSQL.
    • Migrate an on-premises PostgreSQL database to Azure Database for PostgreSQL.
    • Reconfigure existing applications that use your on-premises PostgreSQL databases to connect to Azure Database for PostgreSQL.
  • Module 4: Protect, monitor, and tune a migrated database

    • By the end of this module, you'll be able to:

    • Protect a database running in Azure Database for MySQL and Azure Database for PostgreSQL.
    • Monitor and tune a database running in Azure Database for MySQL and Azure Database for PostgreSQL.
    • Trace and track activity for a database running in Azure Database for MySQL and Azure Database for PostgreSQL.
    • Configure read replicas for a database running in Azure Database for MySQL and Azure Database for PostgreSQL.

Syllabus

  • Module 1: Introduction to open-source database migration on Azure
    • Introduction
    • MySQL and PostgreSQL database services in Azure
    • Considerations for migration
    • Approaches to migration
    • Knowledge check
    • Summary
  • Module 2: Migrate on-premises MySQL databases to Azure Database for MySQL
    • Introduction
    • Introduction to Azure Database for MySQL
    • Migrate on-premises MySQL database to Azure
    • Application migration
    • Exercise: Migrate on-premises MySQL database to Azure Database for MySQL
    • Knowledge check
    • Summary
  • Module 3: Migrate on-premises PostgreSQL databases to Azure Database for PostgreSQL
    • Introduction
    • Introduction to Azure Database for PostgreSQL
    • Migrate on-premises PostgreSQL database to Azure
    • Application migration
    • Exercise: Migrate an on-premises PostgreSQL database to Azure Database for PostgreSQL
    • Knowledge check
    • Summary
  • Module 4: Protect, monitor, and tune a migrated database
    • Introduction
    • Protect a database and server
    • Monitor and configure a database server
    • Trace and track activity
    • Configure read replicas
    • Exercise: Protect, monitor, and tune a migrated database
    • Knowledge check
    • Summary

Tags

Related Courses

Building Cloud Apps with Microsoft Azure - Part 1 (self-paced)
Microsoft via edX Building Cloud Apps with Microsoft Azure - Part 3
Microsoft via edX DEV202.2x: Building Cloud Apps with Microsoft Azure – Part 2
Microsoft via edX Architecting Microsoft Azure Solutions
Microsoft via edX Implementing Predictive Analytics with Spark in Azure HDInsight
Microsoft via edX