DP-300: Azure Relational Database Administrator Exam Prep

DP-300: Azure Relational Database Administrator Exam Prep, available at $84.99, has an average rating of 4.42, with 76 lectures, 1 quizzes, based on 751 reviews, and has 5332 subscribers.

You will learn about 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. This course is ideal for individuals who are Candidates with non-technical backgrounds who are interested in learning about the cloud or Candidates with technical backgrounds who are interested in getting more advanced certs in the future It is particularly useful for Candidates with non-technical backgrounds who are interested in learning about the cloud or Candidates with technical backgrounds who are interested in getting more advanced certs in the future.

Enroll now: DP-300: Azure Relational Database Administrator Exam Prep

Summary

Title: DP-300: Azure Relational Database Administrator Exam Prep

Price: $84.99

Average Rating: 4.42

Number of Lectures: 76

Number of Quizzes: 1

Number of Published Lectures: 76

Number of Published Quizzes: 1

Number of Curriculum Items: 77

Number of Published Curriculum Objects: 77

Number of Practice Tests: 1

Number of Published Practice Tests: 1

Original Price: $69.99

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

Candidates with non-technical backgrounds who are interested in learning about the cloud
Candidates with technical backgrounds who are interested in getting more advanced certs in the future

Target Audiences

Candidates with non-technical backgrounds who are interested in learning about the cloud
Candidates with technical backgrounds who are interested in getting more advanced certs in the future

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 Curriculum

Chapter 1: DP-300 Azure Relational DBA Exam

Lecture 1: Welcome to the Course

Lecture 2: Exam Requirements

Lecture 3: Udemy Player Tips

Lecture 4: Azure Free Account

Chapter 2: Practice Test and Study guide

Lecture 1: Course Official Study Guide

Chapter 3: Deploy Azure SQL Resources

Lecture 1: Azure Relational Databases Covered by the Exam

Lecture 2: Overview of the SQL Database Options

Lecture 3: Creating an Azure VM and Installing SQL Server

Lecture 4: Connect the the Database Through Port 1433

Lecture 5: Deploying SQL Server from the Azure Marketplace

Lecture 6: Setting a Maintenance Window

Lecture 7: Install Azure SQL Database

Lecture 8: Using Sample Database

Lecture 9: Install Azure SQL Managed Instance

Lecture 10: HAND-ON LABS: Deploy Azure SQL Resources

Chapter 4: Recommend a Database Based on Requirements

Lecture 1: How to Choose an Azure Relational Database

Lecture 2: Evaluate Functional Requirements

Lecture 3: Evaluate Scaling Requirements

Lecture 4: Availability and Backup Requirements

Lecture 5: Security Requirements

Chapter 5: Configure resources for scale and performance

Lecture 1: Scaling Azure SQL Database

Lecture 2: Using Elastic Pool Database to Scale

Lecture 3: Scaling SQL VM

Lecture 4: Using SQL DB Replicas and Sharding

Lecture 5: SQL Data Sync

Chapter 6: Evaluate a strategy for moving to Azure

Lecture 1: Prepare a Migration Strategy

Lecture 2: Prepare an Upgrade Strategy

Chapter 7: Implement a migration or upgrade strategy for moving to Azure

Lecture 1: Run a Migration Assessment

Lecture 2: Perform a Database Migration

Lecture 3: Upgrade a Database

Chapter 8: Configure database authentication

Lecture 1: Overview of Exam Requirements for Security

Lecture 2: Creating an Azure AD Admin User

Lecture 3: Using Azure AD for Regular User Permissions

Lecture 4: HANDS-ON LABS: Configure database authentication

Chapter 9: Implement security for data at rest

Lecture 1: Transparent Data Encryption (TDE)

Lecture 2: Database Column Encryption

Lecture 3: Dynamic Data Masking

Lecture 4: Azure Key Vault for Encryption

Lecture 5: VM Disk Encryption for SQL Server

Chapter 10: Implement security for data in transit

Lecture 1: SQL Database Firewalls and Virtual Network Access

Chapter 11: Implement compliance controls for sensitive data

Lecture 1: Data Classification & Labeling

Lecture 2: SQL Auditing

Lecture 3: Track Changes

Lecture 4: Vulnerability Assessment

Chapter 12: Monitor activity and performance

Lecture 1: Create a Performance Baseline

Lecture 2: Using Azure Monitor for Performance

Lecture 3: Configuring Azure Alerts for SQL Database

Lecture 4: Extracting More Performance Data with Diagnostics and Log Analytics

Chapter 13: Implement performance-related maintenance tasks

Lecture 1: Implementing Automatic Tuning

Lecture 2: Creating a New Elastic Job Database for Automation

Lecture 3: Creating and Executing an Elastic Job

Lecture 4: HANDS-ON LABS: Implement performance-related maintenance tasks

Chapter 14: Identify performance-related issues

Lecture 1: Configure Query Store to collect performance data

Chapter 15: Configure resources for optimal performance

Lecture 1: Configure Azure Resources

Chapter 16: Configure a user database for optimal performance

Lecture 1: Database-Scoped Configuration

Lecture 2: Intelligent Query Processing (IQP)

Chapter 17: Review query plans

Lecture 1: Show the Estimated Query Plan

Lecture 2: Add a New Index

Lecture 3: Dynamic Management Views (DMV)

Lecture 4: Using Query Hints

Lecture 5: HANDS-ON LABS: Review query plans

Chapter 18: Create scheduled tasks

Lecture 1: Create scheduled tasks

Lecture 2: Create notifications and alerts

Chapter 19: Manage and automate tasks in Azure

Lecture 1: Deploy Resources using ARM Templates

Lecture 2: Deploy Resources using Azure Bicep

Lecture 3: HANDS-ON LABS: Automate resources

Chapter 20: High Availability and Disaster Recovery (HADR)

Lecture 1: Overview of HADR

Lecture 2: Backup Azure SQL Database

Lecture 3: Restore Azure SQL Database

Lecture 4: Implement Database Replication

Lecture 5: Implement Failover Groups

Lecture 6: Windows Clusters and Availability Groups

Lecture 7: HANDS-ON LABS: High Availability and Disaster Recovery

Chapter 21: T-SQL and DMVs

Lecture 1: Perform Administration by Using T-SQL

Chapter 22: Wrap Up

Lecture 1: Course Slides

Lecture 2: Bonus Lecture

Instructors

Scott Duffy • 1.000.000+ Students
Bestselling Azure & TOGAF® Trainer, Microsoft Azure MVP
Software Architect
Training for enterprise architects

Rating Distribution

1 stars: 10 votes
2 stars: 20 votes
3 stars: 78 votes
4 stars: 267 votes
5 stars: 376 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu