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
- Analysis of service tiers and associated pricing models
- Identifying use cases for cloud-hosted relational databases
Provisioning and Configuration
- Creating Azure SQL resources via the portal and templates
- Setting up elastic pools and managed instances
- Administering firewall rules and network connectivity
Backup, Restore, and High Availability
- Comprehending built-in backup and restore capabilities
- Activating geo-replication and failover groups
- Executing high availability and disaster recovery strategies
Monitoring and Performance Tuning
- Leveraging Query Performance Insight and Extended Events
- Refining indexes and analyzing query execution plans
- Utilizing telemetry, alerts, and resource consumption analysis
Security and Compliance
- Establishing authentication methods (SQL and Azure AD)
- Oversight of encryption, auditing, and threat detection
- Safeguarding data access and enforcing role-based security
Automation and Maintenance
- Streamlining routine tasks with Azure Automation and Runbooks
- Orchestrating jobs using the Elastic Jobs Agent
- Handling database updates, patching, and SLA considerations
Summary and Next Steps
- Consolidating key takeaways and industry best practices
- Investigating certification pathways (e.g., DP-300)
- Accessing resources for continuous professional development
Requirements
- Practical experience with relational database concepts and SQL.
- Working knowledge of database administration fundamentals.
- Foundational understanding of cloud computing principles and Azure.
Target Audience
- Database administrators overseeing cloud-hosted relational databases.
- IT professionals responsible for migrating on-premise databases to Azure.
- Cloud engineers and architects providing support for database operations.
28 Hours
