DP-300 Admin Databases on Azure: 4-Day Workshop

Qualitia Energy

The audience for Administering Relational Databases on Azure workshop is data professionals managing data and databases who wants to learn about administering the data platform technologies on Azure.

Prerequisites There are no pre-requisites for taking this course. Technical IT experience is not required however some general IT knowledge or experience would be beneficial.


DAY 1: Module 1: The Role of the Azure Database Administrator Lessons

  • Azure Data Platform Roles
  • Azure Database Platforms and Options
  • SQL Server Compatibility Levels
  • Azure Preview Features Module 2: Plan and Implement Data Platform Resources Lessons
  • Deploying SQL Server using IaaS
  • Deploying SQL Server using PaaS
  • Deploying Open Source Database Solutions on Azure

DAY 2: Module 3: Implement a Secure Environment Lessons

  • Configure Database Authentication
  • Configure Database Authorization
  • Implement Security for Data at Rest
  • Implement Security for Data in Transit
  • Implement Compliance Controls for Sensitive Data Module 4: Monitor and Optimize Operational Resources Lessons
  • Baselines and Performance Monitoring
  • Major Causes of Performance Issues
  • Configuring Resources for Optimal Performance
  • User Database Configuration
  • Performance-related Maintenance Tasks

DAY 3: Module 5: Optimize Query Performance Lessons

  • Understanding SQL Server Query Plans
  • Explore Performance-based Database Design
  • Evaluate Performance Improvements Module 6: Automation of Tasks Lessons
  • Setting up Automatic Deployment
  • Defining Scheduled Tasks
  • Configuring Extended Events
  • Managing Azure PaaS resources Using Automated Methods

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

  • High Availability and Disaster Recovery Strategies
  • IaaS Platform and Database Tools for HADR
  • PaaS Platform and Database Tools for HADR
  • Database Backup and Recovery

NOTE: Please contact us for group discounts and flexible scheduling for all of our workshops to meet your requirements.