SQL Server on Azure Mastery Bootcamp

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

SQL Server on Azure Mastery Bootcamp
Instructor-led Training

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.

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. 

About this Course

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

Advanced

Azure

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. 

Need to Train a Team?

Contact us to schedule a dedicated class for your team.