Visão Geral

O Curso DP-300T00 Administering Relational Databases on Microsoft Azure prepara profissionais para administrar, proteger, monitorar e otimizar bancos de dados relacionais na plataforma Microsoft Azure, com foco nas soluções do Azure SQL.

O treinamento aborda cenários reais de administração de banco de dados em ambientes IaaS e PaaS, incluindo migração, segurança, alta disponibilidade, automação e performance tuning. É um curso essencial para quem deseja atuar como Azure Database Administrator e se preparar para a certificação DP-300.

Objetivo

Após realizar este Curso DP-300T00 Administering Relational Databases on Microsoft Azure, você será capaz de:

• Administrar bancos de dados no Azure
• Implantar soluções IaaS e PaaS para SQL Server
• Migrar workloads para Azure SQL
• Implementar segurança e compliance
• Monitorar e otimizar performance
• Automatizar tarefas administrativas
• Implementar alta disponibilidade e recuperação de desastres
• Gerenciar backups e restauração

Publico Alvo

• Administradores de banco de dados (DBA)
• Engenheiros de dados
• Profissionais de infraestrutura
• Especialistas em cloud
• Analistas de suporte a banco de dados

Pre-Requisitos

• Conhecimento básico de SQL Server
• Experiência com T-SQL
• Noções de administração de banco de dados
• Conhecimento básico de Azure
• Experiência com portal Azure

Materiais

Conteúdo Programatico

Module 1: Prepare to maintain SQL databases on Azure

1. Explore the role of a database administrator on Azure
2. Describe SQL Server-based offerings on Azure
3. Understand Azure Database Administrator role
4. Compare SQL Server options in Azure
5. Explore Azure SQL platform features

Module 2: Deploy IaaS solutions with Azure SQL

1. SQL Server in IaaS overview
2. Provisioning and deployment options
3. Deploy SQL Server on Azure Virtual Machine
4. Configure VM sizing, storage and networking
5. High availability configuration

Module 3: Deploy PaaS solutions with Azure SQL

1. SQL Server in PaaS overview
2. Provision Azure SQL Database
3. Configure elastic pools
4. Explore Azure SQL Managed Instance
5. Explore Azure SQL Edge
6. Deploy using templates

Module 4: Evaluate strategies for migrating to Azure SQL

1. Migration tools and strategies
2. Compatibility level impact
3. Azure preview features
4. Migration planning

Module 5: Migrate SQL workloads to Azure SQL Databases

1. Migration considerations
2. Offline migration strategies
3. Online migration strategies
4. Post-migration validation
5. Backup, HA, DR and scalability

Module 6: Migrate SQL workloads to Azure Managed Instances

1. Migration scenarios
2. Migration execution
3. Data loading and movement

Module 7: Configure database authentication and authorization

1. Authentication options
2. Security principals
3. Permission management
4. Troubleshooting authentication failures

Module 8: Protect data in-transit and at rest

1. Encryption strategies
2. Firewall rules
3. Always Encrypted
4. TLS implementation
5. SQL Injection concepts

Module 9: Implement compliance controls for sensitive data

1. Data classification
2. Row-level security
3. Dynamic Data Masking
4. Microsoft Defender for SQL
5. Azure SQL Database Ledger

Module 10: Describe performance monitoring

1. Monitoring tools comparison
2. Performance metrics
3. Baseline creation
4. Extended events
5. Intelligent Insights

Module 11: Configure SQL Server resources for optimal performance

1. Azure storage configuration
2. TempDB configuration
3. VM sizing strategies
4. Resource Governor

Module 12: Configure databases for optimal performance

1. Database scoped configuration
2. Index and statistics maintenance
3. Intelligent Query Processing
4. Automatic tuning

Module 13: Explore query performance optimization

1. Execution plans
2. Estimated vs actual plans
3. Query plan generation
4. Query Store
5. Query Store reports

Module 14: Evaluate performance improvements

1. Index optimization
2. Wait statistics
3. Query hints

Module 15: Explore performance-based design

1. Database normalization
2. Data types selection
3. Index types comparison

Module 16: Automate deployment of database resources

1. Deployment models
2. PowerShell and Azure CLI
3. ARM templates
4. Bicep files

Module 17: Create and manage SQL Agent jobs

1. Scheduled tasks
2. Alerts and notifications
3. Performance-based alerts

Module 18: Manage Azure PaaS tasks using automation

1. Azure Policy
2. Azure Automation
3. Elastic jobs
4. Logic Apps

Module 19: Describe high availability and disaster recovery strategies

1. RTO and RPO concepts
2. HA and DR strategies
3. IaaS vs PaaS comparison
4. Strategy design

Module 20: Explore IaaS and PaaS solutions for high availability and disaster recovery

1. WSFC deployment
2. Availability Groups
3. Temporal Tables
4. Geo-replication
5. Auto-failover groups

Module 21: Back up and restore databases

1. Backup strategies for IaaS
2. Backup strategies for PaaS
3. Restore processes
4. Transaction log management