Modernize SQL Server workloads and accelerate cloud adoption with Azure SQL Database.

Learn how to assess, plan, and migrate SQL Server workloads to Azure SQL Database while minimizing risk and disruption. Develop practical skills in migration planning, database assessment, Azure migration tools, performance optimization, and cloud database management to support successful modernization initiatives.

  • Why get trained: Gain hands-on knowledge of proven migration methodologies, Azure-native tools, and best practices that help streamline database modernization projects and improve operational efficiency.
  • Why it matters: Organizations are increasingly moving database workloads to the cloud to improve scalability, availability, security, and cost efficiency. Professionals with database migration expertise play a critical role in supporting cloud transformation initiatives and business modernization efforts.
  • Who should attend: Database administrators, database engineers, cloud engineers, data professionals, infrastructure specialists, solutions architects, and IT professionals responsible for database migration or cloud adoption projects.

Build the skills to migrate SQL Server environments confidently, optimize cloud database performance, and support long-term digital transformation initiatives. HRD Corp Claimable.

Overview

Validate your technical skills and open doors to new possibilities of advancement with Microsoft Applied Skills.

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.

Skills Covered

  • Perform post-migration configuration
  • Configure disaster recovery
  • Assess and prepare databases for migration
  • Migrate a database to an Azure SQL database
  • Provision and configure an Azure SQL database.

Prerequisites

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

Target Audience

  • Database Administrator
  • Data Engineer
  • Administrator

Course Curriculum

Module 1: Design a SQL Server Migration Strategy

Learn the phases of a migration project and the steps required to ensure a successful migration. Explore the purpose of data platform modernization and the benefits it can bring to your organization.

Learning Objectives

By the end of this module, you will be able to:

  • Explain what data platform modernization is.
  • Review the stages of a data migration.
  • Recommend when to use Azure data platform technologies.
  • Explore the cost savings of moving SQL workloads to Azure.

Prerequisites

  • Understanding of on-premises SQL Server databases.
  • Understanding of current database workloads.

Module 2: Assess SQL Server Databases for Migration to Azure SQL

Learn how assessment tools help evaluate SQL Server databases for migration to Azure SQL.

Learning Objectives

By the end of this module, you will be able to:

  • Understand common compatibility issues and migration blockers.
  • Identify tools and options available for migration assessments.
  • Use the Azure SQL Migration extension for Azure Data Studio to assess databases.
  • Use Azure Migrate to assess SQL Server databases.
  • Use Data Migration Assistant (DMA) to assess SQL Server databases.

Prerequisites

  • Experience administering SQL Server databases.
  • Knowledge of SQL Server editions and versions.

Module 3: Deploy PaaS Solutions with Azure SQL

Provision and deploy Azure SQL Database and Azure SQL Managed Instance while selecting the appropriate migration options for Platform as a Service (PaaS) environments.

Learning Objectives

By the end of this module, you will be able to:

  • Understand SQL Server as a Platform as a Service (PaaS) offering.
  • Understand PaaS provisioning and deployment options.
  • Understand elastic pools.
  • Examine Azure SQL Managed Instance.
  • Explore Azure SQL Edge.
  • Configure deployment templates for PaaS environments.

Prerequisites

  • Ability to create and configure on-premises SQL Server databases.
  • Experience creating and configuring resources using the Azure portal.

Module 4: Configure Database Authentication and Authorization

Learn how to implement authentication and authorization in Azure SQL environments.

Learning Objectives

By the end of this module, you will be able to:

  • Understand authentication options for Azure SQL Database.
  • Create and manage security principals.
  • Configure database permissions.
  • Identify authentication and authorization failures.

Prerequisites

  • Ability to run queries against Microsoft SQL databases.
  • Understanding of database security concepts.
  • Basic knowledge of T-SQL.
  • Experience using the Azure portal.

Module 5: Migrate SQL Server Workloads to Azure SQL Database

Explore migration tools and techniques for moving SQL Server workloads to Azure SQL Database.

Learning Objectives

