DP-300 prep: Azure Database Administrator Associate (DBA)

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

  • 0.0 (0 Reviews)
  • 0 Students
  • 193 Lessons
  • Phillip Burton - over one million students so far

Course Overview

This course covers the content required for the DP-300 certification exam, current as per the DP-300 exam updates of 24 April and 27 October 2026.

Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.


What do people like you say about this course?

Erik says: "Phillip has done an amazing job with this course, it covers all of the skills required to pass DP-300 exam and a little more. I had some difficulties with some of the topics of the exam and this whole course and videos made a lot of them more clear. The course is a must for people looking to pass the exam, the test exams reinforce the knowledge gained but of course do not include actual exam questions."

Steven says: "Great course at showing the content tested in the DP-300 course. The practice tests and quizzes were not at all similar to the actual DP-300 exam, but through taking this course (and applying the knowledge gained) I was able to get my certification on the first try."

Pardeep says: "Must say i didn't expect to to provide such thorough Azure flavor from DBA standpoint

most of the courses on Udemy do have azure courses but they are from system admin standpoint(with dba portion added here n there)

this course is nicely crafted and most of nuances are explained clearly

also, there's a pdf in resources which has the notes & its something to hold on to for quick reference for future.

Thank you much for the course!!!"


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.

In the first part of this course we will be concentrating on the Azure SQL Database. We'll start off with getting a free trial of Azure, installing SQL Server Management Studio, and briefly reviewing the 6 principal clauses of the SELECT statement. We will then look at how to optimize query performance and evaluate performance improvements.

We will then look at the various Data Platform Resources and how they compare. Following this, we will have a deep dive into configuring Azure SQL Database resources for scale and performance, including serverless and provisioned, vCore and DTU, and database partitioning techniques. We will then evaluate strategies for migrating to Azure.

Then we look at how to implement a secure environment for your Azure SQL Database. We will look at how to configure database authentication and authorization by using platform and database tools; how to Implement security for data at rest and in transit; and how to implement compliance controls for sensitive data.

After this, we will look at how Monitor and Optimize Operational Resources. This includes Monitoring activity and performance, implementing performance-related maintenance tasks, and identifying performance-related issues.

Lastly for Azure SQL Database, we will look at how to Automate tasks and Perform backup and restore a database by using database tools, Recommend an HADR strategy for a data platform solution, and more about Performing Administration by Using T-SQL.

In the second part of the course, we will turn to Virtual Machines and Managed Instances and those features which are not available in Azure SQL Database. We will start by configuring them and access them, either in SSMS or using a Remote Desktop Connection. Then we’ll look at strategies for configuring database authentication, and filegroups.

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.

This content is available in "98-364: Database Fundamentals", which is published on Udemy.

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? And if you are an American college student, you might even get college credit for passing that exam.

I hope to see you in the course - why not have a look at what you could learn?

See more

FAQ

FAQ area empty

Course curriculum

27 chương 193 bài học 17 giờ 20 phút 7 bài học thử miễn phí
Chương 1 Introduction
Chương 2 Review prerequisites
  • Getting a free trial of Microsoft Azure 6:06
  • Creating Azure SQL Database with sample data 11:49
  • Installing SSMS, connecting to Azure SQL Database, and quick look around SSMS 11:06
  • Review 6 principal clauses of the SELECT statement 6:15
  • Review JOINs 3:50
Chương 3 Optimize Query Performance
  • 57. determine the appropriate type of execution plan 5:41
  • 57. Different types of loops used in execution plans, and Scan and Seek 6:11
  • 57. identify problem areas in execution plans 7:28
  • Optimize Query Performance Học thử
Chương 4 Evaluate performance improvements
Chương 5 Plan and Implement Data Platform Resources
  • 1. deploy database offerings on selected platforms 4:17
  • 2. configure customized deployment templates 8:09
  • 5. evaluate requirements and functional benefits/impact for the deployment 7:37
  • 5, 6 (5). evaluate scalability and security aspects 4:44
  • 5. HA/DR of the possible database offerings 8:07
  • 70, 73. Automate deployment by using Azure Resource Manager (ARM) templates 10:32
  • 70, 73. Automate deployment by using Bicep - Install Visual Studio Code 4:08
  • 70, 73. Automate deployment by using Bicep - Creating/deploying Bicep code 9:31
  • 71, 73. Automate deployment by using PowerShell 4:29
  • 72, 73. Automate deployment by using Azure CLI 3:17
  • Plan and Implement Data Platform Resources
