Upcoming dates

All times shown in the class's own timezone. 2 of 2 are guaranteed to run, meaning they go ahead regardless of enrollment.

Dates	Starts	Where	Status	Seat	Book
Mon, Sep 14	9:00 AM to 5:00 PM EDT	Live virtual	GUARANTEED	$695
Fri, Jan 15	9:00 AM to 5:00 PM EST	Live virtual	GUARANTEED	$695

About this class

This learning path 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.

What you'll be able to do

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

Course outline

1 - Design a SQL Server migration strategy

Examine data platform modernization
Plan a data migration
Explore the available data migration technologies

2 - Assess SQL Server databases for migration to Azure SQL

Review database for compatibility
Explore assessment options for database migration
Assess a database with Azure Migration extension
Assess a database with Azure Migrate
Assess a database with Data Migration Assistant

3 - Deploy PaaS solutions with Azure SQL

Explain PaaS options for deploying SQL Server in Azure
Explore single SQL database
Deploy SQL database elastic pool
Understand SQL database hyperscale
Examine SQL managed instance
Describe SQL Edge

4 - Configure database authentication and authorization

Describe Active Directory and Microsoft Entra ID
Describe authentication and identities
Describe Security Principals
Describe database and object permissions
Identify authentication and authorization failures

5 - Migrate SQL Server workloads to Azure SQL Database

Choose the right Azure SQL Database feature
Use Azure SQL migration extension to migrate to Azure SQL Database
Explore Data Migration Assistant to migrate to Azure SQL Database
Migrate to Azure SQL Database using BACPAC
Use an online method to migrate to Azure SQL Database
Move data to Azure SQL Database

6 - Perform post-migration tasks on Azure SQL

Migrate SQL logins and groups
Implement security to protect Azure SQL
Implement compliance controls for sensitive data
Monitor database performance
Configure high availability and disaster recovery
Automate database tasks for scalability

Before you attend

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.