Course Description: DP-3001: Migrate SQL Server workload to Azure SQL

To earn this Microsoft Applied Skills credential, learners must demonstrate the ability to assess and migrate SQL Server workloads to Azure SQL Database .

Candidates for this credential should have a solid understanding of both database-level and instance-level scoped objects in SQL Server . They should also be familiar with provisioning Azure SQL resources and navigating the Azure portal .

Intermediate - SQL Server, Azure SQL Database - Database Administrator, Data Engineer, Administrator - Databases

Goals

• Perform post-migration configuration
• Disaster Recovery Setup
• Evaluating and preparing databases for migration
• Migrating databases to Azure SQL databases
• Provision and configure Azure SQL databases.

Training Route

Migrating SQL Server Workloads to Azure SQL

This learning path prepares you for the task of migrating SQL Server workloads to Azure SQL.

You will learn how to assess SQL Server components and compatibility for migration using the Azure SQL Migration extension and Database Migration Assistant. You will also learn how to provision and configure Azure SQL resources. You will gain hands-on experience in choosing the best migration option to meet business requirements for downtime, migration health monitoring, and database migration monitoring.

Additionally, you will also learn how to perform post-migration tasks such as disaster recovery and monitoring. These skills are essential to ensure a smooth and effective transition to Azure SQL and keep it running after migration.

• Designing a SQL Server Migration Strategy: In this module, you will learn about the phases of a migration and the steps required to ensure that the migration project runs smoothly. You will also discover the purpose of data platform modernization and see the benefits it can bring to your organization.
• Assessing SQL Server databases for migration to Azure SQL: Assessment tools such as the Azure SQL Migration extension for Azure Data Studio, Azure Migrate, and Data Migration Assistant make it easy to migrate SQL Server databases to Azure.
• Deploy IaaS solutions with Azure SQL: Configure virtual machine sizing, storage, and networking settings to ensure the performance of your database workloads. Choose and configure the appropriate high availability options.
• Deploying PaaS solutions with Azure SQL: Provision and deploy Azure SQL Database and Azure SQL Managed Instance. Select the appropriate options when migrating to the SQL PaaS platform.
• Migrating SQL Server Workloads to Azure Virtual Machine: You will explore different migration tools and migrate SQL Server databases to Azure Virtual Machine.
• Migrating SQL Server Workloads to Azure SQL Database: You will explore different migration tools and migrate SQL Server databases to Azure SQL Database.
• Migrating SQL Server Workloads to Azure SQL Managed Instance: You will explore different migration tools and migrate SQL Server databases to Azure SQL Managed Instance.
• Performing Post-Migration Tasks in Azure SQL: You will explore different features and tools that help you maintain Azure SQL environments.

Prerequisites

It is recommended that you have a solid understanding of both database-level and instance-level scoped objects in SQL Server. You should also be familiar with provisioning Azure SQL resources and navigating the Azure portal.

Language

• Course: English / Spanish
• Labs: English / Spanish

Microsoft Applied Skills

This course is part of the Microsoft Applied Skills Credentials.

To earn this Microsoft Applied Skills credential, learners must demonstrate the ability to assess and migrate SQL Server workloads to Azure SQL Database.

Applied Skills: Explore all credentials in one guide