Microsoft Certified: Azure Database Administrator Associate (DP-300)

At Firebrand, we were awarded the Microsoft Solutions Partner for Data & AI (Azure) badge in recognition of our expertise in delivering quality solutions in this specialised business area.

On this Microsoft Certified: Azure Database Administrator Associate course, you’ll learn how to apply, utilise and manage the operational elements of cloud-native and hybrid data platform solutions built on Microsoft Azure data services and Microsoft SQL Server.

With Firebrand, you'll build knowledge on a broad range of methods and tools, such as:

• Applying T-SQL for administrative management purposes
• Managing security and performance, and optimising modern relational database solutions
• Learning to work with the Azure Data Engineer to manage operational aspects of data platform solutions

At Firebrand, we are one of the few companies in the world to be designated a Microsoft Cloud Partner. By studying with us, you'll gain access to the latest Microsoft curriculum, learn from Microsoft Certified Trainers, and take the official DP-300 exam at the Firebrand Training Centre after your course, covered by our Certification Guarantee.

Audience

If you're a database administrator or a data management specialist that manages on-premises and cloud relational databases built on top of Microsoft SQL Server and Microsoft Azure data services, this course is ideal for you.

Course DP-300T00-A: Administering Relational Databases on Microsoft Azure

• Module 1: The Role of the Azure Database Administrator
• Lab: Using the Azure Portal and SQL Server Management Studio

• Module 2: Plan and Implement Data Platform Resources
• Lab: Deploying Azure SQL Database

• Module 3: Implement a Secure Environment
• Lab: Implement a Secure Environment

• Module 4: Monitor and Optimise Operational Resources
• Lab: Monitor and Optimise Resources

• Module 5: Optimise Query Performance
• Lab: Query Performance Troubleshooting

• Module 6: Automation of Tasks
• Lab: Automating Tasks

• Module 7: Plan and Implement a High Availability and Disaster Recovery Environment
• Lab: Plan and Implement a High Availability and Disaster Recovery Environment

As part of your course, you’ll sit the following exam at the Firebrand Training Centre, covered by our Certification Guarantee:

Exam DP-300: Administering Relational Databases on Microsoft Azure

• Exam code: DP-300
• Domains:
1. Plan and implement data platform resources (15-20%)
2. Implement a secure environment (15-20%)
3. Monitor and optimize operational resources (15-20%)
4. Optimize query performance (5-10%)
5. Perform automation of tasks (10-15%)
6. Plan and implement a High Availability and Disaster Recovery (HADR) environment (15-20%)
7. Perform administration by using T-SQL (10-15%)

Before attending this course, you should have technical knowledge equivalent to either of the following courses:

• Microsoft Certified: Azure Fundamentals
• Microsoft Certified: Azure Data Fundamentals

Your course includes:

• Accommodation *
• Meals, unlimited snacks, beverages, tea and coffee *
• On-site exams **
• Exam vouchers **
• Practice tests **
• Certification Guarantee ***
• Courseware
• Up to 12 hours of instructor-led training each day
• 24-hour lab access
• Digital courseware **

* For residential training only. Accommodation is included from the night before the course starts. This doesn't apply to online courses.
** Some exceptions apply. Please refer to the Exam Track or speak with our experts.
*** Pass the first time or train again for free as many times as it takes, unlimited for 1 year. Just pay for accommodation, exams, and incidental costs.

Six reasons to sit your course with Firebrand Training

• Three training options. Choose between residential classroom-based, live online, or city-centre courses
• All-inclusive course. A one-off fee covers all course materials, exams**, accommodation* and meals*. No hidden extras.
• Pass the first time or train again for free. This is our guarantee. We’re confident you’ll pass your course the first time. But if not, come back within a year and only pay for accommodation, exams and incidental costs
• You’ll learn more. Our expert instructors cover exclusive additional materials not taught through the official curriculum
• You’ll learn faster. Chances are, you’ll have a different learning style compared to those around you. We combine visual, auditory and tactile styles to deliver the material in a way that ensures you will learn faster and more easily
• You’ll be studying with the best. We’ve been named in the Training Industry’s “Top 20 IT Training Companies of the Year” every year since 2010. As well as winning many more awards, we’ve trained and certified over 145,000 professionals

*For residential training only. Doesn't apply to online courses
**Some exceptions apply. Please refer to the Exam Track or speak with our experts

Are you ready for the course? 

Get access to free practice tests here:  Free Practice Test