DP-070: Migrate Open Source Data Workloads to Azure

Seminarinformationen

Seminar - Ziel

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.

Teilnehmer - Zielgruppe


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.

Job role: Data Engineer


Features: None

Kurs - Voraussetzungen

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

Seminardauer

  • 1 Tag
  • 09:00 Uhr bis 17:00 Uhr

Schulungsunterlagen

  • nach Absprache

Seminar-Inhalt / Agenda

Module 1: Migrate to Azure SQL DB for MySQL & PostgreSQL

  • OSS databases overview
  • Common OSS database workloads
  • Customer challenges in migration

Module 2: Migrate on-premises MySQL to Azure SQL DB for MySQL

  • Configure and Manage Azure SQL DB for MySQL
  • Migrate on-premises MySQL to SQL DB for MySQL
  • Application Migration
  • Post-migration considerations


Module 3: Migrate on-premises PostgreSQL to Azure SQL DB for PostgreSQL

  • Configure and Manage Azure SQL DB for PostgreSQL
  • Migrate on-premises MySQL to SQL DB for PostgreSQL
  • Application Migration
  • Post-migration considerations

Weitere Schulungen zu Thema Microsoft Azure

MOC 40502 Microsoft Cloud Workshop: Big Data & Visualization

- u.a. in Nürnberg, Berlin, Stuttgart, München, Köln

Die Teilnehmer lernen in dieser SChulung eine intelligente Web-App mittels Machine Learning zu erstellen sowie bereitzustellen. Das notwendige Wissen wird dabei mit Hilfe einer Fallstudie vermittelt.

MOC 40501 Microsoft Cloud Workshop: Container and DevOps

- u.a. in Nürnberg, Berlin, Stuttgart, München, Köln

In dieser Schulung lernen Cloud-Architekten und IT-Professionals Azure Container Services durch Skalierung, Lastverteilung sowie Service Discovery bereitzustellen.

MOC 40515 Microsoft Cloud Workshop: Enterprise-Class Networking in Azure

- u.a. in Frankfurt am Main, München, Wien, Essen, Mannheim

In this workshop, you will learn to setup and configure a virtual network with subnets in Azure. You will learn how to secure the virtual network by deploying a network virtual appliance and configure firewall rules and route tables. Additionally, you will set up access to the ...

MOC 40526 Microsoft Cloud Workshop: SAP HANA in Azure

- u.a. in Hamburg, Leipzig, Paderborn, Zürich, Heidelberg

In this workshop, you will learn how to provision a highly available deployment of SAP HANA in Azure. Throughout the whiteboard design session and the hands-on lab, you will look at the planning process for SAP HANA migration and deployment. You will identify and implement ...