Microsoft Azure SQL Solutions Training
This course trains professionals to administer scalable SQL-based databases in both IaaS (Azure VMs) and PaaS (Azure SQL Database/Managed Instance) environments. It covers critical administration topics, including security implementation with Microsoft Defender, performance optimization using Intelligent Query Processing (IQP), High Availability and Disaster Recovery (HA/DR) planning with AG and WSFC, and automation using PowerShell and Azure CLI. This course is ideal for those preparing for the Administering Microsoft Azure SQL Solutions Exam (DP-300).
Microsoft Azure SQL Solutions Training
Course Overview
Students will learn to:
- Plan, deploy and configure Azure SQL offerings
- Monitor database performance and tune a database and queries for optimum performance
- Plan and configure a High Availability Solution
Course Outline
- Module 1: Planning and Implementing Data Platform Resources
- Prepare to Maintain SQL Server-based Databases on Azure
- Deploy IaaS Solutions with Azure SQL
- Deploy PaaS Solutions with Azure SQL
- Migrate SQL Server Workloads to Azure SQL Database
- Migrate SQL Server Workloads to Azure SQL Managed Instance
- Module 2: Implementing a Secure Database Environment
- Configure Database Authentication and Authorization
- Protect Data In-Transit and At Rest
- Implement Compliance Controls for Sensitive Data
- Module 3: Monitoring and Optimization
- Describe Performance Monitoring
- Configure SQL Server Resources for Optimal Performance
- Configure Databases for Optimal Performance
- Module 4: Optimizing Query Performance in Azure SQL
- Explore Query Performance Optimization
- Explore Performance-Based Database Design
- Evaluate Performance Improvements
- Module 5: Automating Database Tasks for Azure SQL
- Automate Database Deployment
- Create and Manage SQL Agent Jobs
- Manage Azure PaaS Tasks Using Automation
- Module 6: High Availability and Disaster Recovery
- Describe HA/DR Strategies
- Explore IaaS and PaaS Solutions for HA/DR
- Back Up and Restore Databases
- Module 7: Lab Outline
- Provision SQL Server on an Azure Virtual Machine
- Provision an Azure SQL Database
- Authorize access with Microsoft Entra ID and configure firewall rules
- Enable Microsoft Defender for SQL and Data classification
- Isolate performance problems through monitoring and fix fragmentation/blocking issues
- Identify database design issues and isolate problem areas in poorly performing queries
- Deploy Azure SQL Database using ARM template
- Create a CPU status alert for a SQL Server
- Deploy an automation runbook to automatically rebuild indexes
- Configure geo-replication and implement Backup to/Restore from URL
Intended Audience
Database Administrators who manage and maintain on-premises or cloud-based SQL Server databases and are looking to migrate to or work within Azure.
Data Engineers and IT Professionals involved in planning, deploying, configuring, optimizing, and securing Azure SQL environments.
Cloud Database Professionals seeking to expand their cloud database management skills, especially in IaaS and PaaS scenarios with Azure SQL Database and SQL Managed Instances.
Candidates preparing for the Microsoft DP-300 Certification Exam as part of earning the Microsoft Certified: Azure Database Administrator Associate credential.
Prerequisites
- • Working with, maintaining, and developing with SQL Serve
- • Experience with Azure, such as deploying and managing resources
- • Recommended Prior Course: DP-900T00: Introduction to Microsoft Azure Data
Follow-On Course
Related training topics
Justify your training
Use this sample request letter — copy it into an email to your manager and personalize the bracketed details to make the case for the time and budget.
Sample training request letter
Subject: Request for Data Analytics & Databases training from Applied Technology Academy
[Decision Maker Name],
I'm writing to request time and budget approval to complete Applied Technology Academy's course, Microsoft Azure SQL Solutions Training. The information below outlines how this training benefits our organization, the tasks I'll be able to perform after completing it, and relevant cost and funding details.
Course Description
This course trains professionals to administer scalable SQL-based databases in both IaaS (Azure VMs) and PaaS (Azure SQL Database/Managed Instance) environments. It covers critical administration topics, including security implementation with Microsoft Defender, performance optimization using Intelligent Query Processing (IQP), High Availability and Disaster Recovery (HA/DR) planning with AG and WSFC, and automation using PowerShell and Azure CLI. This course is ideal for those preparing for the Administering Microsoft Azure SQL Solutions Exam (DP-300). Applied Technology Academy is an award-winning, SBA-certified woman-owned training provider (est. 2008) whose instructors are active practitioners; the course is hands-on with virtual labs and a learn-by-doing methodology.
Course Objectives
Once I've completed the course, I'll have hands-on, job-ready skills in data analytics & databases that I can apply immediately to our work.
Expected Organizational Benefits
After completing this course, I will be better equipped to apply these skills directly to our projects, reduce our reliance on outside expertise, strengthen our team's capabilities, and share what I learn with colleagues.
Expected Cost & Funding
Course fee: [request an itemized quote at the link below]. Applied Technology Academy supports multiple funding paths that may reduce or cover this cost: GSA MAS purchasing and government purchase orders, military credentialing funding (Army CA, AF COOL, CG COOL), VA GI Bill and VR&E, ATA Flexible Spending, and student financing. Private team cohorts are available if colleagues should attend with me.
Conclusion
This training provides practical, hands-on experience I can apply immediately to strengthen our work in data analytics & databases. Additional course information is available at https://appliedtechnologyacademy.com/microsoft-training/microsoft-azure-sql-solutions-training/.
Thank you for your consideration,
[Your Name]
Design training around your team, not the other way around.
Talk to a training advisor about private cohorts, funding paths and program management.