Migrating SQL databases to Azure 40562-G

4.5/5

In this workshop, you will work as a group to setup and configure a serverless architecture within Azure using a combination of Azure Functions, Logic Apps, Event Grid, Cosmos DB, and Azure Storage. The focus is on removing server management from the equation, breaking down the solution into smaller components that are individually scalable, and allowing the customer to only pay for what they use.

Training Options

Classroom Training

Online Instructor Led

Onsite Training

Course Information

Module 1: Whiteboard Design Session - Migrating SQL databases to Azure

Lessons

  • Review the customer case study
  • Design a proof of concept solution
  • Present the solution

Module 2: Hands-On lab - Migrating SQL databases to Azure

Lessons

  • Perform database assessments
  • Migrate the database to SQL MI
  • Update the web application to use the new SQL MI database
  • Integrate App Service with the virtual network
  • Improve database security posture with Advanced Data Security
  • Enable Dynamic Data Masking
  • Use online secondary for read-only queries

Audience Profile

This workshop is intended for Cloud Architects and IT professionals who have architectural expertise of infrastructure and solutions design in cloud technologies and want to learn more about Azure and Azure services as described in the "Summary" and "Skills gained" areas. Those attending this workshop should also be experienced in other non-Microsoft cloud technologies, meet the course prerequisites, and want to cross-train on Azure.

Q: Who should take this Migrate Open-Source Data Workloads To Azure Dp-070t00 course?

A: This course is specially designed for the database developers who plan to migrate their MySQL or Postgres DB workloads to Azure SQL DB and to create awareness of the features and benefits of Azure SQL DB.

Q: What are the course objectives of Migrate Open-Source Data Workloads To Azure Dp-070t00?

A: Through this course, you will learn to migrate on-premises MySQL to Azure SQL DB for MySQL and PostgreSQL to Azure SQL DB for PostgreSQL.

Q: How many strategies of migration are there in Azure?

A: Migration strategies are specified as Rehost, Refactor, Rearchitect, and Rebuild.

Q: What are the requirements for Migrate Open-Source Data Workloads To Azure Dp-070t00 course?

A: The requirements for Migrate Open-Source Data Workloads To Azure Dp-070t00 course is having knowledge of open-source relational database management systems such as Postgres and/or MySQL, SQL administration, backup, and recovery techniques i.e. dumping table data.

100% Business Fulfilment

Request more Information

    Corporate Training Options

    Classroom Training

    Customized to your Team’s needs

    Onsite Training

    Deliver at your Work Location

    Online Instructor Led

    Connect Online from Anywhere

    What People say?

    Mohammed Aljbreen Operation Specialist, SAMA

    The Clarity of the Content was very good. The explanation of the trainer with in-depth knowledge in a proper flow really impressed me to give 5 star rating.

    Arindam Chakraborty Systems Specialist, King Abdullah University of Sciences & Technology

    The Instructor was really impressive. Clear cut explanation of every topic he covered with real time scenarios.

    Sher Afzal Khan Cloud Engineer, Cloud 9 Networks

    The Trainer and the Course Material, both are good. Good flow of explanation with simple examples. The complete training was focused on current industry challenges.

    Jawed Ahmad Siddiqui Sr. System Administrator, Saudi Ceramics

    The Trainer’s presentation was impressed me to continue the course till end. Never feel bore till the entire sessions. She studied our mindset and follows.

      Not sure,
      which course to choose?

      Our Clients across the Globe!

      Our Corporate Clients