1 - The Role of the Azure Database Administrator
Azure Data Platform RolesAzure Database Platforms and OptionsSQL Server Compatibility LevelsAzure Preview Features
2 - Plan and Implement Data Platform Resources
Deploying SQL Server using IaaSDeploying SQL Server using PaaSDeploying Open Source Database Solutions on Azure
3 - Implement a Secure Environment
Configure Database AuthenticationConfigure Database AuthorizationImplement Security for Data at RestImplement Security for Data in TransitImplement Compliance Controls for Sensitive Data
4 - Monitor and Optimize Operational Resources
Baselines and Performance MonitoringMajor Causes of Performance IssuesConfiguring Resources for Optimal PerformanceUser Database ConfigurationPerformance-related Maintenance Tasks
5 - Optimize Query Performance
Understanding SQL Server Query PlansExplore Performance-based Database DesignEvaluate Performance Improvements
6 - Automation of Tasks
Setting up Automatic DeploymentDefining Scheduled TasksConfiguring Extended EventsManaging Azure PaaS resources Using Automated Methods
7 - Plan and Implement a High Availability and Disaster Recovery Environment
High Availability and Disaster Recovery StrategiesIaaS Platform and Database Tools for HADRPaaS Platform and Database Tools for HADRDatabase Backup and Recovery
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications.
In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses:
Azure Data Fundamentals