DP-300 Administering Microsoft Azure SQL Solutions Course

Businesses handle large volumes of information, traveling back and forth between transactions with customers and internal communication.
Relational databases are integral to maintaining the data storage integrity within a business.
The DP-300T00: Administering Microsoft Azure SQL Solutions Course offers candidates an opportunity to introduce on-premise and cloud storage and management solutions.
The Azure database administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built on SQL Server and SQL database services.
Professionals in this role use a variety of methods and tools to perform and automate day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes.
These professionals are responsible for management, availability, security, and performance monitoring and optimization of database solutions.
They evaluate and implement migration strategies for moving databases to Azure.
Plus, they work with Azure data engineers, Azure solution architects, Azure developers, and other professionals to manage operational aspects of data platform solutions.
You Learn to:
Plan and implement data platform resources
Implement a secure environment
Monitor, configure, and optimize database resources
Configure and manage automation of tasks
Plan and configure a high availability and disaster recovery (HA/DR) environment

Course Outline

Module 1: The Role of the Azure Database Administrator

Module 2: Plan and Implement Data Platform Resources

Deploying SQL Server using IaaS
Deploying SQL Server using PaaS
Deploying Open Source Database Solutions on Azure
Lab : Deploying Azure SQL Database
Deploy a VM using an ARM template
Configure resources needed prior to creating a database
Deploy an Azure SQL Database
Register the Azure SQL Database instance in Azure Data Studio and validate connectivity
Deploy PostgreSQL or MySQL using a client tool to validate connectivity

Module 3: Implement a Secure Environment

Module 4: Monitor and Optimize Operational Resources

Module 5: Optimize Query Performance

Module 6: Automation of Tasks

Setting up Automatic Deployment
Defining Scheduled Tasks
Configuring Extended Events
Managing Azure PaaS resources Using Automated Methods
Lab : Automating Tasks
Deploy an Azure template from a Quickstart template on GitHub
Configure notifications based on performance metrics
Deploy an Azure Automation Runbook (or elastic job) to rebuild indexes on an Azure SQL Database

Module 7: Plan and Implement a High Availability and Disaster Recovery Environment

What you will learn

1.Planning and Implementation of Data Platform Resources:

The first module covers the best practices to deploy resources using manual methods, how to recommend a valid database offering when stringent requirements are expressed, how to best configure resources around business scaling and performance, the best strategies to integrate while migrating to Azure and finally, how to best introduce a strategy around the same.

2.Implementation of A Secure Environment:

One of the biggest concerns around databases and information management revolves around data security. This module covers how to best configure database authorization using both the platform and database tools, the best way to implement security for data both in transit and at rest and finally, the best practices to ensure compliance controls are actively used when dealing with sensitive data.

3. Monitor and Optimize Operational Resources :

Maintaining consistent performance is just as critical as introducing the right solution. This module covers how students should keep a close eye on activity and performance while implementing performance-related maintenance tasks, identifying performance-related issues, and configuring resources and the user database for optimal performance.

4. Optimization of Query Performance:

Students learn to review query plans, evaluate performance improvements, and review database table and index design to ensure all relevant features and changes are working cohesively with the database.

5. Performing Automation of Tasks:

Automation sits at the forefront of many business strategies today. Automation offers improved efficiency and effectiveness. This module covers how to create scheduled tasks, introduce alert and notification strategies and introduce the best methods to automate tasks within Azure.

6. Planning and Implementation around High Availability and Disaster Recovery (HADR) Environment:

Within this module, students learn how to recommend a HADR strategy for data platform solutions, test the same strategy using platforms and database tools, perform backups, and configure the HA/DR.

7. Performing Administration Using T-SQL :

The final module within the examination unit allows students to understand system health, introduce configurations using T-SQL, monitor database configurations, perform backups and manage both authenticity and authorization using T-SQL.

Audience profile

Database Administrators
Data Management Specialists
Azure Data Engineers
Any professional entering an organization in an operational management capacity across data platform solutions would be an ideal candidate.