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

Managing Big Data with MySQL
Duke University via Coursera
Database Management Essentials
University of Colorado System via Coursera
Business Metrics for Data-Driven Companies
Duke University via Coursera
Bases de données relationnelles : Comprendre pour maîtriser
Inria (French Institute for Research in Computer Science and Automation) via France Université Numerique
Базы данных (Databases)
Saint Petersburg State University via Coursera