DP-300: Administering Microsoft Azure SQL Solutions Course Overview
DURATION: 4 DAYS
DP-300: Administering Microsoft Azure SQL Solutions training introduces database administrators to managing cloud and hybrid database environments using Microsoft Azure SQL services and SQL Server. The course covers deployment, security, performance optimization, automation, migration, and high availability and disaster recovery (HA/DR).
Course Objectives
This course is designed to develop practical knowledge of administering database solutions across Azure SQL and SQL Server environments.
By the end of this course, participants should have a better understanding of how to:
- Plan, deploy, and migrate Azure SQL solutions
- Configure database authentication, authorization, and security
- Monitor and optimize database performance
- Automate database deployments and administrative tasks
- Configure backup, high availability, and disaster recovery solutions
Who Should Attend?
- Database Administrators
- Azure Database Administrators
- SQL Server Administrators
- Data Professionals
Course Prerequisites
Experience working with relational databases and SQL Server is recommended. Familiarity with Microsoft Azure, T-SQL, database administration, and cloud computing concepts may be helpful.
What’s included?
- Authorized Courseware
- Intensive Hands on Skills Development with an Experienced Subject Matter Expert
- Hands-on practice on real Servers and extended lab support 1.800.482.3172
- Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
- Academy Code of Honor: Test Pass Guarantee
- Optional: Package for Hotel Accommodations, Lunch and Transportation
With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.
Methods
- Instructor-Led (the best training format we offer)
- Live Online Classroom – Online Instructor-Led
- Self-Paced Video
Speak to an Admissions Representative for complete details
| Start | Finish | Public Price | Public Enroll | Private Price | Private Enroll |
|---|---|---|---|---|---|
| 12/8/2025 | 12/11/2025 | ||||
| 12/29/2025 | 1/1/2026 | ||||
| 1/19/2026 | 1/22/2026 | ||||
| 2/9/2026 | 2/12/2026 | ||||
| 3/2/2026 | 3/5/2026 | ||||
| 3/23/2026 | 3/26/2026 | ||||
| 4/13/2026 | 4/16/2026 | ||||
| 5/4/2026 | 5/7/2026 | ||||
| 5/25/2026 | 5/28/2026 | ||||
| 6/15/2026 | 6/18/2026 | ||||
| 7/6/2026 | 7/9/2026 | ||||
| 7/27/2026 | 7/30/2026 | ||||
| 8/17/2026 | 8/20/2026 | ||||
| 9/7/2026 | 9/10/2026 | ||||
| 9/28/2026 | 10/1/2026 | ||||
| 10/19/2026 | 10/22/2026 | ||||
| 11/9/2026 | 11/12/2026 | ||||
| 11/30/2026 | 12/3/2026 | ||||
| 12/21/2026 | 12/24/2026 | ||||
| 1/11/2027 | 1/14/2027 |
Course Curriculum
1 – Plan and Implement Data Platform Resources
- Azure SQL and SQL Server solutions
- Scaling and performance configuration
- Database migration strategies
- Hybrid SQL environments
2 – Implement a Secure Environment
- Microsoft Entra ID authentication and authorization
- Database permissions and access
- Encryption and network security
- Data protection and compliance controls
3 – Monitor and Optimize Database Resources
- Database performance monitoring
- Query Store and execution plans
- Index and query optimization
- Database performance and maintenance
4 – Automate Database Tasks
- SQL Server Agent jobs
- ARM and Bicep templates
- Azure PowerShell and Azure CLI
- Elastic jobs and database automation
5 – Configure High Availability and Disaster Recovery
- HA/DR planning and RPO/RTO
- Database backup and restore
- Geo-replication and failover groups
- Always On availability solutions