By the end of this module, you will be able to:

  • Explore the capabilities and benefits of Azure SQL Database.
  • Migrate databases using the Azure SQL Migration extension for Azure Data Studio.
  • Track database migration activities.
  • Use Data Migration Assistant (DMA) to support migrations.
  • Use transactional replication as an online migration method.
  • Explore additional migration methods for Azure SQL Database.

Prerequisites

  • Experience administering SQL Server databases.
  • Knowledge of SQL Server editions and versions.
  • Basic knowledge of T-SQL.

Module 6: Perform Post-Migration Tasks on Azure SQL

Explore tools and features used to manage, secure, and optimize Azure SQL environments after migration.

Learning Objectives

By the end of this module, you will be able to:

  • Implement compliance controls for sensitive data.
  • Monitor database performance in Azure SQL.
  • Configure high availability and disaster recovery solutions.
  • Automate database administration tasks for scalability.

Prerequisites

  • Ability to navigate the Azure portal.
  • Understanding of traditional database administration responsibilities.
  • Basic experience with T-SQL programming.

Dates & Locations

Let’s make it work for you

Can’t find a date that fits? Need to train your whole team? Looking for a discount?
Speak to one of our learning experts today.

x Clear all selections

June 22, 2026 - June 22, 2026

Location: Kuala Lumpur
Modal: ILT
Availability: TBC
RM 1200

June 22, 2026 - June 22, 2026

Location: Online
Modal: VILT
Availability: TBC
RM 1200

September 21, 2026 - September 21, 2026

Location: Kuala Lumpur
Modal: ILT
Availability: TBC
RM 1200

September 21, 2026 - September 21, 2026

Location: Online
Modal: VILT
Availability: TBC
RM 1200

December 8, 2026 - December 8, 2026

Location: Kuala Lumpur
Modal: ILT
Availability: TBC
RM 1200

December 8, 2026 - December 8, 2026

Location: Online
Modal: VILT
Availability: TBC
RM 1200
Trainocate exam and cert

Exam & Certification

Microsoft Applied Skills: Migrate SQL Server workloads to Azure SQL Database.

To earn this Microsoft Applied Skills credential, learners demonstrate the ability to assess and migrate SQL Server workloads to Azure SQL Database.

Candidates for this credential should have a solid understanding of both database-level and instance-level scoped objects in SQL Server. They should also be familiar with provisioning Azure SQL resources and navigating the Azure portal.

Evaluated in this assessment

  • Perform post-migration configuration
  • Configure disaster recovery
  • Assess and prepare databases for migration
  • Migrate a database to an Azure SQL database
  • Provision and configure an Azure SQL database

Training & Certification Guide

Mastery Program: Learn AI with Microsoft in 2025

Artificial Intelligence (AI) has been one of the hottest topics in the tech industry for the past decade. With its rapid advancements and potential to impact our daily lives, learning AI has become a highly sought-after skill.

We are thrilled to announce the launch of our Microsoft AI Mastery Program in 2024, made possible through our partnership with Microsoft, a renowned leader in AI technology. This program is tailored for individuals and tech professionals passionate about acquiring and mastering the fundamental and advanced principles of AI.

Top AI Skills Malaysia Needs Today: Advance Your IT Career in 2025

In the quest for AI-driven innovation, Malaysia seeks sharp minds with the right IT skills. Data science, machine learning—these are the tools in high demand. This article examines the AI skills Malaysia needs, the industries driving this change, and how to develop these skills to enhance your career trajectory.

Which AI Certification Is Right for You? A Role-by-Role Guide to Upskilling in 2025

Certifications are more than just a résumé boost—they’re often a key deciding factor. Employers are prioritizing candidates with industry-recognized credentials, not only for technical roles but also for positions in operations, strategy, and product development that now rely on data fluency and AI awareness.

Top 5 High-Paying Cloud Jobs in Malaysia & How to Get Them

In this blog, we break down the top five highest-paying cloud roles in Malaysia, what they entail, and how you can start building a career in this space.

Addressing the AI Skills Gap in Malaysia

The Artificial Intelligence (AI) surge across global industries has created immense potential for innovation and economic growth. For Malaysia, AI is pivotal in its ambition to become a digital-first economy. However, despite this goal, the country faces a significant AI skills gap—a shortfall in the number of skilled professionals equipped to meet the rising demands for AI expertise across various industries.