Chương 6 Configure Azure SQL Database resources for scale and performance
  • 9. configure Azure SQL Database for scale and performance 4:56
  • 9, 62, 65. vCore-based purchasing model 8:37
  • 9, 62, 65. DTU-based purchasing model, Server vs Serverless 7:17
  • 9, 62, 65. Serverless/provisioned and elastic pools 6:18
  • 9, 62, 65. Other Azure SQL Database configuration settings 4:04
  • 9. calculate resource requirements, including Elastic pool requirements 3:59
  • 7, 8, 12. database sharding and table partitioning 10:52
  • 13. evaluate the use of compression for tables and indexes 13:19
  • Configure Azure SQL Database resources for scale and performance
Chương 7 Evaluate a strategy for migrating to Azure
  • 14, 15. evaluate requirements and strategies for the migration 5:52
  • 16, 21. Azure Migrate 3:10
  • 16, 21. SQL Server Migration Assistant (SSMA) 4:51
  • 16, 21. Azure Database Migration Service (DMS) 6:38
  • 22. Implement a migration between Azure SQL services - export data 4:24
  • 22. Implement a migration between Azure SQL services - Other methods 9:13
  • Evaluate a strategy for migrating to Azure
Chương 8 Configure database AuthN and AuthZ by using platform and database tools
  • What is Microsoft Entra ID?
  • 23. configure Microsoft Entra ID authentication 8:11
  • 24. create users from Microsoft Entra ID identities 8:10
  • 25, 29. configure security principals - roles 9:05
  • 25, 29. configure security principals - GRANT/REVOKE/DENY 3:58
  • 25, 29. configure security principals - individual permissions 4:55
  • 25, 29. configure security principals - the ALL permission 3:30
  • 29. configure permissions by using custom roles 5:24
  • 27. apply principle of least privilege for all securables 2:41
  • Configure database AuthN and AuthZ by using platform and database tools
Chương 9 Implement security for data at rest and in transit
  • 30. implement Transparent Data Encryption (TDE) 4:00
  • 31, 33. implement object-level encryption and Always Encrypted 10:12
  • 31, 33. More about Always Encrypted 9:24
  • Always Encrypted versus Transparent Data Encryption 2:16
  • 33a. Implement Always Encrypted with VBS enclaves 5:27
  • 39. implement Dynamic Data Masking 7:33
  • 32. configure server and database-level firewall rules 7:34
  • 34. Configure private links and service endpoints 6:37
  • Implement security for data at rest and in transit
Chương 10 Implement compliance controls for sensitive data - Part 1
  • 36. apply a data classification strategy 5:40
  • 37. configure server and database audits 8:32
  • 38. implement data change tracking - Change Tracking 10:10
  • 38. implement data change tracking - Change Data Capture 7:14
  • 39. perform a vulnerability assessment 4:38
  • Implement compliance controls for sensitive data
Chương 11 Implement compliance controls for sensitive data - Part 2
  • Adding a secret in Azure Key Vault
  • 41. Implement Azure SQL ledger - Theory 8:08
  • 41. Implement Azure SQL ledger - Creating Updateable ledger table 6:54
  • 41. Implement Azure SQL ledger - Append-only table and verifying 9:34
  • 42. Implement row-level security 10:46
Chương 12 Monitor activity and performance
  • 44. prepare an operational performance baseline - Metrics Explorer 4:39
  • 44. prepare an operational performance baseline - Other ways 5:29
  • 77. create event notifications for Azure resources 9:29
  • 45. determine sources for performance metrics 4:32
  • 46. interpret performance metrics 5:53
  • 47, 57a. Monitor by using Intelligent Insights 3:47
  • 47. configure and monitor activity and performance 5:19
  • 48a. Creating a database watcher 4:59
  • 48a. Monitoring using a database watcher 5:13
  • Monitor activity and performance
