DP-300T00 : Administering Microsoft Azure SQL Solutions

The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications.

·         MODULE Prepare to maintain SQL databases on Azure

·         MODULE Deploy IaaS solutions with Azure SQL

·         MODULE Deploy PaaS solutions with Azure SQL

·         MODULE Evaluate strategies for migrating to Azure SQL

·         MODULE Migrate SQL workloads to Azure SQL databases

·         MODULE Migrate SQL workloads to Azure Managed Instances

·         MODULE Configure database authentication and authorization

·         MODULE Protect data in-transit and at rest

·         MODULE Implement compliance controls for sensitive data

·         MODULE Describe performance monitoring

·         MODULE Configure SQL Server resources for optimal performance

·         MODULE Configure databases for optimal performance

·         MODULE Explore query performance optimization

·         MODULE Evaluate performance improvements

·         MODULE Explore performance-based design

·         MODULE Automate deployment of database resources

·         MODULE Create and manage SQL Agent jobs

·         MODULE Manage Azure PaaS tasks using automation

·         MODULE Describe high availability and disaster recovery strategies

·         MODULE Explore IaaS and PaaS solutions for high availability and disaster recovery

·         MODULE Back up and restore databases

Microsoft Certified: Azure Database Administrator Associate

The Azure Database Administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built on Microsoft Azure data services and Microsoft SQL Server. 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.

Required Exam : DP-300

Successful Azure Database Administrators start this role with professional experience in database management and technical knowledge of cloud technologies.

In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses:

·         Azure Fundamentals

·         Azure Data Fundamentals