DP-300: Administering Microsoft Azure SQL Solutions (DBA)
What you'll learn
- 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
Requirements
- 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?
Description
This course covers the content required for the DP-300 certification exam, current as per the DP-300 exam update of 4 August 2022, and the minor changes as of 25 October 2022, 2 February and 23 August 2023.
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?
Who this course is for:
- 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?
Instructors
- 4.6 Instructor Rating
- 110,142 Reviews
- 684,017 Students
- 50 Courses
Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 630,000 students and more than 40 video courses, including over a dozen Bestseller courses.
My courses include Power BI, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. Many of my courses follow requirements for official Microsoft certifications - so with a bit of practice, you could enter the exam and put it on your CV or resume.
I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.
- 4.6 Instructor Rating
- 92,828 Reviews
- 674,080 Students
- 39 Courses
I Do Data is dedicated to creating video courses on Udemy in a variety of computer-related topics, such as SQL in its different dialects and Microsoft Office.
Are you wanting to learn a new skill from the beginning? Or are you wanting to build on an existing skill? In either case, welcome.
Our courses are available on Udemy at any time, so you can watch them whenever you like, as often as you like.
For many of our courses, if you master the skills taught, you are able (if you wish) to take (and hopefully pass) the official certification offered by Microsoft, Tableau or other companies.
That would look good on your CV or resume? It could make the difference between getting a promotion, or a more rewarding job.
I Do Data courses are dedicated to enabling you to succeed.