Home > Vendors > microsoft > dp-050t00

Share

DP-050T00 - Migrate SQL workloads to Azure

In this course, the students will explore the objectives of data platform modernization and how it is suitable for given business requirements. They will also explore each stage of the data platform modernization process and define what tasks are involved at each stage, such as the assessment and planning phase. Students will also learn the available migration tools and how they are suitable for each stage of the data migration process.

The student will learn how to migrate to the three target platforms for SQL based workloads; Azure Virtual Machines, Azure SQL Databases and Azure SQL Database Managed Instances. The student will learn the benefits and limitations of each target platform and how they can be used to fulfil both business and technical requirements for modern SQL workloads. The student will explore the changes that may need to be made to existing SQL based applications, so that they can make best use of modern data platforms in Azure.

Duration: 2.0 days

Enquire Now

Schedule

Kuala Lumpur | 12 Dec 2023 - 13 Dec 2023 Malaysia
Virtual ILT | 12 Dec 2023 - 13 Dec 2023 Malaysia

Start learning today!

Click Hereto customize your Training

Objectives

  • Explain what data platform modernization is
  • Review the stages of a data migration
  • Recommend when to use an Azure data platform technology
  • Explore the cost savings of moving your SQL workloads to Azure
  • Decide if the DMA is the best tool to use for a given administration task
  • Install the DMA on your client machine
  • Identify compatibility issues prior to upgrade
  • Upgrade a database using the DMA
  • Decide if DEA is the right tool for your workload testing
  • Install DEA on your client machine
  • Test a typical workload on an upgraded database
  • Review the results of a trace analysis report
  • Choose the right options when you run your SQL workloads on Azure Virtual Machines
  • Explore migration options when moving SQL Server workload to an Azure Virtual Machine
  • Configure and optimize your applications
  • Describe the considerations for a SQL Server to Azure SQL Database migration.
  • Describe the methods and steps to perform an offline migration to Azure SQL Database.
  • Describe the methods and steps to perform an online migration to Azure SQL Database.
  • Explore the post migration steps required to ensure service continuity of your database in backup, high availability, disaster recovery, and scalability.
  • Evaluate migration scenarios to Azure SQL Database Managed Instance
  • Migrate to Azure SQL Database Managed Instance
  • Load and move data to Azure SQL Database Managed Instance

Content

1. Introduction to data platform modernization

In this module, you'll learn what the purpose of data platform modernization and see the benefits it can bring to your organization.

Click here to know more

2. Assess and convert SQL Server databases using the Data Migration Assistant (DMA)

The Data Migration Assistant (DMA) is a standalone application that can find compatibility issues between versions of databases. It also shows you new features that would enhance the performance of your database when upgraded.

Click here to know more

3. Test and optimize SQL Server databases using the Database Experimentation Assistant (DEA)

The Database Experimentation Assistant (DEA) is a standalone application that can compare workloads between the current version of your database, and the target.

Click here to know more

4. Migrate SQL workloads to Azure virtual machines

Learners will be able to demonstrate the benefits and processes for moving a SQL Server database to an Azure virtual machine.

Click here to know more

5. Migrate SQL workloads to Azure SQL Databases

In this module, you will learn to demonstrate the benefits and processes for moving a SQL Server database to Azure SQL Database.

Click here to know more

6. Migrate SQL workloads to Azure Managed Instances

Learners will be able to demonstrate the benefits and processes for moving a SQL Server database to an Azure SQL Database Managed Instance.

Click here to know more

Audience

The audience for this course is data professionals and data architects who want to learn about migrating data platform technologies that exist on Microsoft Azure and how existing SQL based workloads can be migrated and modernized.The secondary audience for this course is individuals who manage data platforms or develop applications that deliver content from the existing data platform technologies.

Prerequisites

Successful students start this role with a fundamental knowledge of cloud computing concepts and professional experience in implementing SQL solutions.

Specifically:

  • Working with and maintaining SQL workloads
  • Experience with Azure, such as deploying and managing resources

To gain these skills, take the following free online training before attending the course:

  • Introduction to Azure SQL
  • Azure Fundamentals

Certification

product-certification

This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Microsoft Popular Courses

ms-700t00

The Managing Microsoft Teams course is designed for those aspiring to be Microsoft 365 Teams Administrators to deploy, configure and manage Office 365 workloads

sc-900t00

This course provides foundational level knowledge on security, compliance, and identity concepts and related cloud-based Microsoft solutions.

az-204

Learn to create end-to-end solutions in Microsoft Azure in this 5-days official Microsoft course.

az-104

This course teaches IT Professionals how to manage their Azure subscriptions, secure identities, administer the infrastructure, configure virtual networking, co
Enquire Now
 
 
 
 
axEzvk
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy
➤