Course Information
Course Overview
Learn Azure Database Administration, and get certified, with this complete beginner's DP-300 course!
Candidates for this exam are database administrators and data management specialists that manage on-premises and cloud relational databases built with Microsoft SQL Server and Microsoft Azure Data Services.
The content of this exam will be updated on December 2, 2022.
Plan and implement data platform resources (20–25%)
Implement a secure environment (15–20%)
Monitor, configure, and optimize database resources (20–25%)
Configure and manage automation of tasks (15–20%)
Plan and configure a high availability and disaster recovery (HA/DR) environment (20–25%)
The Azure Database Administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built on Azure Data Services and SQL Server. The Azure Database Administrator uses a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes.
This role is responsible for management, availability, security and performance monitoring and optimization of modern relational database solutions. This role works with the Azure Data Engineer role to manage operational aspects of data platform solutions.
Candidates for this role should understand all concepts covered in Exam DP-900: Microsoft Azure Data Fundamentals.
This exam measures your ability to accomplish the following technical tasks: plan and implement data platform resources; implement a secure environment; monitor and optimize operational resources; optimize query performance; perform automation of tasks; plan and implement a High Availability and Disaster Recovery (HADR) environment; and perform administration by using T-SQL.
Course Content
- 10 section(s)
- 76 lecture(s)
- Section 1 DP-300 Azure Relational DBA Exam
- Section 2 Practice Test and Study guide
- Section 3 Deploy Azure SQL Resources
- Section 4 Recommend a Database Based on Requirements
- Section 5 Configure resources for scale and performance
- Section 6 Evaluate a strategy for moving to Azure
- Section 7 Implement a migration or upgrade strategy for moving to Azure
- Section 8 Configure database authentication
- Section 9 Implement security for data at rest
- Section 10 Implement security for data in transit
What You’ll Learn
- Pass the Microsoft DP-300 Azure Database Administration test
- Earn the Microsoft Certified Azure Database Administrator Associate
- Understand what services and solutions Azure offers
- Includes Oct 2022 changes! Up-to-date as of Dec 2022.
Skills covered in this course
Reviews
-
JJabulani Mdluli
More explaination of SQL Server needed and Azure fundamentals or specify on course that they are requirements
-
AAshish .
Good
-
SShane Cook
Less of an exam prep, and more like a high level overview of features.
-
RRISHABH SINGH PATEL
excellent