+91 9879558787 , +91 9825306119 info@itsahmedabad.com

Administering Relational Database on Microsoft Azure (DP-300)

Administering Relational Database on Microsoft Azure

 

Course Contents

  1. Azure Cloud & Azure Data Platform

The Role of the Database Administrator

  1. Azure Data Platform Roles
  2. Azure Database Platforms and Options
  3. SQL Server Compatibility Level
  4. Azure Preview Features

Plan and Implement Data Platform Resources

  1. Deploying SQL Server in an Azure VM
  2. Deploying a Platform as a Service Solution
  3. Deploying Open Source Databases to Azure MySQL, PostgreSQL, MariaDB

Implement a Secure Environment

  1. Configure Database Authentication
  2. Configure Database Authorization
  3. Implement Security for Data at Rest
  4. Implement Security for Data in Transit
  5. Implement Compliance Controls for Sensitive Data

Monitor and Optimize Operational Resources

  1. Baselines and Performance Monitoring
  2. Major Causes of Performance Issues
  3. Configuring Resources for Optimal Performance
  4. User Database Configuration

Optimize Query Performance

  1. Reviewing Query Execution Plans
  2. Design Considerations for Database Performance
  3. Evaluating Performance Improvements

Automation of Tasks

  1. Automatic Deployment of Azure Resources
  2. Defining Scheduled Tasks with the SQL Server Agent
  3. Configuring Extended Events
  4. Automating Azure tasks

Plan and Implement a High Availability and Disaster Recovery Environment

  1. High Availability and Disaster Recovery Strategies
  2. IaaS Platform and Database Tools for HADR
  3. PaaS Platform and Database Tools for HADR
  4. Database Backup and Recovery

 Trainers profile

Years real time experience

Corporate Training Customers

Student Testimonials

Please follow and like us:
0