This blog examines the causes, impact, and initiatives underway to bridge this gap, ensuring Malaysia remains competitive in the digital age.

Top Microsoft Applied Skills Courses to Boost Your Career

Microsoft Applied Skills are scenario-based practical credentials that confirm your ability to tackle real-world challenges using Microsoft technologies.

In this article, we will dive into what these skills are, how they differ from traditional certifications, and the benefits they bring to your career. Expect insights on top courses, the assessment process, and tips for success.

Top AI Machine Learning Certifications to Boost Your Career in 2025

Looking to excel in AI and machine learning? The right certification can make all the difference. This article covers the top AI machine learning certifications for 2025 that can boost your career and validate your expertise in this ever-evolving field.

The Ultimate Guide to the Top Data and AI Skills for 2026

This guide serves as your comprehensive roadmap to navigating this new landscape. We will deconstruct the four essential pillars of Data and AI mastery for 2026, providing a clear blueprint for a future-proof career.

This cornerstone article will provide a high-level strategic overview, setting the stage for our deep-dive blog series that will explore each pillar in granular detail.

Mastering the Foundational Data Analytics Skills That Get You Hired in 2026

This article is your deep dive into the three non-negotiable, must-have data analytics skills that will get you hired in 2026.

Which AI and Machine Learning Skills Will Define 2026?

This article will guide you through the specific, advanced skills that separate a data professional from a true AI specialist in 2026.

Why Data Engineering is the Hottest Tech Career of 2026

In the race to dominate the AI-powered future, companies are investing billions in advanced algorithms and brilliant data scientists. This article explores the essential skills you need to become a data engineer and build the very backbone of AI.

4 Strategic AI Skills Every Manager Needs in 2026

This article breaks down the four essential strategic AI skills every leader needs to master to navigate this new frontier

DP-300T00: Implement Scalable Database Solutions using Azure SQL

This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings.

DP-3011: Implement a Data Analytics Solution with Azure Databricks

Learn how to harness the power of Apache Spark and powerful clusters running on the Azure Databricks platform to run data analytics workloads in a data lakehouse.

DP-3014: Build Machine Learning Solutions using Azure Databricks

Azure Databricks is a cloud-scale platform for data analytics and machine learning. Data scientists and machine learning engineers can use Azure Databricks to implement machine learning solutions at scale.

DP-3015: Getting Started with Cosmos DB NoSQL Development

This course teaches developers to utilize Azure Cosmos DB for NoSQL API and SDK. Students will learn query execution, resource configuration, SDK operations, and design strategies for non-relational data modeling and data partitioning.

DP-3020: Develop data-driven applications by using Azure SQL Database

This learning path prepares you for the task of developing data-driven applications by using Microsoft Azure SQL Database.

DP-3021: Configure and migrate to Azure Database for PostgreSQL

In this learning path, you learn the main features of PostgreSQL and how they work in Azure Database for PostgreSQL. You learn about the different Azure Database for PostgreSQL implementation options, and how to configure a server for your needs.

Microsoft Certified: Power BI Data Analyst Associate

The Microsoft Certified: Power BI Data Analyst Associate certification equips professionals with advanced skills to prepare, model, visualize, and analyze data using Power BI.

Microsoft Certified: Azure AI Engineer Associate

This certification validates the skills of Azure AI Engineers in building, managing, and deploying AI solutions using Azure AI. Candidates participate in all phases of AI solution development, from design and development to deployment, integration, and monitoring.

Microsoft Certified: Azure Data Scientist Associate

The Microsoft Certified: Azure Data Scientist Associate certification is designed for professionals who specialize in data science and machine learning on the Azure platform.

Microsoft Certified: Fabric Analytics Engineer Associate

The Microsoft Fabric Analytics Engineer Associate certification (exam DP‑600) is an intermediate-level credential for data engineers and analysts.

Microsoft Certified: Fabric Data Engineer Associate

The Microsoft Certified: Fabric Data Engineer Associate certification is a role-based credential designed for professionals who specialize in data engineering on the Microsoft Fabric platform.

Frequently Asked Questions

Speak to a Training Consultant

All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631

Preferred mode of training
Checkboxes