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 40577: Microsoft Cloud Workshop: Innovate and modernize apps with Data and AI

- u.a. in Berlin, Zürich, Dresden, Düsseldorf, Offenbach

In this workshop, you will look at the process of implementing a modern application with Azure services. The workshop will cover event sourcing and the Command and Query Responsibility Segregation (CQRS) pattern, data loading, data preparation, data transformation, data ...

AI-100T01: Designing and Implementing an Azure AI Solution

- u.a. in Hamburg, Köln, Leipzig, München, Mannheim

Gain the necessary knowledge for designing Azure AI solution by building a customer support chat Bot using artificial intelligence from the Microsoft Azure platform including language understanding and pre-built AI functionality in the Azure Cognitive Services.