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

DifficultyIntermediate
AVG Duration11h
Students2083
Ratings
4.2/5
starstarstarstarstar-half
Content
1013

Description

 This Learning Path 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)  

Certificate

Your certificate for this learning path

Training Content

1
Course - Beginner - 3m
DP-300 Exam Preparation: Introduction
This course introduces the DP-300 Exam Preparation learning path, which explores the main subject areas covered in Microsoft's DP-300 exam.
2
Course - Intermediate - 1h 19m
Implementing Azure SQL Databases
This course explores how to plan and implement data platform resources specifically with regards to Azure SQL offerings.
3
Course - Intermediate - 1h
Azure SQL and SQL Server Database Monitoring
This course introduces you to the different database monitoring and notification technologies available, how they work, and how to use them.
4
Course - Intermediate - 1h 1m
Azure SQL and SQL Server Database Task Automation
This course looks at the options available to you in these various environments for automating maintenance and regularly repeated tasks.
5
Course - Intermediate - 37m
Azure Database Performance Tuning
This course focuses on maximizing the performance of hardware and infrastructure relating to database servers.
6
Course - Intermediate - 1h 26m
Azure SQL and SQL Server Query Performance Tuning
This course explores how you can improve database query performance using SQL Server.
7
Hands-on Lab - Beginner - 45m
Optimizing Azure SQL Databases
Learn how to optimize the Azure SQL service by configuring logging and alerting and scaling the database.
8
Course - Advanced - 1h 6m
Implementing High Availability and Disaster Recovery for Azure SQL Databases
This course examines the features that Azure provides to help you make sure your SQL databases are not the point of failure in your systems.
9
Course - Intermediate - 48m
Implementing Azure SQL Data Security
This course explores the protections available for your Azure SQL databases but also how to implement them.
10
Course - Intermediate - 44m
Azure Database Authentication and Access
This course looks at various ways to integrate Azure SQL with Azure Active Directory and how to best manage user privileges once logged into the database.
11
Hands-on Lab - Beginner - 45m
Getting Started with Azure SQL Database
Explore the main features of Azure SQL and learn how to deploy and manage the service by connecting to the database and assigning user access in this lab.
12
Hands-on Lab - Advanced - 1h
Enabling Microsoft Defender for Azure SQL Database
Demonstrate the three capabilities of Azure Defender (AD): data discovery & classification, vulnerability assessment, and advanced threat protection to see how AD provides security as a service for your Azure SQL Databases.
13
Course - Intermediate - 49m
Azure SQL - Designing and Implementing a Migration Plan
This course looks at strategies and tools to achieve an optimal migration from an on-premise database to an Azure SQL database.
14
Exam - 2h 30m
Cert Prep: Administering Relational Databases on Microsoft Azure (DP-300)
Cert Prep: Administering Relational Databases on Microsoft Azure (DP-300)
About the Author
Students17729
Courses62
Learning paths12

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.