Administering Microsoft Azure SQL Solutions Training (DP 300)

DP-300 is designed for database professionals who want to manage and administer SQL Server databases in Microsoft Azure. This course covers deployment, configuration, performance optimization, security, and high availability of Azure SQL solutions.

This course provides hands-on experience with Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines. Participants will learn how to monitor performance, implement security, automate maintenance, and ensure high availability of databases.

The course focuses on real-world administrative tasks and best practices.

Module 1: Introduction to Azure SQL

Topics Covered:

• Azure SQL platform overview
• Deployment options (PaaS vs IaaS)
• Azure SQL Database vs Managed Instance

Lab:

• Create Azure SQL Database
• Configure basic settings
• Connect using SQL tools

Outcome:
Understand Azure SQL deployment models.

Module 2: Deploy and Configure Azure SQL Resources

Topics Covered:

• Provisioning databases
• Scaling and configuring compute/storage
• Automating deployments

Lab:

• Deploy Azure SQL Managed Instance
• Configure firewall and networking
• Automate deployment using scripts

Outcome:
Deploy and configure SQL resources efficiently.

Module 3: Security and Access Control

Topics Covered:

• Authentication and authorization
• Azure Active Directory integration
• Data encryption

Lab:

• Configure Azure AD authentication
• Implement role-based access
• Enable Transparent Data Encryption (TDE)

Outcome:
Secure database environments.

Module 4: Monitor and Optimize Performance

Topics Covered:

• Performance monitoring tools
• Query performance tuning
• Indexing strategies

Lab:

• Monitor database performance
• Identify slow queries
• Optimize indexes and execution plans

Outcome:
Improve database performance.

Module 5: High Availability and Disaster Recovery

Topics Covered:

• Backup and restore
• Geo-replication
• Failover groups

Lab:

• Configure automated backups
• Set up geo-replication
• Perform failover testing

Outcome:
Ensure data availability and resilience.

Module 6: Automate Database Tasks

Topics Covered:

• Automation using Azure tools
• Scheduled jobs and maintenance
• Alerts and notifications

Lab:

• Configure automated maintenance tasks
• Set alerts for performance issues
• Use automation scripts

Outcome:
Automate routine database operations.

Module 7: Data Migration to Azure SQL

Topics Covered:

• Migration strategies
• Tools (Azure Database Migration Service)
• Online vs offline migration

Lab:

• Migrate on-premises database to Azure
• Validate migrated data
• Optimize post-migration performance

Outcome:
Successfully migrate databases to Azure.

Module 8: Monitoring, Security, and Compliance

Topics Covered:

• Auditing and threat detection
• Compliance standards
• Data protection

Lab:

• Enable auditing and logging
• Detect security threats
• Review compliance reports

Outcome:
Maintain secure and compliant systems.