Administering Relational Databases on Microsoft Azure

• Experience with relational database concepts and SQL
• Familiarity with database administration fundamentals
• Basic understanding of cloud computing and Azure

Audience

• Database administrators managing cloud-hosted relational databases
• IT professionals transitioning on-premise databases to Azure
• Cloud engineers and architects supporting database operations

Microsoft Azure is a cloud computing platform that supports hosting, managing, and optimizing relational database workloads through services like Azure SQL Database and SQL Managed Instance.

This instructor-led, live training (online or onsite) is aimed at intermediate-level database administrators and IT professionals who wish to learn how to provision, manage, monitor, and secure relational databases on Azure.

By the end of this training, participants will be able to:

• Provision Azure SQL resources including single databases, elastic pools, and managed instances.
• Configure high availability, disaster recovery, and automated backups.
• Monitor and tune performance using built-in tools and telemetry.
• Implement security controls, authentication, and auditing in cloud database environments.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Introduction to Azure Database Services

• Overview of Azure SQL family: SQL Database, Managed Instance, SQL Server on VM
• Understanding service tiers and pricing models
• Use cases for cloud-hosted relational databases

Provisioning and Configuration

• Creating Azure SQL resources using portal and templates
• Configuring elastic pools and managed instances
• Managing firewall rules and connectivity

Backup, Restore, and High Availability

• Understanding built-in backup and restore features
• Enabling geo-replication and failover groups
• Implementing high availability and DR strategies

Monitoring and Performance Tuning

• Using Query Performance Insight and Extended Events
• Optimizing indexes and reviewing query plans
• Telemetry, alerts, and resource consumption analysis

Security and Compliance

• Implementing authentication (SQL and Azure AD)
• Managing encryption, auditing, and threat detection
• Securing data access and enforcing role-based security

Automation and Maintenance

• Automating routine tasks with Azure Automation and Runbooks
• Scheduling jobs with Elastic Jobs Agent
• Database updates, patching, and SLA considerations

Summary and Next Steps

• Reviewing key takeaways and best practices
• Exploring certification options (e.g., DP-300)
• Resources for ongoing learning