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
- Survey of the Azure SQL family: SQL Database, Managed Instance, and SQL Server on VM.
- Insight into service tiers and pricing structures.
- Application scenarios for cloud-hosted relational databases.
Provisioning and Configuration
- Deployment of Azure SQL resources via the portal and templates.
- Configuration of elastic pools and managed instances.
- Management of firewall rules and connectivity options.
Backup, Restore, and High Availability
- Overview of native backup and restore capabilities.
- Activation of geo-replication and failover groups.
- Implementation of high availability and disaster recovery strategies.
Monitoring and Performance Tuning
- Utilization of Query Performance Insight and Extended Events.
- Index optimization and query plan review.
- 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 systems.
- Securing data access and enforcing role-based security policies.
Automation and Maintenance
- Automation of routine tasks using Azure Automation and Runbooks.
- Scheduling jobs with the Elastic Jobs Agent.
- Handling database updates, patching, and SLA considerations.
Summary and Next Steps
- Review of key takeaways and best practices.
- Exploration of certification pathways (e.g., DP-300).
- Resources for continued learning.
Requirements
- Practical experience with relational database concepts and SQL.
- Familiarity with the fundamentals of database administration.
- A foundational understanding of cloud computing principles and Microsoft Azure.
Target Audience
- Database administrators responsible for cloud-hosted relational databases.
- IT professionals migrating on-premise databases to Azure.
- Cloud engineers and architects involved in supporting database operations.
28 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 6400 € + VAT*
Contact us for an exact quote and to hear our latest promotions
