Cloud Computing and Visualisation Category Banner Image

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

  • Length 1 day
Course overview
View dates &
book now

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.

Microsoft Applied Skills
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 center stage, empowering you to showcase what you can do and what you can bring to key projects in your organisation. Prepare for your Applied Skills credential with this one-day, instructor-led training course.

Request Course Information


What you’ll learn

After completing this course, students will be able to:

  • Explain what data platform modernisation is

  • 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

  • Understand common compatibility issues and blockers that may prevent a migration to Azure SQL

  • 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

  • Use Data Migration Assistant (DMA) to assess SQL Server databases

  • Gain an understanding SQL Server in a Platform as a Service (PaaS) offering

  • Understand PaaS provisioning and deployment options

  • Understand elastic pools

  • Examine Azure SQL Managed Instances

  • Explore Azure SQL Edge

  • Configure a template for PaaS deployment

  • Learn about authentication options for Azure SQL Database

  • Create various security principals

  • Configure permissions within a SQL database

  • Identify authentication and authorisation failures

  • 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 several other methods for migrating SQL Server databases to Azure SQL Database

  • 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 Partner Cloud Logo

Microsoft Azure at Lumify Work

Lumify Work is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia's and New Zealand’s first and largest Microsoft Gold Learning Solutions Partner. All Lumify Work Microsoft Azure courses follow Microsoft Official Curriculum (MOC) and are led by Microsoft Certified Trainers. Join more than 5,000 students who attend our quality Microsoft courses every year.


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 PaaS solutions with Azure SQL

  • Configure database authentication and authorisation

  • Migrate SQL Server workloads to Azure SQL Database

  • 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.


Request Course Information

Personalise your schedule with Lumify USchedule

Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.



Offers

Continue your learning experience online with Lumify Plus
Lumify Plus (formerly DDLS Plus) is your online learning pathway to extend knowledge beyond courses. Get resources to help you practice what you learned and prepare for future courses, exams and certifications.
Microsoft Azure Developer & DOI DevOps Foundation Bundle
This bundle brings together two globally recognised and sought after courses to set you apart from the rest and give you the edge you need to advance your career.