Administering Relational Databases on Microsoft Azure Training Course

Introduction to Azure Database Services

• Overview of the Azure SQL suite: SQL Database, Managed Instance, and SQL Server on VM
• Analyzing service tiers and pricing structures
• Identifying use cases for cloud-based 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

• Exploring native backup and restoration capabilities
• Activating geo-replication and failover groups
• Deploying high availability and disaster recovery strategies

Monitoring and Performance Optimization

• Leveraging Query Performance Insight and Extended Events
• Refining index structures and analyzing query plans
• Interpreting telemetry, alerts, and resource utilization metrics

Security and Compliance

• Deploying authentication methods (SQL and Azure AD)
• Administering encryption, auditing logs, and threat detection
• Protecting data access and enforcing role-based security policies

Automation and Maintenance

• Streamlining routine operations with Azure Automation and Runbooks
• Scheduling tasks using the Elastic Jobs Agent
• Managing database updates, patching cycles, and SLA compliance

Conclusion and Future Pathways

• Summarizing key insights and industry best practices
• Reviewing certification pathways (such as DP-300)
• Accessing resources for continuous professional development