Chương 13 Implement performance-related maintenance tasks
  • 58. implement index maintenance tasks 8:01
  • 59. implement statistics maintenance tasks 2:55
  • 61, 75. configure database auto-tuning and automate performance tuning 5:04
  • Manage storage capacity 5:18
  • Assess growth/fragmentation and report on database free space 4:47
  • Implement performance-related maintenance tasks
Chương 14 Identify performance-related issues
  • 50, 51, 57. Query Store - an introduction 5:38
  • 50, 51, 57. configure Query Store, extract query plans 8:37
  • 52. identify sessions that cause blocking 5:06
  • Isolation Levels 6:02
  • Assess performance-related database configuration parameters 6:13
  • 66. configure Intelligent Query Processing (IQP) 10:19
  • Identify performance-related issues
Chương 15 Automate tasks and Perform backup and restore a database by using database tools
  • 74. What is Elastic Job Agent? 5:54
  • 74. automate database maintenance tasks 10:44
  • Full, differential and transaction log backups 5:13
  • 82, 86. perform a database restore to a point in time - test DR 6:16
  • 87. configure long-term backup retention 4:08
  • Automate tasks and Perform backup and restore a database by using database tools
Chương 16 Recommend an HADR strategy for a data platform solution
  • 79. recommend HADR strategy based on RPO/RTO requirements 7:21
  • 81. evaluate Azure-specific HADR solutions 6:20
  • 89. configure replication - Active Geo-replication 10:30
  • 82, 91. configure auto-failover groups and test HA by using failover 8:27
  • Recommend an HADR strategy for a data platform solution
Chương 17 Perform Administration by Using T-SQL
  • 60. evaluate database health using DMVs - overall resource usage 5:16
  • 60. evaluate database health using DMVs - other topics 4:55
  • 60. evaluate server health using DMVs 2:37
  • 60. perform database consistency checks by using DBCC 7:35
  • 55. review database configuration options 4:03
  • Perform Administration by Using T-SQL
Chương 18 Introduction to Virtual Machines and Managed Instances (MI)
  • 5, 6. Evaluating MIs and VMs based on specific requirements 5:42
  • 10, 62, 65. configure Azure SQL Managed Instance for scale and performance 5:14
  • More about Azure SQL Managed Instance 5:06
  • 23a, 34. Accessing Azure SQL Managed Instance in SSMS 6:27
  • 22a. Implement Azure SQL Managed Instance database copy and move 3:37
  • 11, 62, 65. configure SQL Server in Azure VMs - Part 1 7:15
  • 11, 62, 65. configure SQL Server in Azure VMs - Part 2 5:08
  • 23a. Logging into SQL Server on Azure Virtual Machines 6:42
  • 11. Adding additional disks to the Azure Virtual Machine 7:45
  • 6a. Identify use cases for Azure Arc-enabled SQL services 2:35
  • 6b. Identify use cases for Azure SQL Database in Microsoft Fabric 7:00
Chương 19 Configure database authentication, and filegroups
  • 24, 29. create users from Azure AD identities (MIs and VMs) 6:31
  • 29. manage certificates using T-SQL 3:31
  • 26, 29. configure database and object-level permissions using GUI 3:14
  • 25, 29. configure security principals (MIs and VMs) 6:49
  • 65. recommend table, index storage inc. filegroups (MI and VMs) 11:02
  • Upgrade strategy, configure database authentication, and filegroups
Chương 20 Evaluate and implement an alert and notification strategy
  • 77. create event notifications based on metrics 3:32
  • 68. configure notifications for task success/failure/non-completion 4:38
  • 67. manage schedules and automate maintenance jobs 7:42
  • 77. create alerts for server configuration changes 4:02
  • 77. split and filter event notifications for Azure resources 2:54
  • Evaluate and implement an alert and notification strategy
Chương 21 Identify performance-related issues
  • 45. determine sources for performance metrics 5:32
  • 58. implement index maintenance tasks (Database Engine Tuning Advisor) 3:45
  • 49. Monitor activity: SQL Profile, Extended Events, Performance Dashboard 8:21
  • 63. configure Resource Governor for performance (VM/MI) 8:18
  • Identify performance-related issues
