Administering Relational Databases on Microsoft Azure Training Course

Introduction to Azure Database Services

• Survey of the Azure SQL suite: SQL Database, Managed Instance, and SQL Server on VM.
• Comprehending service tiers and pricing structures.
• Application scenarios for cloud-hosted relational databases.

Provisioning and Setup

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

Backup, Restoration, and High Availability

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

Surveillance and Performance Optimization

• Leveraging Query Performance Insight and Extended Events.
• Refining indexes and analyzing query execution plans.
• Analyzing telemetry, alerts, and resource usage patterns.

Security and Compliance

• Applying authentication methods (SQL and Azure AD).
• Overseeing encryption, auditing, and threat identification.
• Safeguarding data access and enforcing role-based security.

Automation and Maintenance

• Streamlining routine duties using Azure Automation and Runbooks.
• Planning tasks with the Elastic Jobs Agent.
• Managing database updates, patches, and SLA considerations.

Conclusion and Future Pathways

• Recap of primary insights and best practices.
• Exploring certification opportunities (e.g., DP-300).
• Resources for continuous professional development.