Duration 4 days – 28 hrs
Overview
This course teaches concepts and techniques that are crucial for anyone administering SQL Server databases on Microsoft Azure. It also provides content for working with hybrid database systems, on-premises SQL Server installation, and Azure databases. The course assumes that the students have professional experience working with Microsoft SQL Server as a Database Administrator.
Candidates for this exam should have subject matter expertise in designing, creating, and deploying enterprise-scale database solutions.
Objectives
- Understand the fundamentals of Microsoft Azure SQL solutions and their role in cloud computing.
- Learn how to deploy and configure Azure SQL databases for optimal performance and scalability.
- Gain proficiency in managing security and access controls for Azure SQL solutions to ensure data protection and compliance.
- Explore techniques for monitoring and troubleshooting Azure SQL databases to maintain uptime and reliability.
- Develop skills in implementing disaster recovery and high availability solutions for Azure SQL databases.
- Learn best practices for optimizing and tuning Azure SQL databases to meet performance requirements.
- Understand advanced features and capabilities of Azure SQL solutions for efficient data management and analytics.
- Prepare for the Microsoft Certified: Azure Database Administrator Associate certification exam (exam DP-300) through hands-on exercises and practical knowledge acquisition.
Audience
- Database Administrators: Professionals responsible for managing and administering databases, both on-premises and in the cloud, who want to expand their skills to include Azure SQL solutions.
- Cloud Administrators: Individuals tasked with managing cloud resources and services within Microsoft Azure, particularly those related to databases.
- IT Professionals: Those responsible for maintaining and optimizing database performance, security, and availability in a cloud environment.
- System Administrators: Professionals involved in configuring, monitoring, and troubleshooting databases and database-related services.
- Data Engineers: Individuals responsible for designing, building, and maintaining data solutions, including database architecture and management.
- Developers: Those involved in developing applications that leverage Azure SQL databases, who want to gain a deeper understanding of database administration in Azure.
- IT Managers: Decision-makers responsible for overseeing database operations and strategic planning within their organization’s IT infrastructure.
Pre- requisites
- A foundational knowledge of core data concepts and how they’re implemented using Azure data services. For more information see Azure Data Fundamentals.
- Experience designing and building scalable databases, configuring, monitoring, and optimizing databases to increase business value using Microsoft SQL Server. For more information see Azure Database Administrator.
Course Content
Day 1
- Introduction to Azure Database Administration
- Plan and implement data platform resources.
- Lab 1: Provision SQL Server on an Azure Virtual Machine
- Lab 2: Provision an Azure SQL Database
Day 2
- Implement a secure environment.
- Lab 3: Authorize access to Azure SQL Database with Microsoft Entra ID
- Lab 4: Configure a server-based firewall rule using the Azure portal
- Lab 5: Enable Microsoft Defender for SQL and Data Classification
- Monitor and optimize operations resources.
- Lab 6: Isolate performance problems through monitoring
- Lab 7: Detect and correct fragmentation issues.
Day 3
- Optimize query performance.
- Lab 8: Identify and resolve blocking issues.
- Lab 9: Identify database design issues.
- Lab 10: Isolate problem areas in poorly performing queries in an SQL Database.
- Automate database tasks.
- Lab 11: Deploy an Azure SQL Database using an Azure Resource Manager Template.
- Lab 12: Create a CPU status alert for a SQL Server
- Lab 13: Deploy an Automation runbook to automatically rebuild indexes.
Day 4
- Plan and implement a high availability and disaster recovery environment.
- Lab 14: Configure geo-replication for Azure SQL Database
- Lab 15: Backup to URL and Restore from URL