AWS RDS and Data Migration Assistant

Dive deep into AWS RDS with this comprehensive, hands-on course! We'll cover a wide range of topics, constantly updated to reflect the latest AWS features. This course focuses on practical application, equipping you with the skills to handle diverse database scenarios.

Here's a detailed look at what you'll learn:

• Getting Started with AWS RDS: Learn to create and manage RDS instances and host a website on them.
• Understanding AWS Database Options: Gain an overview of various AWS RDS database engines, including:
  • MySQL RDS: A detailed look at AWS MySQL RDS.
  • Aurora: Explore the capabilities of Aurora, a MySQL and PostgreSQL-compatible relational database.
  • Redshift: Understand Redshift for data warehousing and analytics.
  • DynamoDB: Learn about DynamoDB, a NoSQL database.
  • Elastic Cache: Discover Elastic Cache for caching data.
  • Multi-AZ Deployment: Implement Multi-AZ deployments for high availability.
  • Backups & Read Replicas: Master backups and read replicas for data protection and scalability.
• Oracle RDS Administration: Cover daily tasks in AWS RDS Oracle environments.
• Data Integration with S3: Explore AWS RDS Oracle to S3 integration for data archiving and analytics.
• Data Migration Strategies: Master various data migration methods using AWS Data Migration Service (DMS):
  • DMS Fundamentals: A theoretical introduction to AWS DMS.
  • Full Load Migration: Perform full load migrations with DMS.
  • Replication & Migration: Implement replication and migration using DMS.
  • Heterogeneous Migration: Handle heterogeneous migrations using AWS SCT and DMS.
  • S3 Integration for Migration: Migrate data using S3 integration.
• Oracle RAC on AWS: Learn to host Oracle RAC on AWS by:
  • Creating Oracle RAC in EC2.
  • Administering Oracle RAC in EC2. (This is included to broaden your skillset beyond RDS).
• CNAME Records for Upgrades: Understand the role of CNAME records in simplifying and accelerating upgrade processes.
• Major Version Upgrades: Execute AWS RDS major version upgrades with minimal downtime.
• Snapshot Management: Learn about snapshots:
  • Transferring Encrypted Snapshots: Transfer encrypted snapshots to other accounts for restoration.
  • Exporting Snapshot Data: Export DB snapshot data to Amazon S3.
• Lift and Shift Migration: Implement lift and shift migrations to AWS.
• Alerting & Monitoring: Set up alert notifications for errors in AWS RDS logs.
• Oracle Replicas: Implement Oracle Replica on AWS RDS.
• Custom RDS Instances: Manage Custom RDS instances, including:
  • Custom RDS Creation & Restore: Oracle Custom RDS Snapshot and Restore.
  • Custom RDS Read Replicas: Implement Oracle Custom RDS Read Replica.
• High Availability with Multi-AZ: Leverage AWS Multi-AZ DB Clusters for enhanced availability.
• External Replication: Implement external replication in AWS RDS MySQL.
• RDS Proxy: Understand and utilize RDS Proxy for connection pooling and improved performance.
• Security Best Practices: Learn how to disable and create AWS Access Keys securely.
• Cost Optimization: Utilize the AWS Pricing Calculator to estimate and manage costs.

This course is regularly updated to reflect the latest advancements in AWS RDS, ensuring you stay current with the most effective database solutions.