Exam DP-300: Administering Relational Databases on Microsoft Azure
4.7 /5- Offered byMicrosoft
Exam DP-300: Administering Relational Databases on Microsoft Azure at Microsoft Overview
Total fee | Free |
Mode of learning | Online |
Official Website | Explore Free Course  |
Credential | Certificate |
Exam DP-300: Administering Relational Databases on Microsoft Azure at Microsoft Highlights
- Earn a certificate after successful completion of the program
Exam DP-300: Administering Relational Databases on Microsoft Azure at Microsoft Course details
- For database administrators and data management specialists that manage on-premises and cloud relational databases built with Microsoft SQL Server and Microsoft Azure Data Services
- 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
- The Azure database administrator uses a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes
- This role is responsible for management, availability, security and performance monitoring and optimization of modern relational database solutions
- This role works with the Azure data engineer role to manage operational aspects of data platform solutions
Exam DP-300: Administering Relational Databases on Microsoft Azure at Microsoft Curriculum
Azure SQL fundamentals
Introduction to Azure SQL
Deploy and configure servers, instances, and databases for Azure SQL
Secure your data with Azure SQL
Plan and implement data platform resources
Deploy SQL Server in a virtual machine
Deploy Azure SQL Database
Deploy MariaDB, MySQL, and PostgreSQL on Azure
Evaluate strategies for migrating SQL Databases to Azure
Implement a secure environment for a database service
Configure database authentication and authorization
Protect data in-transit and at rest
Implement compliance controls for sensitive data
Monitor and optimize operational resources in SQL Server
Describe performance monitoring
Explore causes of performance issues
Configure SQL Server resources for optimal performance
Describe performance-related maintenance tasks in SQL Server
Optimize query performance in SQL Server
Describe SQL Server query plans
Evaluate performance improvements
Explore performance-based design
Automate tasks in SQL Server
Configure automatic deployment for Azure SQL Database
Schedule tasks using SQL Server Agent
Manage Azure PaaS resources using automated methods
Exam DP-300: Administering Relational Databases on Microsoft Azure at Microsoft Entry Requirements
- Prerequisites : Candidates for this role should understand all concepts covered in Exam DP-900: Microsoft Azure Data Fundamentals
- Not mentioned
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?