Administering Relational Databases on Microsoft Azure Training Course

Introduction to Azure Database Services

• Overview of the Azure SQL family: SQL Database, Managed Instance, and SQL Server on VM
• Comprehending service tiers and associated pricing models
• Identifying use cases for cloud-hosted relational databases

Provisioning and Configuration

• Creating Azure SQL resources via the portal and templates
• Setting up elastic pools and managed instances
• Administering firewall rules and network connectivity

Backup, Restore, and High Availability

• Understanding native backup and restore capabilities
• Activating geo-replication and failover groups
• Executing high availability and disaster recovery strategies

Monitoring and Performance Tuning

• Leveraging Query Performance Insight and Extended Events
• Refining indexes and analyzing query execution plans
• Analyzing telemetry, alerts, and resource consumption metrics

Security and Compliance

• Establishing authentication methods (SQL and Azure AD)
• Oversight of encryption, auditing, and threat detection systems
• Safeguarding data access and enforcing role-based security protocols

Automation and Maintenance

• Streamlining routine tasks through Azure Automation and Runbooks
• Orchestrating jobs using the Elastic Jobs Agent
• Managing database updates, patching, and SLA considerations

Summary and Next Steps

• Reviewing key learning points and industry best practices
• Exploring relevant certification paths, such as DP-300
• Accessing resources for continued professional development