SQL Server on Azure Mastery Bootcamp

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

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

Course 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