Retail Price: $2,380
4 Days
DIR receives a discount off of the retail price shown.
Click here to access the DIR discount list.
Learning Objectives
After completing this course, students will be able to:- Plan, deploy and configure Azure SQL offerings
- Monitor database performance and tune a database and queries for optimum performance
- Plan and configure a High Availability Solution
Course Details
Course Outline
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
Actual course outline may vary depending on offering center. Contact your sales representative for more information.