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
- Comprehensive overview of the Azure SQL portfolio, including SQL Database, Managed Instance, and SQL Server on Virtual Machines
- An analysis of service tiers and associated pricing frameworks
- Application scenarios for cloud-hosted relational database solutions
Provisioning and Configuration
- Deployment of Azure SQL resources via the Azure portal and infrastructure-as-code templates
- Configuration of elastic pools and managed instances to optimize resource allocation
- Administration of firewall configurations and network connectivity protocols
Backup, Restore, and High Availability
- Utilization of native backup and restoration capabilities
- Implementation of geo-replication and failover groups to ensure data resilience
- Development of robust high availability and disaster recovery strategies for critical systems
Monitoring and Performance Tuning
- Leveraging Query Performance Insight and Extended Events for diagnostics
- Optimization of database indexes and analysis of query execution plans
- Maintenance of telemetry streams, alerting mechanisms, and resource utilization assessments
Security and Compliance
- Establishment of authentication protocols for both SQL and Azure Active Directory environments
- Management of encryption standards, audit trails, and threat detection systems
- Enforcement of secure data access policies and role-based security controls
Automation and Maintenance
- Execution of routine administrative tasks through Azure Automation and Runbooks
- Scheduling of cross-database jobs using the Elastic Jobs Agent
- Management of database updates, patching cycles, and adherence to service level agreements
Summary and Next Steps
- Recapitulation of key takeaways and operational best practices
- Identification of relevant certification pathways (e.g., DP-300) for professional development
- Compilation of resources supporting continuous learning and technical proficiency
Requirements
- Proficiency in relational database architecture and Structured Query Language (SQL)
- Knowledge of core database administration principles
- Familiarity with cloud computing frameworks, specifically Microsoft Azure
Target Audience
- Database administrators overseeing cloud-hosted relational data systems
- Information technology personnel facilitating the migration of on-premises databases to Azure environments
- Cloud engineers and architects providing operational support for database infrastructure
28 Hours
