Module 1: The Role of the Azure Database Administrator
- Azure Data Platform Roles
- Azure Database Platforms and Options
- SQL Server Compatibility Levels
- Azure Preview Features
Module 2: Plan and Implement Data Platform Resources
- Deploying SQL Server using PaaS
- Deploying Open Source Database Solutions on Azure
- Deploying SQL Server using IaaS
Module 3: Implement a Secure Environment
- Implement Security for Data in Transit
- Implement Security for Data at Rest
- Implement Compliance Controls for Sensitive Data
Module 4: Monitor and Optimize Operational Resources
- Lessons to be learned:
- Configuring Resources for Optimal Performance
- Performance-related Maintenance Tasks
- User Database Configuration
- Baselines and Performance Monitoring
- Major Causes of Performance Issues
Module 5: Optimize Query Performance
- Understanding SQL Server Query Plans
- Explore Performance-based Database Design
- Evaluate Performance Improvements
Module 6: Automation of Tasks
- Setting up Automatic Deployment
- Defining Scheduled Tasks
- Configuring Extended Events
- Managing Azure PaaS resources Using Automated Methods
Module 7: Plan and Implement a High Availability and Disaster Recovery Environment
- IaaS Platform and Database Tools for HADR
- PaaS Platform and Database Tools for HADR
- High Availability and Disaster Recovery Strategies
- Database Backup and Recovery