40514: Microsoft Cloud Workshop: Data Platform Upgrade and Migration Course Overview

To ensure that participants are prepared to successfully engage with the 40514: Microsoft Cloud Workshop: Data Platform Upgrade and Migration course, the following minimum prerequisites are recommended:

• Basic understanding of database concepts, including relational databases and SQL (Structured Query Language).
• Familiarity with Microsoft SQL Server and its core features.
• Experience with database administration or development on SQL Server or another database platform.
• Working knowledge of Microsoft Azure services, particularly Azure SQL Database and Azure Data Migration Service (DMS).
• Some experience with or exposure to Oracle database systems would be beneficial, though not strictly required.
• Understanding of cloud computing concepts and the differences between on-premises and cloud-based database solutions.
• Basic familiarity with virtual machines and their role in a cloud environment.
• Ability to navigate and use the Windows operating system, as well as a basic understanding of Windows Server administration.

These prerequisites are designed to facilitate effective learning without overwhelming participants who have the baseline knowledge outlined above. If you need to brush up on any of these areas, we recommend doing so prior to attending the workshop to maximize the benefits of the training.

Target Audience for 40514: Microsoft Cloud Workshop: Data Platform Upgrade and Migration

Course 40514: Microsoft Cloud Workshop: Data Platform Upgrade and Migration is designed for professionals seeking to modernize and migrate their data platforms to Azure.

Target audience for the course includes:

• Database Administrators
• Data Architects
• IT Professionals with a focus on data management and database systems
• Cloud Solution Architects
• Systems Engineers
• Technical Decision Makers evaluating data platform migrations
• DevOps Engineers involved in database deployment and migration
• Application Developers working with databases that need migration or upgrading
• Data Analysts looking to understand the migration impact on data analysis
• IT Project Managers overseeing database or cloud migration projects

Learning Objectives - What you will Learn in this 40514: Microsoft Cloud Workshop: Data Platform Upgrade and Migration?

Introduction to Course Learning Outcomes and Concepts:

The 40514: Microsoft Cloud Workshop: Data Platform Upgrade and Migration course is designed to equip students with skills for modernizing and migrating data platforms to Azure, incorporating strategies for SQL Server and Oracle database migration.

Learning Objectives and Outcomes:

• Understand the critical considerations for upgrading and migrating legacy data platforms to modern Azure solutions.
• Develop a comprehensive proof of concept (POC) for data platform migration that aligns with the customer's business requirements and constraints.
• Gain proficiency in deploying SQL Server instances in preparation for migration.
• Learn to use the Azure Database Migration Service (DMS) to effectively migrate SQL Server databases to Azure SQL Database.
• Identify and implement post-migration enhancements to optimize performance and costs in the cloud environment.
• Acquire the skills to set up Oracle 11g Express Edition as a precursor to migration.
• Master the process of migrating an Oracle database to SQL Server 2017, ensuring data integrity and minimal downtime.
• Understand how to migrate associated applications to work with the modernized database.
• Learn to present migration solutions to stakeholders, demonstrating the business impact and technical benefits.
• Build confidence in troubleshooting and resolving common migration challenges during the hands-on lab experience.