DP-3001: Migrate SQL Server workload to Azure SQL

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

To earn this Microsoft Applied Skills credential, students 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, Database Administrator

DP-3001 Training Objectives

• Perform post-migration configuration
• Setting up disaster recovery
• Database evaluation and preparation for migration
• Migrating databases to Azure SQL databases
• Provision and configure Azure SQL databases.

DP-3001 Course Content

Module 1 Designing a SQL Server Migration Strategy

• Data Platform Modernization Review
• Planning a data migration
• Exploring the technologies available for data migration
• Exercise: Comparing Azure On-Premises Costs

Module 2: Assessing SQL Server Databases for Migration to Azure SQL

• Reviewing the database for compatibility
• Exploring Assessment Options for Database Migration
• Assessing a database with the Azure Migration Extension
• Assessing a database with Azure Migrate
• Assessing a database with Data Migration Assistant
• Exercise: Identifying Compatibility Issues

Module 3 Implementing PaaS Solutions with Azure SQL

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

Module 4 Configuring Authentication and Authorization

• 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 Login 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
• Migrating to Azure SQL Database with BACPAC
• Using an online method to migrate to Azure SQL Database
• Moving to Azure SQL Database
• Exercise: Migrating a SQL Server database to Azure SQL Database

Module 6: Performing Post-Migration Tasks in Azure SQL

• Migrating SQL logins and groups
• Implementing security to protect Azure SQL
• Implementing compliance controls for sensitive data
• Monitoring the performance of a database
• Configuring High Availability and Disaster Recovery
• Automating database tasks for scalability
• Exercise: Configure geo-replication for Azure SQL Database

Prerequisites

A solid understanding of both database-level and instance-level scoped objects in SQL Server is recommended. 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, students must demonstrate the ability to assess and migrate SQL Server workloads to Azure SQL Database.

Applied Skills: Explore all credentials in one guide