.png)
Microsoft Azure Database Administrator Bootcamp
An Azure Database Administrator is responsible for the management, availability, security, performance monitoring, and optimization of modern relational database solutions. They also assist Azure Data Engineers in managing the operational aspects of a data platform solution. This bootcamp also prepares participants to pass the DP-300: Administering Relational Databases on Microsoft Azure exam to attain the Azure Database Administrator Associate certification.
About Course
As an Azure Database Administrator student you will be familiar with: - Deploying SQL database solutions within Azure - Azure SQL Server, database, and query architecture - Basic usage of Transact-SQL for administrative tasks - Securing Azure SQL resources and data - Interconnecting Azure SQL resources with other Azure services - Monitoring and optimizing Azure SQL Database performance - Maintaining business continuity for Azure SQL resources - Processes for migrating on-premises SQL Server databases to Azure - Other options for managing relational data in Azure
An Azure Database Administrator is responsible for the management, availability, security, performance monitoring, and optimization of modern relational database solutions. According to data from Glassdoor, the average salary for an Azure Database administrator in the United States is around $110,000 per year. However, salaries can range from $80,000 to $140,000 per year.
In these 8 weekends of Azure Data Administrator Bootcamp, we will coach you through the step-by-step process to scale your career as a Microsoft Azure Data Administrator. We also recommend scheduling 5 hours a week to complete any tasks from class. This bootcamp is held every weekend (Saturdays and Sundays) for the duration of the program. Live classes on Saturdays can last up to 4 hours and 3 hours on Sundays. Training time zone(s) is typically in the Eastern Standard Time Zone, West African Time Zone, British Summer Time Zone and Greenwich Mean Time Zone.
Bootcamp Benefits
1. Dual Certification from Microsoft (Microsoft Certified: Azure Database Administrator Associate) and Quantum Analytics Accredited Certificate at no extra cost.
2. Gain relevant work experience on your CV through the Quantum Analytics Virtual Growth Internship Program.
3. Land your first job as an Azure Administrator Within 6 Months of Completing your training.
4. Get access to remote work opportunities as an Azure Data Administrator & earn in USD.
5. CV Review & LinkedIn Optimization
6. Job search and interview preparation
7. On-the-Job Support (1 Month)
8. Work reference & recommendation letter from Quantum Analytics UK, US & Nigeria.
And more!
What You Will Learn
1. Introduction
Course Introduction
DP-300 Exam Overview
Course Overview
2. Deploying Azure SQL Databases
Introduction to Deploying Azure SQL Systems
Exploring SQL Database Deployment Options in Azure
Exploring Azure SQL Resource Configuration Basics
Examining the DTU Purchasing Model
Examining the vCore Purchasing Model
Examining the Standard/General Purpose Service Tiers
Examining the Premium/Business Critical Service Tiers
Examining the Hyperscale Service Tier
Selecting the “Best” Resource Configuration Options
Provisioning Azure SQL Database Servers
Provisioning Azure SQL Single Databases
Demo: Creating Azure SQL Database Servers and Single Databases using the Azure Portal
Provisioning Azure SQL Elastic Pools
Demo: Creating Elastic Pools using the Azure Portal
Provision Azure SQL Databases
Implementing SQL Server on Azure VMs
Demo: Provisioning SQL Server on Azure VM
Provisioning Azure SQL Managed Instances
Demo: Provisioning Azure SQL Managed Instance using the Azure Portal
Selecting the “Best” Azure SQL Deployment Option
Implement a SQL Server Database on an Azure VM
Automating SQL Deployment with PowerShell and Azure CLI
3. Securing Azure SQL Databases
Introduction to Securing Azure Resources
Authorizing Management Access to Azure SQL Objects
Controlling Network Access to Azure SQL Databases
Controlling Network Access to SQL Virtual Machines
Controlling Network Access to Azure SQL Managed Instances
Managing Azure SQL Authentication
Authorizing SQL Data Access
Manage Access to Azure SQL Data
Protecting SQL Data
Integrating with Azure Key Vault
Demo: Integrating Azure SQL with Azure Key Vault
Demo: Enable Column Encryption in SSMS
Examining Azure Defender for SQL
Monitoring Azure SQL Activity
SQL Data Discovery and Classification
Protect SQL Database Data
4. Implementing HA/DR for Azure SQL
Introduction to Implementing HA/DR for Azure SQL
SQL Virtual Machine Backup and Recovery Options
Azure SQL PaaS Backup and Recovery Options
SQL Server Continuity Solutions
Azure Virtual Machine Continuity Solutions
Azure SQL PaaS Continuity Solutions
Perform SQL Database Backup and Recovery in Azure
5. Migrating to Azure SQL
Introduction to Migrating to Azure SQL
Exploring the Azure SQL Migration Process
Exploring SQL Migration Tools & Services
Exploring Azure SQL Migration Methods
Azure SQL Family Migration Considerations
Working with the Azure Database Migration Service
6. Monitoring and Maintaining Azure SQL Database Performance
Introduction to Azure SQL Performance
Working with Performance Baselines
Identifying Performance Problems
Working with Extended Events
Use Extended Events to Identify Performance Problems
Improving System Performance
Examining Azure SQL Scalability Options
Improving Query Performance
Resolve Query Performance Issues
Maintaining Performance
Manually Implement Database Maintenance
Automating Maintenance
Working with SQL Server Agent
Establish a Maintenance Plan on SQL Server
Working with Azure Automation
Working with Elastic Jobs
Automate Maintenance on Azure SQL Databases
What Our Students Say
Microsoft Azure Database Administrator Review From Our Students
Quantum Analytics Azure Database Admin course was exactly what I needed to advance in my career. The detailed curriculum and hands-on labs made complex concepts easy to understand.
The real-world projects in the Azure Database Admin course at Quantum Analytics were incredibly valuable. They helped me gain practical experience that I now use daily in my job.
The Azure Database Administration training at Quantum Analytics was exceptional. The instructors provided clear, concise explanations, and the practical exercises really solidified my learning.
The support from instructors at Quantum Analytics was incredible. They were always available to answer questions and provide guidance, which made the Azure Database Admin course much easier to navigate.
