Migrate SQL Server workload to Azure SQL (DP-3001)

Duration : 1 day

Applied Skills training courses are designed to validate specific skills by focusing on real-life scenarios. They offer a targeted alternative to traditional role-based certifications, focusing on the application of technical skills in work situations.

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

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

Additionally, you'll also learn to perform post-migration tasks like disaster recovery and monitoring. These skills are essential for ensuring a smooth, efficient transition to Azure SQL, and maintaining its operation post-migration.

Audience

• Administrator
• Data Engineer
• Database Administrator
• Developer

Prerequisites

• Experience with SQL Server databases.
• Knowledge of SQL Server editions and versions.
• Basic knowledge of security concepts like identities and permissions.
• Experience using the Azure portal to create resources and set permissions.

Objectives

• Designing a SQL Server Migration Strategy: You will learn how to plan and design an effective approach for migrating your SQL Server databases to Azure SQL.

• Assessing SQL Server Databases for Migration to Azure SQL: You will explore evaluation tools such as the Azure SQL Migration extension and the Database Migration Assistant. These tools will help you assess the compatibility of SQL Server components for migration.

• Deploying PaaS Solutions with Azure SQL: You will discover how to provision and configure Azure SQL resources. Additionally, you’ll learn to choose and configure appropriate options for high availability.

• Configuring Authentication and Authorization for Databases: You will master aspects related to authentication and permissions within the context of Azure SQL.

Teaching method

Notez que vous aurez besoin d’un abonnement Azure pour effectuer les exercices pratiques. Si vous n’en avez pas encore, vous pouvez créer un compte gratuit et ajouter un abonnement avant de commencer.

Please note that you will need an Azure subscription to perform the practical exercises. If you don’t have one yet, you can create a free account and add a subscription before getting started.

Contents

• Design a SQL Server migration strategy
• Assess SQL Server databases for migration to Azure SQL
• Deploy IaaS solutions with Azure SQL
• Deploy PaaS solutions with Azure SQL
• Migrate SQL Server workloads to Azure Virtual Machine
• Migrate SQL Server workloads to Azure SQL Database
• Migrate SQL Server workloads to Azure SQL Managed Instance
• Perform post-migration tasks on Azure SQL