Program Outline
Implement scalable database solutions using Azure SQL
This course provides students with the knowledge and skills to create a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.
Delivery
Virtual, On-site, or Hybrid
Duration
4 days
Product
Azure
Role
Database Administrator
Microsoft
DatabasesAzure Database Administrator Associate
Azure
Best Fit
Audience Profile
Who This Program Is 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.
Overview
Program Summary
As a candidate for this certification, you should have subject matter expertise in building database solutions that are designed to support multiple workloads built with: Azure SQL services SQL Server on-premises You're a database administrator who manages cloud and on-premises databases built with Azure SQL services and SQL Server.
Course Outline
Complete Module Sequence
Review the full module sequence for this program, including the primary topic coverage in each module where available.
1Module 1
Plan and implement data platform resources
+
Module 1
Plan and implement data platform resources
Plan and implement data platform resources
- Prepare to maintain SQL Server-based databases on Azure
- Deploy IaaS solutions with Azure SQL
- Deploy PaaS solutions with Azure SQL
- Migrate SQL Server workloads to Azure SQL Database
- Migrate SQL Server workloads to Azure SQL Managed Instance
2Module 2
Implement a secure environment for a database service
+
Module 2
Implement a secure environment for a database service
Implement a secure environment for a database service
- Configure database authentication and authorization
- Protect data in-transit and at rest
- Implement compliance controls for sensitive data
3Module 3
Monitor and optimize operational resources in Azure SQL
+
Module 3
Monitor and optimize operational resources in Azure SQL
Monitor and optimize operational resources in Azure SQL
- Describe performance monitoring
- Configure SQL Server resources for optimal performance
- Configure databases for optimal performance
4Module 4
Optimize query performance in Azure SQL
+
Module 4
Optimize query performance in Azure SQL
Optimize query performance in Azure SQL
- Explore query performance optimization
- Explore performance-based database design
- Evaluate performance improvements
5Module 5
Automate database tasks for Azure SQL
+
Module 5
Automate database tasks for Azure SQL
Automate database tasks for Azure SQL
- Automate database deployment
- Create and manage SQL Agent jobs
- Manage Azure PaaS tasks using automation
6Module 6
Plan and implement a high availability and disaster recovery environment
+
Module 6
Plan and implement a high availability and disaster recovery environment
Data must be available when needed. Configure, test and manage a solution for high availability and disaster recovery using Azure tools and SQL Server tools.
- Describe high availability and disaster recovery strategies
- Explore IaaS and PaaS solutions for high availability and disaster recovery
- Back up and restore databases
Coverage Areas
Topic Coverage
Coverage Item 1
Plan and implement data platform resources
Coverage Item 2
Implement a secure environment
Coverage Item 3
Monitor, configure, and optimize database resources
Coverage Item 4
Configure and manage automation of tasks
Coverage Item 5
Plan and configure a high availability and disaster recovery (HA/DR) environment
Customization
Adapt This Program for Your Team
We can adapt this program around your team structure, platform priorities, delivery goals, and the scenarios your people need to work through in practice.
- •Align labs to your Microsoft tenant and workload scenarios
- •Add readiness checks and exam preparation reviews
- •Extend delivery with role-specific implementation workshops
