DP-3001: Migrate SQL Server workload to Azure SQL

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

To obtain this Microsoft Applied Skills credential, students must demonstrate the ability to evaluate 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 objects in SQL Server . They should also be familiar with Azure SQL resource provisioning and navigating the Azure Portal .

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

Objectives of the DP-3001 training

• Perform post-migration configuration
• Disaster recovery configuration
• Evaluation and preparation of databases for migration
• Database migration to Azure SQL databases
• Provision and configure Azure SQL databases.

Course content DP-3001

Module 1 Designing a SQL Server Migration Strategy

• Review of the modernization of the data platform
• Planning a data migration
• Exploration of available technologies for data migration
• Exercise: Comparing Azure's local costs

Module 2: Evaluating SQL Server databases for migration to Azure SQL

• Review the database to check for compatibility
• Exploring valuation options for database migration
• Evaluating a database with the Azure migration extension
• Evaluating a database with Azure Migrate
• Evaluating a database with Data Migration Assistant
• Exercise: Identifying compatibility problems

Module 3 Implementing PaaS solutions with Azure SQL

• Explanation of PaaS options for deploying SQL Server on Azure
• Explore a single SQL database
• Implementing an Azure SQL Database Elastic Pool
• Description of SQL Database Hyperscale
• Examine Azure SQL Managed Instance
• Describe SQL Edge
• Exercise: Implementing an Azure SQL Database

Module 4 Authentication and Authorization Configuration

• Description of Active Directory and Microsoft Login ID
• Description of authentication and identities
• Description of security entities
• Description of object and database permissions
• Identifying authentication and authorization errors
• Exercise: Authorizing access to Azure SQL Database with Microsoft Entra ID

Module 5 Migrating SQL Server workloads to Azure SQL Database

• Choosing the right Azure SQL Database feature
• Using the Azure SQL Migration Extension to migrate to Azure SQL Database
• Exploring Data Migration Assistant to migrate to Azure SQL Database
• Migration to Azure SQL Database with BACPAC
• Using an online method to migrate to Azure SQL Database
• Migration to Azure SQL Database
• Exercise: Migrating a SQL Server database to Azure SQL Database

Module 6 Performing Post-Migration Tasks in Azure SQL

• SQL login and group migration
• Implementing security to protect Azure SQL
• Implementation of compliance controls for confidential data
• Monitoring the performance of a database
• Configuring high availability and disaster recovery
• Database task automation for scalability
• Exercise: Configure geographic replication for Azure SQL Database

Prerequisites

A solid understanding of both database-level and instance-level objects in SQL Server is recommended. Familiarity with Azure SQL resource provisioning and navigating the Azure portal is also essential.

Language

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

Microsoft Applied Skills

This course is part of the Microsoft Applied Skills Credentials.

To obtain this Microsoft Applied Skills credential, students must demonstrate the ability to evaluate and migrate SQL Server workloads to Azure SQL Database.

Applied Skills: Explore all credentials in one guide