Course Description
Course Overview
Administering Microsoft Azure SQL Solutions (DP-300) is a comprehensive training program designed to equip database administrators with the knowledge and skills required to effectively manage and maintain Microsoft Azure SQL databases and solutions. Participants will gain hands-on experience in deploying, monitoring, securing, and optimizing Azure SQL databases, ensuring high performance, availability, and data integrity in a cloud-based environment.
Prerequisites
To get the most out of this course, participants should have a solid understanding of basic database concepts, SQL Server administration, and experience working with Microsoft Azure services. Prior knowledge of cloud computing fundamentals, Azure portal navigation, and PowerShell will be beneficial.
Methodology
The course will be delivered through a combination of lectures, practical demonstrations, hands-on labs, and interactive discussions. Participants will have access to a dedicated Azure environment for hands-on practice, allowing them to apply the concepts learned in real-world scenarios. The course will be led by certified Azure instructors with extensive industry experience, ensuring a high-quality learning experience.
Course Outline
- Introduction to Azure SQL Solutions
- Overview of Microsoft Azure SQL services
- Comparison between Azure SQL Database and SQL Server on-premises
- Understanding Azure SQL Deployment Models
- Provisioning Azure SQL Databases
- Creating and configuring Azure SQL databases
- Managing database files and filegroups
- Configuring custom performance tiers
- Securing Azure SQL Databases
- Implementing Azure Active Directory authentication
- Configuring database-level firewall rules
- Utilizing Azure Key Vault for encryption
- Managing Azure SQL Database Connectivity
- Configuring and optimizing network connectivity
- Load balancing and failover strategies
- Using Private Link for secure access
- Monitoring and Performance Tuning
- Utilizing Azure Monitor for performance monitoring
- Identifying and resolving performance bottlenecks
- Query performance optimization techniques
- High Availability and Disaster Recovery
- Implementing Azure SQL Database backup and restore
- Configuring geo-replication for disaster recovery
- Failover groups for high availability
- Migrating Databases to Azure SQL
- Assessing database migration readiness
- Performing database migration using various methods
- Database migration best practices
Outcome
By the end of this course, participants will be able to:
- Effectively administer Azure SQL databases and solutions in the cloud.
- Secure databases using Azure Active Directory and encryption techniques.
- Optimize database performance and monitor their health using Azure tools.
- Implement high availability and disaster recovery strategies for business continuity.
- Migrate on-premises databases to Azure SQL, considering best practices.
Labs
- Provisioning an Azure SQL Database
- Configuring Firewall Rules and Authentication Modes
- Implementing Azure Key Vault for Encryption
- Implementing Private Link for Secure Access
- Monitoring Database Performance with Azure Monitor
- Configuring Geo-Replication for Disaster Recovery
- Database Migration using Azure Database Migration Service
- High Availability with Failover Groups