План на курса

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

Изисквания

  • 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
 28 Часа

Брой участници


Цена за участник

Предстоящи Курсове

Свързани Kатегории