Microsoft SQL Database
Azure SQL managed InstanceMigrate and modernize SQL on AzureIn Build
Migrate and Modernize SQL on Azure is a hands-on workshop designed for database professionals who want to assess, migrate, modernize, and manage SQL workloads on Azure. Participants explore migration strategies for Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines while implementing business continuity, replication, security, and monitoring solutions. Through industry-focused labs, learners gain practical experience modernizing SQL workloads using Azure AI, machine learning, and intelligent data platform capabilities.
MS Course ID: 02025
Last Updated: Sep 15, 2026
Get Started
Target Audience
Database Administrators , Database Developers and Infrastructure Engineers
Pre-requisites
Working knowledge of SQL Server and Transact-SQL, Azure fundamentals
Suggested Applied Skills
Microsoft Applied Skills: Migrate SQL Server workloads to Azure SQL DatabaseRelated Certifications
Course Syllabus
Assessment, Migration planning, and Azure readiness
Module 1: SQL Server Platform Fundamentals
SQL Server architecture, database engine components, and modernization fundamentals.
Module 2: Migration Assessment and Planning
Evaluate workloads and identify the right Azure SQL migration target.
Module 3: Migration Tools and Data Movement
Explore Azure DMS, SSIS, BCP, and migration tools for database movement
Hands-on labs
Industry oriented scenarios
Retail
Modernize a Global Retail Inventory Platform for Azure Migration
Financial Services
Evaluate Azure SQL Deployment Options for a Digital Banking Platform
Manufacturing
Develop a Cross-Platform Database Migration Strategy for a Manufacturing Enterprise
Migrating and Modernizing SQL workloads on Azure
Module 4: Azure SQL Database Migration
Plan and execute migrations to Azure SQL Database using proven migration patterns
Module 5: Azure SQL Managed Instance Migration
Modernize business-critical workloads while maintaining SQL Server compatibility
Module 6: SQL Server on Azure Virtual Machines
Implement lift-and-shift migration strategies and validate migrated workloads.
Hands-on labs
Industry oriented scenarios
E-Commerce
Migrate an E-Commerce Order Processing Platform to Azure SQL Database
Healthcare
Modernize a Healthcare Management Application with Azure SQL Managed Instance
Financial Services
Implement Business Continuity and Disaster Recovery for a Financial Trading Platform
AI, replication, security, and operations
Module 7: AI-Powered SQL Server Modernization
Build intelligent database solutions using vectors, embeddings, and Azure AI
Module 8: Data Replication and Synchronization
Implement replication strategies for hybrid and distributed SQL environments
Module 9 :Security, Monitoring, and Operations
Secure, monitor, and optimize SQL workloads using Azure and Microsoft Entra ID
Hands-on labs
Industry oriented scenarios
Digital Services
Build an AI-Powered Customer Knowledge Assistant Using SQL Server and Azure AI
Transportation & Logistics
Implement Real-Time Data Replication for a Global Logistics Network
Public Sector
Secure and Operate a Mission-Critical Government Data Platform on Azure
Multi-National Enterprise
Modernize a Global Enterprise SQL Estate with Azure SQL, AI, and High Availability
What You'll Learn
Course Details
- Duration
- 12 hours
- Level
- Advanced
- Role
- Technical
- Readiness Stage
- Project Ready
- Audience Segment
- Enterprise
- FY27 Key Workload (Core)
- Apps + Infra + Data + Sovereign Cloud + Defender
- Course Stage
- In Build
- Available on
- Oct 31, 2026
- Hands-on Labs
- Yes
- Labs Platform
- Skillable