Skip to content
learning path

DP-300 Exam Prep: Administering Relational Databases on Microsoft Azure

Intermediate
Up to 12h 24m
2,973
4.3/5
Enroll
Enhance your skill setDevelop essential skills for thriving in real-world scenarios.
Stay focused, stay committedBoost your learning journey by enrolling: stay focused, consistent and achieve your goals with ease.
Earn a certificate of completionShow your skills and build your credibility when you include them in your resume and LinkedIn profile.

Training content

10
3
1
COURSE
Beginner
Duration: 3 minutes and 19 seconds
DP-300 Exam Preparation: Introduction
This lesson introduces the DP-300 Exam Preparation course, which explores the main subject areas covered in Microsoft's DP-300 exam.
COURSE
Intermediate
Duration: 1 hour and 19 minutes
Implementing Azure SQL Databases
This lesson explores how to plan and implement data platform resources specifically with regards to Azure SQL offerings.
COURSE
Intermediate
Duration: 59 minutes and 43 seconds
Azure SQL and SQL Server Database Monitoring
This lesson introduces you to the different database monitoring and notification technologies available, how they work, and how to use them.
COURSE
Intermediate
Duration: 1 hour and 1 minute
Azure SQL and SQL Server Database Task Automation
This lesson looks at the options available to you in these various environments for automating maintenance and regularly repeated tasks.
COURSE
Intermediate
Duration: 37 minutes and 14 seconds
Azure Database Performance Tuning
This lesson focuses on maximizing the performance of hardware and infrastructure relating to database servers.
COURSE
Intermediate
Duration: 1 hour and 26 minutes
Azure SQL and SQL Server Query Performance Tuning
This lesson explores how you can improve database query performance using SQL Server.
HANDS-ON LAB
Beginner
Duration: Up to 45 minutes
Optimizing Azure SQL Databases
Learn how to optimize the Azure SQL service by configuring logging and alerting and scaling the database.
See all

 This Course is designed to help you prepare for the DP-300 Administering Relational Databases on Microsoft Azure exam. Even if you don't plan to take the exam, these courses and hands-on labs will help you get started on your way to becoming an Azure SQL database specialist.    

 The DP-300 exam is part of Microsoft’s new role-based certification program and is required to gain the Azure Database Administrator Associate certification. Candidates who already possess either the MCSA: SQL Server 2012/2014, MCSA SQL 2016 Database Development or MCSA: SQL 2016 Database Administration certification will find DP-300 builds on your database knowledge and will certify you to administer Azure hosted SQL databases.  

Learning Objectives

  • Understand the differences between Azure SQL offerings and how best to leverage their features 
  • Implement a secure database environment 
  • Monitor database and server performance 
  • Optimize database and server performance 
  • Automate database tasks 
  • Implement high availability and disaster recovery  
  •  Use T-SQL to perform database administration tasks  

Intended Audience

  • People who want to become an Azure SQL Database administrator 
  • People preparing for Microsoft’s DP-300 exam   

Prerequisites

  •  General knowledge of Relational Database concepts
  • Familiarity with Azure Data Fundamentals (DP-900)  
Your certificate for this learning path

About the Author

Avatar
Hallam Webber, opens in a new tab
Software Architect
Students
27,379
Courses
85
Learning paths
17

Hallam is a software architect with over 20 years experience across a wide range of industries. He began his software career as a  Delphi/Interbase disciple but changed his allegiance to Microsoft with its deep and broad ecosystem. While Hallam has designed and crafted custom software utilizing web, mobile and desktop technologies, good quality reliable data is the key to a successful solution. The challenge of quickly turning data into useful information for digestion by humans and machines has led Hallam to specialize in database design and process automation. Showing customers how leverage new technology to change and improve their business processes is one of the key drivers keeping Hallam coming back to the keyboard. 

Covered Topics

SQL
Databases
Microsoft Azure
Databases for Azure