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.
