Visão Geral

O curso Amazon RDS oferece uma visão completa do serviço de banco de dados relacional da Amazon Web Services (AWS), capacitando os alunos a criar, gerenciar e escalar bancos de dados na nuvem de forma eficiente. Os participantes aprenderão sobre as principais funcionalidades do Amazon RDS, incluindo a configuração, monitoramento, segurança e otimização de bancos de dados relacionais.

Objetivo

Após realizar o curso Amazon RDS, você será capaz de:

• Configurar, gerenciar e otimizar bancos de dados utilizando o Amazon RDS.
• Implementar práticas de segurança, backup e recuperação em ambientes RDS.
• Escalar e monitorar bancos de dados para melhor desempenho e custo-benefício.

Publico Alvo

Este Curso Amazon RDS é indicado para administradores de banco de dados (DBAs), engenheiros de dados, desenvolvedores e arquitetos de soluções que desejam aprender a utilizar o Amazon RDS para gerenciar bancos de dados de maneira escalável e eficiente na nuvem.

Pre-Requisitos

• Conhecimentos básicos sobre bancos de dados relacionais.
• Experiência prévia com AWS é recomendada, mas não obrigatória.
• Familiaridade com SQL e administração de bancos de dados é um diferencial.

Materiais

Conteúdo Programatico

Introduction to Amazon RDS

1. Overview of Amazon RDS and its role in cloud databases.
2. Benefits and use cases of Amazon RDS.
3. Supported database engines (MySQL, PostgreSQL, MariaDB, Oracle, SQL Server).

Setting Up Your First RDS Database

1. Step-by-step guide to creating a new RDS instance.
2. Configuring RDS settings: instance types, storage options, and pricing.
3. Understanding the RDS console and essential configurations.

RDS Security and Access Control

1. Configuring VPC security groups and IAM roles.
2. Implementing encryption at rest and in transit.
3. Best practices for access management and database security.

Backup and Recovery in Amazon RDS

1. Automatic backups and snapshot configuration.
2. Restoring from a snapshot and point-in-time recovery.
3. Implementing disaster recovery strategies.

Scaling and Performance Optimization

1. Vertical and horizontal scaling in RDS.
2. Read replicas and cross-region replication.
3. Optimizing instance types and storage for performance.

Monitoring and Logging in Amazon RDS

1. Using Amazon CloudWatch for performance metrics.
2. Enabling Enhanced Monitoring and RDS Performance Insights.
3. Setting up alarms and custom dashboards for database health.

Database Maintenance and Upgrades

1. Configuring maintenance windows and minor version upgrades.
2. Applying patches and understanding managed updates.
3. Best practices for minimizing downtime during maintenance.

High Availability and Failover

1. Setting up Multi-AZ deployments for high availability.
2. Failover mechanisms and configuring automatic failover.
3. Configuring Amazon Route 53 for DNS failover.

Database Migration to Amazon RDS

1. Using AWS Database Migration Service (DMS) for data migration.
2. Migration from on-premises to RDS.
3. Migrating between different RDS engines and regions.

Cost Management and Optimization

1. Understanding RDS pricing models and cost structures.
2. Using Reserved Instances and savings plans.
3. Strategies for cost-effective RDS usage.