Chương 22 Create scheduled tasks
  • 3, 75. apply patches and updates for hybrid and IaaS deployment 4:53
  • 34. implement Azure Key Vault and disk encryption for Azure VMs 3:53
  • 75. configure multi-server automation 3:53
  • 75. implement policies by using automated evaluation modes 8:14
  • Create scheduled tasks
Chương 23 Perform backup and restore a database by using database tools - VMs
  • 75. automate backups 4:03
  • 84. perform a database backup with options 7:09
  • 88. database (and transaction log) backups with options 7:10
  • 85, 86. perform a database restore with options 12:01
  • 88. perform restore of user databases in T-SQL 2:51
  • 88a. backup and restore to and from cloud storage 7:13
  • Perform backup and restore a database by using database tools - VMs
Chương 24 Recommend and test HA/DR strategies, and configure HA/DR
  • 89. configure replication - Transactional replication 8:39
  • 4, 80, 81. evaluate HADR for hybrid and Azure-specific deployments 8:09
  • Creating Virtual Machines for Failover Cluster and Always On Availability Group 5:09
  • Connecting Virtual Machines to a Domain 13:11
  • 93. Configure failover cluster instances on Azure VMs 5:03
  • 90. Checking SQL Server Installation and preparing for AO 6:26
  • 92 (90). configure quorum options for a Windows Server Failover Cluster 8:15
  • 90. create an Availability Group 6:12
  • 82, 90. Failover, integrate database into Always On Availability Group 3:42
  • 90. configure an Always On Availability Group listener 2:14
  • 94. Log shipping theory and creating folders 5:36
  • 94. Configure log shipping 7:50
  • 94. Testing log shipping and troubleshooting 7:24
  • Recommend and test HA/DR strategies, and configure HA/DR
Chương 25 Conclusion
  • What's Next? 3:27
  • Practice Test
  • Practice Test - DMVs and roles
  • Well done 0:52
Chương 26 Bonus section - No longer needed for the DP-300 exam
  • No longer needed for the DP-300 exam
  • Validate data types defined for columns 8:44
  • Identify data quality issues with duplication of data 5:42
  • Identify normal form of database tables - Normal Forms 1 to 3 8:55
  • Identify normal form of database tables - Normal Forms 4 to 5 6:41
  • Evaluate requirements and strategies for the upgrade 5:06
  • Implement an online and offline upgrade strategy 7:06
  • 76. Azure Logic Apps (not needed in the DP-300 from 7 February 2024) 9:22
  • 76. Expanding our Logic App (not needed in the DP-300 from 7 February 2024) 6:22
  • * 56. assess the use of hints for query performance 8:04
  • * 20. set up SQL Data Sync - retires on 30 September 2027 11:30
  • * 18. Perform post migration validations 3:58
  • * 35. Configure Transport Layer Security (TLS) 3:59
  • * 40. Manage database resources by using Azure Purview - theory + credentials 7:17
  • * 40. Manage data resources by using Azure Purview - sources and scans 6:45
  • * 43. Configure Advanced Threat Protection / Microsoft Defender for SQL 4:40
  • Bonus Quiz
Chương 27 Bonus Lecture
  • Bonus Lecture - DP-300

Requirment

  • You will need to already be familiar with the 6 principal clauses of the SELECT statement - SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY

  • It will also be good if you have had prior experience with Azure - but this is not essential.

  • A lot of this course will use SQL Server Management Studio (SSMS). The latest version requires 64-bit Windows, but you could use SSMS 17.9.1 if you have 32-bit Windows.

  • If you have a Mac, then you can use Azure Data Studio for querying, but that doesn't have all of the management capabilities of SSMS.

  • For accessing the Azure portal, you will also need an internet browser (Edge or Chrome preferred).

  • There is a 30-day refund guarantee of this Udemy course (see Udemy's refund policy).

  • Why not have a look at the curriculum below and see what you can learn?

Outcomes

  • 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

Instructor

...
Phillip Burton - over one million students so far

0.0

  • ... 0 Student
  • ... 5 Courses
  • ... 0 review

View Details

Reviews

Rate this course :

Remove all