Azure SQL Database Admin Online Training Course

Course Content

1. Introduction to Azure SQL Database

• Overview of Azure SQL Database

• Azure SQL Database architecture and components

• Benefits of using Azure SQL Database

2. Azure SQL Database Administration Basics

• Creating and managing Azure SQL Databases

• User management and access control

• Security groups and network configuration

• Backing up and restoring databases

3. Performance Tuning and Optimization

• Monitoring database performance

• Query optimization

• Indexing and partitioning

• Scaling Azure SQL Databases

4. High Availability and Disaster Recovery for Azure SQL Database

• Geo-Replication for high availability

• Failover and recovery strategies

• Azure Backup for Azure SQL Database

5. Advanced Azure SQL Database Administration

• Database migration to Azure SQL Database

• Azure SQL Database Managed Instance deployment

• Integration with Azure Monitor

• Advanced security features

6. Conclusion and Resources

• Review of key concepts and skills

• Best practices for Azure SQL Database administration