Module 5: High Availability and Disaster Recovery (2 hours)

• Geo-replication and failover groups.
• Disaster recovery design strategies.
• Backup and restore strategies.
• Hands-on Lab: Configuring high availability and disaster recovery.

Module 6: Advanced Monitoring and Alerts (2 hours)

• Azure Monitor, Log Analytics, and Application Insights.
• Setting up alerts and performance baselines.
• Diagnosing and troubleshooting issues.
• Hands-on Lab: Monitoring SQL Azure using Azure tools.

Module 7: Integrating SQL Azure with Other Azure Services (2 hours)

• Connecting SQL Azure with:
  • Azure Data Factory
  • Azure Functions
  • Azure Logic Apps
• Using Azure Synapse Analytics for data analysis.
• Hands-on Lab: Integrating SQL Azure with Azure services.

Module 8: Advanced Query Tuning and Index Management (2 hours)

• Query execution plans deep dive.
• Advanced indexing techniques: Filtered Indexes, Columnstore Indexes.
• Managing statistics and query stores.
• Hands-on Lab: Advanced query optimization and index tuning.