1 - THE ROLE OF THE AZURE DATABASE ADMINISTRATOR

Azure Data Platform Roles

Azure Database Platforms and Options

SQL Server Compatibility Levels

Azure Preview Features

2 - PLAN AND IMPLEMENT DATA PLATFORM RESOURCES

Deploying SQL Server using IaaS

Deploying SQL Server using PaaS

Deploying Open Source Database Solutions on Azure

3 - IMPLEMENT A SECURE ENVIRONMENT

Configure Database Authentication

Configure Database Authorization

Implement Security for Data at Rest

Implement Security for Data in Transit

Implement Compliance Controls for Sensitive Data

4 - MONITOR AND OPTIMIZE OPERATIONAL RESOURCES

Baselines and Performance Monitoring

Major Causes of Performance Issues

Configuring Resources for Optimal Performance

User Database Configuration

Performance-related Maintenance Tasks

5 - OPTIMIZE QUERY PERFORMANCE

Understanding SQL Server Query Plans

Explore Performance-based Database Design

Evaluate Performance Improvements

6 - AUTOMATION OF TASKS

Setting up Automatic Deployment

Defining Scheduled Tasks

Configuring Extended Events

Managing Azure PaaS resources Using Automated Methods

7 - PLAN AND IMPLEMENT A HIGH AVAILABILITY AND DISASTER RECOVERY ENVIRONMENT

High Availability and Disaster Recovery Strategies

IaaS Platform and Database Tools for HADR

PaaS Platform and Database Tools for HADR

Database Backup and Recovery