Module 7: Databases

Relational Database

Stores data in a way that relates pieces of data to each other using rows, columns, and SQL. Ideal for structured data management.

Structured Query Language (SQL)

A programming language used to store, manage, and query data in a relational database. Works with MySQL, PostgreSQL, SQL Server, Oracle, etc.

Amazon Relational Database Service (RDS)

Handles routine database tasks like backups, patching, provisioning. Supports multiple instance types and engines (Aurora, MySQL, PostgreSQL, SQL Server, MariaDB, Oracle).

Amazon Aurora

A managed relational database compatible with MySQL and PostgreSQL. Provides high performance, auto-scaling, multi-AZ replication, backups, and encryption at rest.

AWS Database Migration Service (DMS)

Migrates relational databases, data warehouses, NoSQL databases, and more into AWS or between cloud and on-premises setups.

NoSQL Database

Uses key-value pairs instead of rows/columns. Organizes data as items with unique keys, offering flexibility and scalability.

Amazon DynamoDB

Fully managed NoSQL database with fast, predictable performance. Handles document and key-value data. Ideal for high-performance applications with flexible schema and seamless scaling.

In-Memory Cache

A high-speed storage layer that stores frequently accessed data in RAM, enabling near-instant data retrieval and reducing pressure on the primary database.

Amazon ElastiCache

Fully managed in-memory caching service supporting Redis, Valkey, and Memcached. Handles node replacement, offers consistent performance, and scales workloads easily.

Amazon DocumentDB

Fully managed document database compatible with MongoDB, designed for JSON-like documents and dynamic schemas.

Amazon Neptune

Fully managed graph database for highly connected data like social networks. Provides automatic failover, backups, and high performance for complex relationship queries.

AWS Backup

Provides a single dashboard to monitor and manage backups across AWS services (EBS, EFS, databases). Simplifies data protection and centralizes backup strategy.