This Administering Microsoft Azure SQL Solutions (DP-300) course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be helpful to individuals who develop applications that deliver content from SQL-based relational databases.
Administering Microsoft Azure SQL Solutions (DP-300) Delivery Methods
In-Person
Online
Important DP-300 Course and Certification Information
In this Administering Microsoft Azure SQL Solutions (DP-300) course, you will learn how to:
Plan, deploy and configure Azure SQL offerings.
Monitor database performance and tune a database and queries for optimum performance.
Plan and configure a High Availability Solution.
Administering Microsoft Azure SQL Solutions (DP-300) Prerequisites
Successful Azure Database Administrators start this role with professional experience in database management and technical knowledge of cloud technologies. Specifically:
Working with, maintaining, and developing with SQL Server
Experience with Azure, such as deploying and managing resources
At a minimum, you should know the information in the following courses before attending the course:
Microsoft Azure Fundamentals Training (AZ-900T00)
Microsoft Azure Data Fundamentals Training (DP-900)
Administering Microsoft Azure SQL Solutions (DP-300) Exam Information
This course can help you prepare for the following Microsoft role-based certification exam — Exam DP-300: Administering Relational Databases on Microsoft Azure.
DP-300 Training Outline
Module 1: Introduction to Azure Database Administration
This module explores the role of a database administrator in the world of Azure SQL. It also provides some foundational information relevant to the overall content. This includes reviewing the various SQL Server-based options (SQL Server in a VM, SQL Managed Instance, and Azure SQL Database).
Lessons
Prepare to maintain SQL databases on Azure
After completing this module, students will be able to:
Understand the role of Azure Database Administrator as it fits in with other data platform roles
Be able to describe the key differences between the SQL Server-based database options
Describe other features for Azure SQL platforms available
Module 2: Plan and Implement Data Platform Resources
Module 3: Implement a Secure Environment for a Database Service
Module 4: Monitor and Optimize Operational Resources
Module 5: Optimize Query Performance
Module 6: Automate database tasks
Module 7: Plan and Implement a High Availability and Disaster Recovery Solution
العربية