Administering Microsoft Azure SQL Solutions (DP-300T00)
Course Duration: 5 Days
Live Class with Instructor
Hands-on Labs
Recorded Course, 1 Year
Course Overview
This course equips learners with the essential knowledge and skills to manage and maintain SQL Server database infrastructures across cloud, on-premises, and hybrid environments. It is ideal for database administrators, as well as developers working with Microsoft’s PaaS relational database services. Additionally, it supports preparation for the DP-300: Administering Microsoft Azure SQL Solutions certification exam.
By the end of this course, participants will be able to:
Plan, deploy, and configure various Azure SQL solutions
Monitor and optimize database performance, including query tuning
Design and implement high availability and disaster recovery strategies
Course Audience
This course is designed for data professionals responsible for managing data and databases who want to learn how to administer Microsoft Azure data platform technologies. It is also ideal for data architects and application developers seeking to understand Azure’s data solutions and how to integrate them into their applications.
Course Prerequisites
Successful Azure Database Administrators typically enter this role with prior experience in database management and a solid understanding of cloud technologies. Ideal candidates should have:
Hands-on experience with SQL Server, including maintenance and development
Familiarity with Azure, particularly in deploying and managing cloud resources
While the following free training courses can support your preparation, they should be complemented by practical, real-world experience for maximum effectiveness
.
Course Outline
1. Understanding the Role of the Azure Database Administrator
Overview of Azure Data Platform roles
Azure database platforms and service options
SQL Server compatibility levels in Azure
Working with Azure preview features
2. Planning and Implementing Data Platform Resources
Deploying SQL Server using Infrastructure as a Service (IaaS)
Deploying SQL Server using Platform as a Service (PaaS)
Deploying open-source database solutions on Azure
3. Implementing a Secure Environment
Configuring database authentication and authorization
Securing data at rest and in transit
Implementing compliance controls for sensitive data
4. Monitoring and Optimizing Operational Resources
Establishing performance baselines and monitoring strategies
Identifying common performance issues
Configuring databases for optimal resource usage
Managing performance-related maintenance tasks
5. Optimizing Query Performance
Understanding and analyzing SQL Server query plans
Designing databases for performance
Evaluating and applying performance improvements
6. Automating Administrative Tasks
Setting up automated deployments
Defining and managing scheduled tasks
Automating management of Azure PaaS resources
7. Planning and Implementing High Availability and Disaster Recovery (HADR)
Strategies for high availability and disaster recovery
HADR tools and configurations in IaaS environments
HADR solutions in PaaS environments
Performing database backup and recovery
Live Instructor-Led Virtual Class $3000
Virtual or In-Person Group Training
- For Private Groups as small as 2 people.
- Live, Instructor-led Online or Onsite Class for your group.
- Customizable to your needs.