Administering Relational Databases on Microsoft Azure Training Course

Introduction to Azure Database Services

• Overview of the Azure SQL family, including SQL Database, Managed Instance, and SQL Server on VM.
• Understanding service tiers and associated pricing models.
• Key use cases for deploying cloud-hosted relational databases.

Provisioning and Configuration

• Creating Azure SQL resources using the portal and resource templates.
• Configuring elastic pools and setting up managed instances.
• Managing firewall rules and network connectivity.

Backup, Restore, and High Availability

• Understanding native backup and restore features.
• Enabling geo-replication and establishing failover groups.
• Implementing high availability and disaster recovery strategies.

Monitoring and Performance Tuning

• Leveraging Query Performance Insight and Extended Events for analysis.
• Optimizing indexes and reviewing query execution plans.
• Analyzing telemetry, alerts, and resource consumption patterns.

Security and Compliance

• Implementing authentication methods via SQL and Azure AD.
• Managing encryption, auditing logs, and threat detection capabilities.
• Securing data access and enforcing role-based security models.

Automation and Maintenance

• Automating routine operational tasks using Azure Automation and Runbooks.
• Scheduling jobs efficiently with the Elastic Jobs Agent.
• Handling database updates, patching, and SLA considerations.

Summary and Next Steps

• Reviewing key takeaways and industry best practices.
• Exploring relevant certification options, such as DP-300.
• Identifying resources for continuous professional learning.