Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to Azure Database Services
- Overview of the Azure SQL family: SQL Database, Managed Instance, and SQL Server on VM
- Comprehension of service tiers and pricing structures
- Practical use cases for cloud-hosted relational databases
Provisioning and Configuration
- Creation of Azure SQL resources via the portal and deployment templates
- Configuration of elastic pools and managed instances
- Administration of firewall rules and network connectivity
Backup, Restore, and High Availability
- Understanding integrated backup and restoration capabilities
- Activation of geo-replication and failover groups
- Implementation of high availability and disaster recovery strategies
Monitoring and Performance Optimization
- Utilization of Query Performance Insight and Extended Events
- Index optimization and query plan analysis
- Analysis of telemetry, alerts, and resource consumption
Security and Compliance
- Implementation of authentication methods (SQL and Azure AD)
- Management of encryption, auditing, and threat detection
- Securing data access and enforcing role-based security policies
Automation and Maintenance
- Automation of routine tasks using Azure Automation and Runbooks
- Scheduling of jobs via the Elastic Jobs Agent
- Handling database updates, patching, and SLA considerations
Summary and Future Directions
- Review of key takeaways and industry best practices
- Exploration of certification pathways (e.g., DP-300)
- Access to resources for continuous professional development
Requirements
- Proficiency in relational database concepts and SQL
- Knowledge of database administration fundamentals
- Foundational understanding of cloud computing and the Azure ecosystem
Target Audience
- Database administrators overseeing cloud-hosted relational databases
- IT professionals migrating on-premise databases to Azure
- Cloud engineers and architects responsible for database operations
28 Hours
