- • Jul 21–24, 2026 · Live Remote Online, 9:00 AM–5:00 PM ET
- • Sep 15–18, 2026 · Live Remote Online, 9:00 AM–5:00 PM ET
- • Nov 17–20, 2026 · Live Remote Online, 9:00 AM–5:00 PM ET
Administering Relational Databases on Microsoft Azure (DP-300T00)
Course Duration
4 Days
Audience
Employees of federal, state and local governments; and businesses working with the government.
Prerequisites
Experience administering SQL Server or Azure SQL databases. Familiarity with Azure services including compute, storage, and networking. Basic knowledge of T-SQL querying.
Course Description
This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.
Learning Objectives
- The available HADR options for both IaaS and PaaS
- The considerations for planning and configuring HADR solutions including how backup and restore fit into an overall HADR strategy
- The factors that comprise a HADR strategy
- How to configure a high availability solution via a hands-on lab
Course Outline
Module 1: The Role of the Azure Database Administrator
Lessons
- Azure Data Platform Roles
- Azure Database Platforms and Options
- SQL Server Compatibility Levels
- Azure Preview Features
- Understand the role of Azure Database Administrator as it fits in with other data platform roles
- Be able to describe the key differences between the SQL Server-based database op
- Be able to describe the difference between versions and compatibility levels
- Know how to enable and disable preview features
Module 2: Plan and Implement Data Platform Resources
Lessons
- Deploying SQL Server using IaaS
- Deploying SQL Server using PaaS
- Deploying Open Source Database Solutions on Azure
- Deploy resources using manual methods
- Recommend an appropriate database offering based on requirements
- Configure database resources
- Evaluate and implement a strategy for moving a database to Azure
Module 3: Implement a Secure Environment
Lessons
- Configure Database Authentication
- Configure Database Authorization
- Implement Security for Data at Rest
- Implement Security for Data in Transit
- Implement Compliance Controls for Sensitive Data
- Understand the differences between Windows, SQL Server and Azure Active Directory Authentication
- Describe and configure both data-at-rest encryption solutions as well as data-in-transit encryption
- Implement a data sensitivity solution
Module 4: Monitor and Optimize Operational Resources
Lessons
- Baselines and Performance Monitoring
- Major Causes of Performance Issues
- Configuring Resources for Optimal Performance
- User Database Configuration
- Performance-related Maintenance Tasks
- Monitor activity and compare to a baseline
- Define maintenance tasks related to performance
- Identify major causes of performance problems
- Configure resources for optimal performance
- Configure a user database for optimal performance
Module 5: Optimize Query Performance
Lessons
- Understanding SQL Server Query Plans
- Explore Performance-based Database Design
- Evaluate Performance Improvements
- Analyze query plans and identify problem areas
- Evaluate potential query improvements
- Review table and index design
- Determine whether query or design changes have had a positive effect
Module 6: Automation of Tasks
Lessons
- Setting up Automatic Deployment
- Defining Scheduled Tasks
- Configuring Extended Events
- Managing Azure PaaS resources Using Automated Methods
- Deploy resources using automated deployment scripts
- Create scheduled tasks
- Create notifications and alerts
- Configure automation for PaaS services
Module 7: Plan and Implement a High Availability and Disaster Recovery Environment
Lessons
- High Availability and Disaster Recovery Strategies
- IaaS Platform and Database Tools for HADR
- PaaS Platform and Database Tools for HADR
- Database Backup and Recovery
- The difference between recovery time and recovery point objectives
- The available HADR options for both IaaS and PaaS
- The considerations for planning and configuring HADR solutions including how backup and restore fit into an overall HADR strategy
- The factors that comprise a HADR strategy
- How to configure a high availability solution via a hands-on lab
Frequently Asked Questions
What does the Administering Relational Databases on Microsoft Azure (DP-300T00) course cover?
This course covers Administering Relational Databases on Microsoft Azure (DP-300T00) training and best practices. IT Dojo delivers it as live instructor-led training with an emphasis on practical skills for government and DoD professionals.
How long is IT Dojo's Administering Relational Databases on Microsoft Azure (DP-300T00) training?
IT Dojo's Administering Relational Databases on Microsoft Azure (DP-300T00) training is 4 Days. It is available as live remote online instruction or on-site at your facility. All sessions are instructor-led with small class sizes to ensure individual attention.
Is this course available as live remote online training?
Yes. IT Dojo offers Administering Relational Databases on Microsoft Azure (DP-300T00) as live remote online training. A certified instructor leads the session in real time. Students interact via chat or microphone. Classes are kept small (typically no more than 16 students) to ensure engagement. On-site delivery at your government facility or contractor location is also available.
What prerequisites are recommended before this course?
Experience administering SQL Server or Azure SQL databases. Familiarity with Azure services including compute, storage, and networking. Basic knowledge of T-SQL querying.
Does IT Dojo offer this training on-site at government or DoD facilities?
Yes. IT Dojo delivers Administering Relational Databases on Microsoft Azure (DP-300T00) on-site at government agencies, DoD commands, military installations, and contractor facilities. On-site training is ideal for teams of four or more and can be customized to your organization's specific environment and mission requirements. Contact IT Dojo to schedule.
How do I register for this course?
IT Dojo training is employer sponsored. Your organization registers and pays for seats. To schedule Administering Relational Databases on Microsoft Azure (DP-300T00) for your team, contact IT Dojo via the Request Training form or call 757-216-3656. IT Dojo will work with your contracting officer, training coordinator, or program office to set up the course.