SQL Server on Azure Mastery Bootcamp 

Equip yourself with the knowledge and skills to effectively manage SQL databases in the Azure cloud environment.

Rectangle 11806-min

You will be redirected to pay $2999.99 for enrollment.

Students in a classroom-min

Course Description

The SQL Server DBAs on Azure Mastery Bootcamp is designed to equip database administrators with the knowledge and skills needed to manage SQL databases in the Azure cloud environment effectively. Whether you're new to Azure or an experienced SQL DBA looking to adapt your expertise to the cloud, this course will provide you with essential insights and practical experience. 

Audience Profile

The SQL Server on Azure mastery boot camp is designed for SQL Server data professionals that are moving SQL Server workloads to Microsoft Azure.  

Challenge Based Projects 

The last 2 days of the class students will participate in a hands-on project in an isolated Azure environment (included with the class) to give students practical immersive experience. 

Learning Styles 

  • Presentation 
  • Hands-on labs 
  • Challenge based skills. 
Course Description

About this course

Couse Outline

Module 1: Prepare to maintain SQL databases on Azure 

In Module 1, you'll prepare to maintain SQL databases on Azure. Explore the core concepts of Azure SQL Database and learn how to set up the necessary infrastructure and configurations. Understand key considerations for security, monitoring, and maintenance to ensure your databases run smoothly on Azure. 

Module 2: Deploy IaaS solutions with Azure SQL 

Module 2 focuses on deploying Infrastructure as a Service (IaaS) solutions with Azure SQL. Learn how to provision and manage SQL Server instances on Azure Virtual Machines (VMs). Explore topics such as VM sizing, configuration, high availability, and performance optimization to effectively deploy SQL workloads in an IaaS environment. 

Module 3: Deploy PaaS solutions with Azure SQL 

In Module 3, you'll delve into Platform as a Service (PaaS) solutions with Azure SQL. Discover how to create and manage Azure SQL Database, Azure SQL Managed Instance, and other PaaS offerings. Explore scalability, data tier applications, and advanced features to deploy and maintain your SQL databases efficiently in a PaaS environment. 

Module 4: Evaluate Strategies for migrating to Azure SQL 

Module 4 is all about evaluating strategies for migrating your existing on-premises or cloud-based SQL workloads to Azure SQL. Learn to assess your current environment, analyze dependencies, and choose the most suitable migration approach. Explore lift-and-shift, re-architecting, and modernization strategies to make informed decisions. 

Module 5: Migrate SQL Server workloads to Azure SQL Database 

In Module 5, you'll focus on migrating SQL Server workloads to Azure SQL Database. Explore practical steps to plan and execute the migration process. Learn about database compatibility, data migration tools, and best practices for a seamless transition to Azure SQL Database. Ensure data integrity and minimal downtime during migration. 

Team Based Project 

  • Project: SQL Modernization and Migration 


5 Days



Need to Train a Team?

Contact us to schedule a dedicated class at your location.