Azure Database Admin Associate DP-300 Training

Current Status
Not Enrolled
Price
Closed
Get Started

Crafted with meticulous attention to detail by a seasoned industry professional with over 5 years of Azure expertise, the course “Mastering Azure” provides learners with a comprehensive curriculum to acquire comprehensive knowledge and proficiency in this domain. AZURE DP-300 Prepare for the Azure DP 300 certification with the Azure DP-300 training. Learn how to plan and implement data platform resources, secure environment, and high availability and disaster recovery (HADR) environment. The Azure DP-300 training will enable you to monitor and optimize operational resources and query performance, perform automation of tasks and perform administration by using T-SQL.

Duration : 21 hour 35 minutes

In This Module We Will Learn :

THE ROLE OF DATABASE ADMINISTRATOR

  • Azure data platform roles 
  • Azure database platforms and options 
  • SQL Server compatibility level 
  • Azure preview features 

PLAN AND IMPLEMENT DATA PLATFORM RESOURCE

  • Deploy resources using manual methods 
  • Recommend an appropriate database offering based on requirements 
  • Configure Azure resources 
  • Evaluate and implement a strategy for moving a database to Azure 

IMPLEMENT A SECURE ENVIRONMENT

  • Configure database authentication  
  • Configure database permissions 
  • Implement security for data at rest  
  • Implement security for data in transit 
  • Implement compliance controls for sensitive data 

MONITOR AND OPTIMIZE OPERATIONAL RESOURCE

  • Monitor activity and compare to a baseline  
  • Define maintenance tasks related to performance  
  • Identify major causes of performance problems  
  • Configure resources for optimal performance  
  • Configure a user database for optimal performance

OPTIMIZE QUERY PERFORMANCE

  • Analyze query plans and identify problem areas
  • Evaluate potential query improvements  
  • Review table and index design  
  • Determine whether a query or design changes have had a positive effect  

AUTOMATION OF TASKS

  • Deploy Azure Resources using automated deployment scripts 
  • Create Scheduled Tasks in SQL Server 
  • Create notifications for failures and performance alerts 
  • Configure automation for PaaS Services 

PLANNING AND IMPLEMENTING A HIGH AVAILABILITY AND DISASTER RECOVERY ENVIRONMENT

  • The difference between recovery time and recovery point objectives  
  • The available HADR options for both IaaS and PaaS  
  • PaaS platform and database tools for HADR 
  • Database backup and restore 

Course Content

Expand All

Similar Courses:

Azure Data Engineer DP-203 Training

Azure Data Engineer DP-203 Training

The Azure Database Engineer Associate DP-203 training prepares you for the Azure DP-203 certification exam.…

Azure AI Fundamentals AI-900 Training

Azure AI Fundamentals AI-900 Training

Crafted with meticulous attention to detail by a seasoned industry professional with over 5 years…

Azure Data Fundamentals DP-900 Training

Azure Data Fundamentals DP-900 Training

Crafted with meticulous attention to detail by a seasoned industry professional with over 5 years…

Azure Admin Associate AZ-104 Training

Azure Admin Associate AZ-104 Training

Crafted with meticulous attention to detail by a seasoned industry professional with over 5 years…