Home > Vendors > microsoft > dp-070t00

Share

DP-070T00 - Migrate Open Source Data Workloads to Azure

This course will enable the students to understand Azure SQL Database, and educate the students on what is required to migrate MySQL and PostgreSQL workloads to Azure SQL Database.


Duration: 1.0 day

Enquire Now

Schedule

Kuala Lumpur | 15 Dec 2023 - 15 Dec 2023 Malaysia
Virtual ILT | 15 Dec 2023 - 15 Dec 2023 Malaysia

Start learning today!

Click Hereto customize your Training

Objectives

  • 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.
  • 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.
  • 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.
  • 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.

Content

1. Introduction to open-source database migration on Azure

In this module, you'll learn about the issues and considerations for migrating on-premises open-source databases to Azure, the services that Azure provides to help you migrate your databases, and how to plan a migration.

Click here to know more

2. Migrate on-premises MySQL databases to Azure Database for MySQL

In this module, you'll learn about the benefits of migrating MySQL workloads to Azure, you'll see how to create an Azure Database for MySQL instance, and learn how to migrate on-premises MySQL databases to Azure.

Click here to know more

3. Migrate on-premises PostgreSQL databases to Azure Database for PostgreSQL

In this module, you'll learn about the benefits of migrating PostgreSQL workloads to Azure, you'll see how to create an Azure Database for PostgreSQL instance and how to migrate on-premises PostgreSQL databases to Azure.

Click here to know more

4. Protect, monitor, and tune a migrated database

In this module, you'll learn how to use the Azure features available for protect, monitor, and tune a database.

Click here to know more

Audience

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.

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

Certification

product-certification

This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Microsoft Popular Courses

ms-700t00

The Managing Microsoft Teams course is designed for those aspiring to be Microsoft 365 Teams Administrators to deploy, configure and manage Office 365 workloads

sc-900t00

This course provides foundational level knowledge on security, compliance, and identity concepts and related cloud-based Microsoft solutions.

az-204

Learn to create end-to-end solutions in Microsoft Azure in this 5-days official Microsoft course.

az-104

This course teaches IT Professionals how to manage their Azure subscriptions, secure identities, administer the infrastructure, configure virtual networking, co
Enquire Now
 
 
 
 
IrPpPT
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy
➤