EDUCBA

Home New Trending Courses DP 300 Azure Relational DBA

DP 300 Azure Relational DBA

Learn DBA skills for Azure SQL Databases, SQL Managed Instances and SQL Server on Azure Virtual Machines. Exam DP-300

MOST POPULAR
4.4 (5,756 ratings)

* One Time Payment & Get One year access

Offer ends in:

What you'll get

  • 3+ Hours
  • 1 Courses
  • Course Completion Certificates
  • One year access
  • Self-paced Courses
  • Technical Support
  • Mobile App Access
  • Case Studies

Synopsis

  • 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
  • Perform administration by using T-SQL

Content

Description

About DP-300 Azure Relational DBA

This course teaches the requirements for the Microsoft Certificate DP-300 "Administering Relational Databases on Microsoft Azure", and focuses on administrating Azure SQL Databases, Azure SQL Managed Instances, and SQL Server on Azure Virtual Machines. We concentrate for most of the course on Azure SQL Databases, and then look at the additional functionality for Managed Instances and SQL Server on Azure Virtual Machines.

 

We’ll Evaluate and implement an alert and notification strategy, Identify performance-related issues using tools we couldn’t use in Azure SQL Database, and Create scheduled tasks. Finally, we’ll Perform backup and restore a database in Virtual Machines by using database tools, and Recommend, test and configure High Availability and Disaster Recovery strategies.

Some prior knowledge is required, but not much. You’ll need to know how to use the Select statement; and it would be helpful, but not essential, if you had a little background in Microsoft Azure.

Some prior knowledge of SQL Server is required. Specifically, you need to know:

  • How to create a SELECT statement,

  • How to create views and stored procedures,

  • How to create backups and restore a database.

Additionally, prior knowledge of Azure, such as that shown in Microsoft's DP-900 exam is helpful, but is not required.

Once you have completed this course, you will have a good knowledge of how to administer Azure SQL Databases, Azure SQL Managed Instances, and SQL Server on Azure Virtual Machines. And with some practice, you could even go for the official Microsoft certification DP-300 - wouldn't that look good on your CV or resume?

Requirements

  • Excitement to learn Microsoft's constantly growing cloud platform
  • No Azure account or subscription required

Target Audience

  • This course is for you if you want to implement or manage the operational aspects of cloud-native and hybrid data platform solutions built on Azure Data Services and SQL Server
  • You could be a database administrator or data management specialist that manage on-premises and cloud relational databases built with Microsoft SQL Server and Microsoft Azure Data Services
  • By the end of this course, after entering the official Practice Tests, you could enter (and hopefully pass) Microsoft's official DP-300 exam.
  • Wouldn't the "Microsoft Certified: Azure Database Administrator Associate" certification look good on your CV or resume?

* One Time Payment & Get One year access

Offer ends in:

Training 5 or more people?

Get your team access to 5,000+ top courses, learning paths, mock tests anytime, anywhere.

Drop an email at: [email protected]