This course runs for a duration of 1 Day.
The class will run daily from 8:00 AM CST to 4:00 PM CST.
Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.
Course Overview
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.
WHO SHOULD ATTEND?
WHAT YOU'LL LEARN
Design a SQL Server migration strategy
Examine data platform modernization
Plan a data migration
Explore the available data migration technologies
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
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
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
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
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