What you’ll learn in DP-300: Administering Relational Databases – Azure DBA
- Resources for data platforms should be planned and implemented.
- Create a safe working environment.
- Monitor and improve the efficiency of your operations.
- Improve the speed of queries
- Tasks should be automated.
- Create a High Availability and Disaster Recovery (HADR) environment and put it in place.
- T-SQL is used to manage the database.
- SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY are the six major clauses of the SELECT statement.
- It’ll help if you’ve worked with Azure before, but it’s not required.
- The latest version of SQL Server Management Studio (SSMS) is required for this course; however, if you have 32-bit Windows, you can use SSMS 17.9.1.
- If you have a Mac, you can query with Azure Data Studio, but it lacks the management features of SSMS.
- You’ll also need a web browser (Edge or Chrome are recommended) to access the Azure portal.
- This Udemy course comes with a 30-day money-back guarantee (see Udemy’s refund policy for more details).
- Take a look at the curriculum listed below to see what you might be able to learn.
This course covers the content for the DP-300 certification exam as of September 24, 2021, according to the most recent DP-300 exam update.
This course covers the prerequisites for the Microsoft Certificate DP-300 “Administering Relational Databases on Microsoft Azure,” with a focus on Azure SQL Databases, Azure SQL Managed Instances, and SQL Server on Azure Virtual Machines.
We’ll then compare and contrast the various Data Platform Resources, before diving into configuring Azure SQL Database resources for scale and performance, including serverless and provisioned, vCore and DTU, and database partitioning techniques. Finally, we’ll assess migration strategies to Azure.
Following that, we’ll look at how to Monitor and Optimize Operational Resources, which includes tracking activity and performance, performing performance-related maintenance, and identifying performance-related issues.
Finally, we’ll look at how to use database tools to automate tasks and backup and restore databases, as well as recommend an HADR strategy for a data platform solution and more.
We’ll evaluate and implement an alert and notification strategy, identify performance-related issues with tools we couldn’t use in Azure SQL Database, and create scheduled tasks; finally, we’ll use database tools to backup and restore a database in Virtual Machines, and recommend, test, and configure High Availability and Disaster Recovery strategies.
You must have some prior experience with SQL Server, specifically:
This information can be found in the Udemy course “98-364: Database Fundamentals.”
Prior Azure knowledge, such as that demonstrated in Microsoft’s DP-900 exam, is also advantageous but not required.
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?
|File Name :||DP-300: Administering Relational Databases – Azure DBA Free Download|
|Genre / Category:||IT & Software|
|File Size :||0.61 gb|
|Publisher :||Phillip Burton|
|Updated and Published:||25 Oct,2021|