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