I. Overview:

In this course, you will learn about planning and designing your solutions with purpose-built Amazon Web Services (AWS) Cloud databases. The course introduces you to the features and characteristics of each of these databases and shares the design considerations that you should make while using them. By taking this course, you can develop the analytical skills needed to choose the right AWS database for your unique needs. By the end of the course, you will be able to analyze a business use case, analyze the workload, and assess application requirements to identify and design the most suitable AWS database solution to support your organizational needs.

II. Duration: 08 hours (1 day)

III. Objectives:

• Summarize the AWS Well-Architected Framework for designing database solutions
• Choose an appropriate purpose-built database service for a given workload
• Design a relational database solution to solve a business problem
• Design a NoSQL database solution to solve a business problem
• Analyze data from multiple databases to solve a business problem
• Discuss the security considerations for your database solution

IV. Intended Audience:

• Solutions architects
• Database architects
• Developers

V. Prerequisites:

• Recommended prerequisites: Familiarity with AWS database services; Understanding databases design concepts and/or data modeling for relational or non-relational databases; Familiarity with cloud computing concepts; Familiarity with general networking and encryption concepts; Completion of the digital course 'Introduction to Building with Databases'

VI. Course outlines:

1. Module 1: AWS Purpose-Built Databases

• Overview
• Well-Architected Database
• Purpose-Built Databases
• Relational and Non-Relational Databases
• Step 1: Analyze Workload Requirements
• Step 2: Choose the Data Model
• Step 3: Choose the Right Purpose-Built Database
• Knowledge Check

2. Module 2: Amazon Relational Database Service (Amazon RDS)

• Overview
• Relational Database Concepts
• Use Cases
• What is Amazon RDS?
• Why Amazon RDS?
• Amazon RDS Design Considerations - DB instances
• Amazon RDS Design Considerations
• Knowledge Check

3. Module 3: Amazon Aurora

• Overview
• What is Aurora?
• Why Aurora?
• Aurora Design Considerations
• Aurora Serverless v2
• Knowledge Check
• Lab 1: Working with Amazon Aurora Databases

4. Module 4: Amazon DynamoDB

• Overview
• Key-Value Database Concepts
• Use Cases
• What is Amazon DynamoDB?
• Why use Amazon DynamoDB?
• DynamoDB Data Modeling and Design Considerations
• Secondary Indexes Design Considerations
• Additional DynamoDB Design Considerations
• Knowledge Check
• Lab 2: Working with Amazon DynamoDB Tables

5. Module 5: Amazon Keyspaces (For Apache Cassandra)

• Overview
• Wide-Column Database Concepts
• Use Cases
• What is Apache Cassandra?
• What is Amazon Keyspaces?
• Why Amazon Keyspaces?
• Keyspaces Data Modeling and Design Considerations
• Additional Keyspaces Design Considerations
• Knowledge Check

6. Module 6: Amazon DocumentDB

• Overview
• Document Database Concepts
• Use Cases
• What is Amazon DocumentDB?
• Why Amazon DocumentDB?
• Amazon DocumentDB Design Considerations
• Demonstrations
• Knowledge Check

7. Module 7: Amazon Neptune

• Overview
• Graph Database Concepts
• Use Cases
• What is Amazon Neptune?
• Why Amazon Neptune?
• Neptune Data Modeling and Design Considerations
• Knowledge Check

8. Module 8: Amazon Timestream

• Overview
• Time-series Introduction
• What is Amazon Timestream?
• Why Use Amazon Timestream?
• Timestream Design Considerations
• Knowledge Check

9. Module 9: Amazon ElastiCache

• Overview
• In-Memory Database Concepts
• Use Cases
• What is Amazon ElastiCache?
• Why Amazon ElastiCache?
• Amazon ElastiCache Design Considerations
• Knowledge Check

10. Module 10: Amazon MemoryDB for Redis

• Overview
• Amazon MemoryDB for Redis
• Use Cases
• Knowledge Check

11. Module 11: Amazon Redshift

• Overview
• Why Use a Data Warehouse?
• What is a Data Warehouse?
• What is Amazon Redshift?
• Why Use Amazon Redshift?
• Amazon Redshift Design Considerations
• Knowledge Check
• Lab 3: Working with Amazon Redshift

12. Module 12: Tools for Working with AWS Databases

• Overview
• Overview of Tools for Working with AWS Databases
• Lab 4: Working with Amazon Athena
• Lab 5: Working with Amazon DocumentDB Databases