Cloud Computing & Virtualisation - Category Banner

Microsoft DP-3001 - Migrate SQL Server workload to Azure SQL

Length 1 day

Course overview

View dates &
book now

Course locations >>

Why study this course

This one-day course prepares you for the task of migrating SQL Server workloads to Azure SQL Database.

You'll learn how to assess SQL Server components and compatibility for migration using the Azure SQL Migration Extension and Database Migration Assistant. This training guides you through the process of provisioning and configuring Azure SQL Database resources. You 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 for Azure SQL Database. These skills are essential for ensuring a smooth, efficient transition to Azure SQL Database, and maintaining its operation post-migration.

This one-day course prepares you for an Applied Skills credential.
For more than 30 years, Microsoft's industry-recognised certifications have provided proof of world-class technical proficiency for in-demand job roles. In today’s ever-changing business environment, there are also times when you need verified project-specific skills. Microsoft Applied Skills is a new verifiable credential that validates that you have the targeted skills needed to implement critical projects aligned to business goals and objectives. Applied Skills gives you a new opportunity to put your skills centre-stage, empowering you to showcase what you can do and what you can bring to key projects in your organisation.

Request Course Information

What you’ll learn

After completing this course, students will be able to:

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
Discover the various tools and options available for assessing SQL Server databases for migration purposes
Use the Azure migration extension for Azure Data Studio to assess SQL Server databases.
Use the Azure Migrate to assess SQL Server databases
Explore the basics of SQL Server in an Infrastructure as a Service (IaaS) offering
Deploy SQL Server into an Azure Virtual Machine
Gain an understanding SQL Server in a Platform as a Service (PaaS) offering
Examine Azure SQL Managed Instances
Explore Azure SQL Edge
Configure a template for PaaS deployment
Understand the importance of careful planning for a successful migration of SQL Server workloads to Azure Virtual Machines
Migrate databases using Azure SQL Migration extension for Azure Data Studio and tracking database migration activities to SQL Server on Azure Virtual Machines
Explore several other methods for migrating SQL Server databases to Azure Virtual Machines
Explore the advantages, capabilities, and migration possibilities offered by Azure SQL Database
Migrate databases using Azure SQL Migration extension for Azure Data Studio and tracking database migration activities
Use the Data Migration Assistant (DMA) tool to facilitate SQL Server migrations to Azure SQL Database
Use transactional replication as an online method to migrate to Azure SQL Database
Explore the advantages, capabilities, and migration possibilities offered by Azure SQL Managed Instance
Learn how Log Replay Service works to migrate to Azure SQL Managed Instance
Understand how Managed Instance link feature works in a migration scenario
Load and move data to and from Azure SQL Managed Instance
Implement compliance controls for sensitive data
Monitor database performance in Azure SQL
Configure high availability and disaster recovery in Azure SQL
Automate database tasks for scalability

Microsoft Azure at Lumify Work

Lumify Work has been delivering effective training across all Microsoft products for over 30 years. We are proud to be both Australia's and New Zealand’s first Microsoft Gold Learning Solutions Partner and the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers (MCTs) in ANZ. All Lumify Work Microsoft Azure courses follow Microsoft Official Curriculum (MOC) and are led by MCTs.

View all Microsoft Azure courses

Who is the course for?

Database Administrators
Data Engineers
Administrators

Course subjects

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

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

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.