Modernize Your SQL Server Estate to Azure SQL
Cloud and AI Platforms
Modernize with confidence (Core)
Advanced
Microsoft SQL DatabaseMicrosoft SQL Database
Azure SQL managed InstanceAzure SQL managed Instance

Modernize Your SQL Server Estate to Azure SQL
In Build

Modernize Your SQL Server Estate to Azure SQL is a hands-on workshop that equips database professionals with the skills to assess, migrate, optimize, and modernize SQL Server workloads on Azure. Participants learn how to evaluate migration readiness, analyze compatibility and costs, select the appropriate Azure SQL destination, and implement migration strategies using Microsoft-native tools and services. Through practical labs, learners design resilient, cost-optimized solutions, implement security and governance controls, and explore AI-ready Azure SQL capabilities including vector search and embeddings, enabling a secure, scalable, and future-ready data platform.

12 hours(Suggested: 3 days, 4h/day)TechnicalProject ReadyHands-on Labs

MS Course ID: 02025

Last Updated: Oct 5, 2026

Get Started

Target Audience

Database Administrators, Database Developers and Infrastructure Engineers

Pre-requisites

Working knowledge of SQL Server and Transact-SQL,Azure fundamentals

Related Certifications

AZ-104
DP-300

Course Syllabus

1

Assess and plan SQL Server modernization

Module 1: Review Azure Solution Assessment Results

• Discover SQL Server workloads and migration readiness
• Analyze compatibility, sizing, and cost recommendations
• Identify Azure SQL destination options based on assessment findings

Module 2: Migration Tooling and Best Practices

• Explore Microsoft migration tools and services
• Compare destination-specific migration approaches
• Plan migration strategies, cutover, and rollback scenarios
90 mins
Lecture
2

Hands-on labs

Lab 1: Assess migration readiness for a SQL Server Estate

• Exercise 1: Discover SQL Server instances and databases
• Exercise 2: Run an Azure SQL Migration assessment
• Exercise 3: Identify compatibility Issues and migration risks

Lab 2: Select the Right Azure SQL Destination

• Exercise 1: Compare Azure SQL deployment Options
• Exercise 2: Map workloads to Azure SQL destinations
• Exercise 3: Create a destination recommendation matrix

Lab 3: Design a migration strategy

• Exercise 1: Compare migration tooling options
• Exercise 2: Select online and offline migration approaches
• Exercise 3: Create a migration cutover plan

Lab 4: Estimate Azure migration costs

• Exercise 1: Calculate Azure SQL deployment costs
• Exercise 2: Compare SQL VM, Managed Instance, and Hyperscale costs
• Exercise 3: Optimize deployment sizing and licensing
150 mins
Lab
3

Prioritize, design, and optimize Azure SQL destinations

Module 3: Azure SQL Destination Prioritization

• Compare Azure SQL VM, Managed Instance, and Hyperscale
• Prioritize workloads using compatibility and business requirements
• Select AI-ready Azure SQL destinations for modernization

Module 4: Business Continuity, Disaster Recovery, and Cost Optimization

• Define recovery objectives and resiliency requirements
• Design HA/DR strategies across Azure SQL destinations
• Apply cost optimization, licensing, and capacity planning strategies
90 mins
Lecture
4

Hands-on labs

Lab 5: Deploy Azure SQL migration targets

• Exercise 1: Deploy SQL Server on Azure Virtual Machine
• Exercise 2: Deploy Azure SQL database
• Exercise 3: Deploy Azure SQL Managed Instance

Lab 6: Migrate databases to Azure SQL database

• Exercise 1: Configure Azure database Migration Service
• Exercise 2: Migrate a SQL Server database to Azure SQL database
• Exercise 3: Validate Migration results

Lab 7: Migrate Databases to Azure SQL Managed Instance

• Exercise 1: Configure Log Replay service
• Exercise 2: Migrate a database to Azure SQL Managed Instance
• Exercise 3: Validate database migration

Lab 8: Configure business continuity and optimize costs

• Exercise 1: Configure Geo-Replication and failover
• Exercise 2: Define recovery objectives and DR strategy
• Exercise 3: Optimize Azure SQL costs
150 mins
Lab
5

Build secure and AI-ready Azure SQL solutions

Module 5: AI-Native Data Platform Design

• Design AI-ready Azure SQL architectures
• Implement vectors, embeddings, and semantic retrieval patterns
• Optimize performance for AI and operational workloads

Module 6: Governance, Security, and Operations

• Secure Azure SQL using Microsoft Entra ID and security controls
• Implement auditing, compliance, and governed data access
• Monitor and manage Azure SQL operational environments
90 mins
Lecture
6

Hands-on labs

Lab 9: Secure Azure SQL workloads

• Exercise 1: Configure Microsoft Entra authentication
• Exercise 2: Enable SQL auditing and monitoring
• Exercise 3: Configure Microsoft Defender for SQL

Lab 10: Implement governance and data protection

• Exercise 1: Configure data access controls
• Exercise 2: Implement auditing and compliance controls
• Exercise 3: Validate governance policies

Lab 11: Enable AI-Ready capabilities in Azure SQL

• Exercise 1: Create Vector-enabled database objects
• Exercise 2: Load and query vector data
• Exercise 3: Perform Hybrid and semantic search
150 mins
Lab

What You'll Learn

Understand core concepts and best practices
Hands-on experience with real-world scenarios
Learn from certified Microsoft experts
Prepare for relevant certifications
Access to lab environments
Post-training support and resources

Course Details

Duration
12 hours
Level
Advanced
Role
Technical
Readiness Stage
Project Ready
Audience Segment
Enterprise
Course Stage
In Build
Available on
Nov 30, 2026
Hands-on Labs
Yes
Labs Platform
Skillable

Partner Skilling Catalog

Comprehensive course catalog for Microsoft partners. Access world-class training on Azure, AI, Security, and more to accelerate your cloud journey.

Connect

Legal & Support

© 2026 Technofocus. All rights reserved.

Sponsored by Microsoft Partner Enablement