This course covers the content required for the DP-300 certification exam, current as per the DP-300 exam update of 24 September 2021.
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 Upgrading SQL Server, configure 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?
I hope to see you in the course - why not have a look at what you could learn?