DP-050T00: Migrate SQL workloads to Azure Course Overview

To ensure you have the foundational knowledge necessary for success in the DP-050T00: Migrate SQL workloads to Azure course, please consider the following prerequisites:

• Basic understanding of database concepts, including relational databases.
• Experience with SQL Server or other database solutions.
• Familiarity with the core concepts of cloud computing and the Microsoft Azure platform.
• Knowledge of SQL Server workloads and their typical requirements.
• An understanding of the importance of data platform modernization.
• Basic experience with Windows Server administration and Windows operating systems.
• Comfort with using PowerShell and command-line interface (CLI) tools.

These prerequisites are meant to provide you with a baseline understanding that will help you to more effectively engage with the course content. If you find yourself less familiar with some of these areas, we recommend reviewing relevant materials or considering introductory courses to build your confidence and ensure a successful learning experience.

Target Audience for DP-050T00: Migrate SQL workloads to Azure

The DP-050T00 course focuses on teaching professionals how to modernize and migrate SQL workloads to Azure, suitable for IT specialists involved in database management and migration.

Target Audience for DP-050T00: Migrate SQL Workloads to Azure:

• Database Administrators
• Data Architects
• IT Professionals responsible for data platform solutions
• System Engineers
• Cloud Solution Architects
• Data Analysts with a focus on migration projects
• SQL Server Developers
• Technical Consultants involved in data migration projects
• Infrastructure Specialists with a focus on database systems
• IT Project Managers overseeing database migration or modernization projects

Learning Objectives - What you will Learn in this DP-050T00: Migrate SQL workloads to Azure?

Introduction to Learning Outcomes and Concepts Covered:

This course aims to provide a comprehensive understanding of data platform modernization, focusing on migrating SQL workloads to various Azure services while ensuring efficiency, scalability, and high availability.

Learning Objectives and Outcomes:

• Comprehend the fundamentals of data platform modernization and the benefits of migrating to Azure.
• Understand the stages and paths involved in the data migration process.
• Utilize the Database Migration Guide to select appropriate tools and services for data migration.
• Use the Microsoft Assessment and Planning Toolkit to inventory existing data estates.
• Identify and assess migration candidates with the Data Migration Assistant (DMA).
• Evaluate data workloads for performance and compatibility using the Database Experimentation Assistant (DEA).
• Conduct migrations using Azure Database Migration Service (DMS) for a streamlined process.
• Migrate non-SQL Server workloads to Azure with SQL Migration Assistant for compatibility.
• Implement SQL Server migrations to Azure Virtual Machines, considering high availability and disaster recovery.
• Migrate SQL Server instances to Azure SQL Database and Azure SQL Managed Instance with both offline and online strategies.
• Optimize applications post-migration for Azure SQL Database Managed Instance environments.