DP-3001 - Migrate SQL Server workloads to Azure SQL Database

To earn this Microsoft Applied Skills credential, learners 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.

Duration: 1.0 day

Enquire Now

Start learning today!

Click Hereto customize your Training

Objectives

  • Explain what data platform modernization 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 authorization 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.

Content

1. Design a SQL Server migration strategy

In this module, you'll learn the phases of a migration and the steps involved to ensure your migration project is executed smoothly. You'll also learn the purpose of data platform modernization and see the benefits it can bring to your organization.

Click here to know more

2. Assess SQL Server databases for migration to Azure SQL

Assessment tools such as Azure SQL Migration extension for Azure Data Studio, Azure Migrate, and Data Migration Assistant facilitate the migration of SQL Server databases to Azure.

Click here to know more

3. Deploy PaaS solutions with Azure SQL

Provision and deploy Azure SQL Database and Azure SQL managed instance. Select the appropriate options when performing a migration to the SQL PaaS platform.

Click here to know more

4. Configure database authentication and authorization

Contrast authentication using Microsoft Entra ID, Windows Active Directory, and SQL Server authentication. Implement various security principals and configure permissions.

Click here to know more

5. Migrate SQL Server workloads to Azure SQL Database

You will explore different migration tools and migrate SQL Server databases to Azure SQL Database.

Click here to know more

6. Perform post-migration tasks on Azure SQL

You'll explore different features and tools to help you maintain Azure SQL environments.

Click here to know more

Audience

Administrators, DevOps Engineers, Cloud Architects.

Prerequisites

Working knowledge of SQL Server, basic understanding of Azure and cloud concepts.

Certification

product-certification

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Microsoft Popular Courses

ms-700t00

The Managing Microsoft Teams course is designed for those aspiring to be Microsoft 365 Teams Administrators to deploy, configure and manage Office 365 workloads

az-900t00

This course is a high-level overview of Azure. The course will provide foundational level knowledge of cloud services and how those services are provided with M

sc-900t00

This course provides foundational level knowledge on security, compliance, and identity concepts and related cloud-based Microsoft solutions.

mb-335t00

MB-335T00 is a course code that refers to a specific training program or course offered by Microsoft. Unfortunately, as of my knowledge cutoff in September 2021
Enquire Now
RQTpXJ
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy