Course Content
Section outline
-
Module 1: Introduction to Advanced SQL Azure (1 hour)
- Overview of SQL Azure architecture.
- Service tiers and performance levels.
- Configuring and managing SQL Azure databases.
- Hands-on Lab: Setting up SQL Azure environments.
Module 2: Performance Tuning and Optimization (2 hours)
- Query performance insights and recommendations.
- Indexing strategies and query optimization techniques.
- Elastic pools and database scaling.
- Hands-on Lab: Optimizing SQL Azure performance.
Module 3: Security Enhancements in SQL Azure (2 hours)
- Advanced security features: Always Encrypted, Dynamic Data Masking.
- Implementing Row-Level Security and Data Classification.
- Threat detection and auditing.
- Hands-on Lab: Configuring advanced security settings.
Module 4: Automation and Scripting with SQL Azure (2 hours)
- Using Azure Automation for database tasks.
- PowerShell and Azure CLI integration.
- Automating backups and restores.
- Hands-on Lab: Automating SQL Azure tasks.
-
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.
