DP-300 Azure Database Administrator Training
A practical, instructor-led training program for professionals who want to administer, secure, monitor, optimize, and automate SQL Server and Azure SQL database environments.
Course Overview
This course focuses on the skills required to manage modern database platforms using Microsoft SQL Server and Azure SQL services. Participants learn how to provision database resources, configure security, monitor performance, implement high availability, manage backups, and troubleshoot operational issues.
The training combines live demonstrations, guided labs, real-world administration scenarios, and best practices for production database environments. It is suitable for professionals preparing for the DP-300 certification exam as well as database and infrastructure teams responsible for SQL workloads.
What You Will Learn
- Administer SQL Server, Azure SQL Database, and Azure SQL Managed Instance environments
- Provision and configure Azure SQL resources
- Implement authentication, authorization, encryption, and access control
- Monitor database performance and troubleshoot common issues
- Optimize queries, indexes, statistics, and execution plans
- Configure backup, restore, high availability, and disaster recovery strategies
- Automate administrative tasks and apply operational best practices
- Prepare for Microsoft DP-300 certification topics through practical examples
Target Audience
- Database administrators
- SQL Server professionals
- Azure SQL administrators
- Cloud database engineers
- Infrastructure and operations teams
- Developers responsible for database performance and reliability
Prerequisites
- Basic experience with SQL Server or relational databases
- Understanding of T-SQL fundamentals is recommended
- General knowledge of Azure concepts is helpful
- Experience with backup, security, or performance topics is beneficial but not required
Detailed Syllabus
- Overview of SQL Server, Azure SQL Database, and Azure SQL Managed Instance
- Provisioning and configuring Azure SQL resources
- Database connectivity, networking, firewall rules, and private access concepts
- Authentication with Microsoft Entra ID and SQL authentication
- Authorization, roles, permissions, users, and least privilege access
- Data protection, encryption, auditing, and compliance features
- Backup and restore strategies for SQL Server and Azure SQL
- High availability and disaster recovery options
- Monitoring database health, metrics, alerts, and logs
- Query Store, execution plans, waits, and performance troubleshooting
- Indexing strategies, statistics, fragmentation, and maintenance concepts
- Resource governance, scaling, purchasing models, and cost-awareness
- Automation with scripts, jobs, alerts, and administrative workflows
- Security and performance best practices for production database environments
- End-to-end administration scenario: secure, monitor, optimize, and recover a database workload
Schedule
Next public session: July 8-11, 2026
Time: 09:00 AM - 05:00 PM Eastern Time
Format: Live online instructor-led training
Corporate and private group sessions can also be scheduled upon request.
Delivery and Materials
The course is delivered live online. Access details, meeting links, preparation instructions, and any required materials are sent by email after successful registration and payment.
Course content is provided for registered participants only. Unauthorized recording, redistribution, or sharing of training sessions or materials is not permitted.