Amazon RDS

Amazon Relational Database Service (Amazon RDS) allows easily to set up, operate, and scale a relational database in the cloud.

• Fully managed service for relational databases
• Handles provisioning, patching, backup, and recovery of your database
• Supports deployment across multiple availability zones (multi-AZ)
• Some platforms support read replicas Launches into a VPC
• Provides both general purpose SSD and provisioned IOPS SSD drive options
• Amazon RDS platforms: MySQL, PostgresSQL, MariaDB, Oracle Database, SQL Server

Use cases

• All database related use cases, with elasticity, high availability, and reliability of cloud.

Demo

• Create Amazon RDS
• Connect to Amazon RDS from EC2 instance using Jupyter notebook

Challenge

• Upload marketing data & notebook to AWS EC2 Jupyter Server
• Run the EDA notebook on EC2
• Update EDA notebook to load marketing data from ai-academy-2022 S3 bucket using Python SDK
• Load marketing data into RDS