Microsoft - Applied Skills: Migrate SQL Server workloads to Azure SQL Database | DP-3001

Duration

Duration:

Only 1 Day

Method

Method:

Classroom / Online / Hybrid

Next date

Next date:

24/6/2024 (Monday)

Overview

On this Microsoft Applied Skills - Migrate SQL Server workloads to Azure SQL Database course, also known as DP-3001, you’ll demonstrate the ability to assess and migrate SQL Server workloads to Azure SQL Database.

In just 1 day, 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.

You will:

  • Configure a secure connection between an Azure Container Registry and an ACA
  • Create and configure a container app in Azure Container Apps
  • Configure continuous integration by using Azure Pipelines
  • Scale a deployed app in Azure Container Apps
  • Manage revisions in Azure Container Apps

At the end of this course, you’ll have the option to complete the Microsoft Applied Skills assessment lab, and earn your Microsoft Applied Skills - Migrate SQL Server workloads to Azure SQL Database credential.

Audience

This course is ideal for:

  • Database Administrators

Benefits

Other accelerated training providers rely heavily on lecture and independent self-testing and study.

Effective technical instruction must be highly varied and interactive to keep attention levels high, promote camaraderie and teamwork between the students and instructor, and solidify knowledge through hands-on learning.

Firebrand Training provides instruction to meet every learning need:

  • Intensive group instruction
  • One-on-one instruction attention
  • Hands-on labs
  • Lab partner and group exercises
  • Question and answer drills
  • Independent study

Curriculum

The DP-3001 course will teach you to:

  • 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 authorization
  • Migrate SQL Server workloads to Azure SQL Database
  • Perform post-migration tasks on Azure SQL

Exam Track

At the end of this course, you’ll have the option to complete the Microsoft Applied Skills assessment lab, and earn your Microsoft Applied Skills - Deploy and configure Azure Monitor credential.

What's Included

Your accelerated course includes:

  • Accommodation *
  • Meals, unlimited snacks, beverages, tea and coffee *
  • On-site exams **
  • Exam vouchers **
  • Practice tests **
  • Certification Guarantee ***
  • Courseware
  • Up-to 12 hours of instructor-led training each day
  • 24-hour lab access
  • Digital courseware **
  • * For residential training only. Accommodation is included from the night before the course starts. This doesn't apply for online courses.
  • ** Some exceptions apply. Please refer to the Exam Track or speak with our experts
  • *** Pass first time or train again free as many times as it takes, unlimited for 1 year. Just pay for accommodation, exams, and incidental costs.

Prerequisites

Before attending this accelerated course, you should have:

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

Unsure whether you meet the prerequisites? Don’t worry. Your training consultant will discuss your background with you to understand if this course is right for you.

Reviews

Here's the Firebrand Training review section. Since 2001 we've trained exactly 134561 students and asked them all to review our Accelerated Learning. Currently, 96.41% have said Firebrand exceeded their expectations.

Read reviews from recent accelerated courses below or visit Firebrand Stories for written and video interviews from our alumni.


"Training was very good, explanation was very clear and teacher detailed a lot, so for a 3 day course and to have a first understanding of POWER BI is good."
Rosanna Seerattan Cruz, JTI. (19/3/2024 (Tuesday) to 21/3/2024 (Thursday))

"The instructor and the structure of the course were very clear."
EK, JTI. (19/3/2024 (Tuesday) to 21/3/2024 (Thursday))

"Instructor was very knowledgeable and provided real life examples."
FO, NHS Lewisham and Greenwich. (11/10/2023 (Wednesday) to 13/10/2023 (Friday))

"Very intense and professional experience."
Anonymous. (11/10/2023 (Wednesday) to 13/10/2023 (Friday))

"Second course with Firebrand and more booked. Great tutors!"
Kenny Walker, BTEK Consultancy Ltd. (21/8/2023 (Monday) to 24/8/2023 (Thursday))

Course Dates

Start

Finish

Status

Location

Book now

19/2/2024 (Monday)

19/2/2024 (Monday)

Finished - Leave feedback

-

 

24/6/2024 (Monday)

24/6/2024 (Monday)

Wait list

Nationwide

 

5/8/2024 (Monday)

5/8/2024 (Monday)

Limited availability

Nationwide

 

16/9/2024 (Monday)

16/9/2024 (Monday)

Open

Nationwide

 

28/10/2024 (Monday)

28/10/2024 (Monday)

Open

Nationwide

 

9/12/2024 (Monday)

9/12/2024 (Monday)

Open

Nationwide

 

Latest Reviews from our students