Planning and Designing Databases on AWS - Seminar / Kurs von Cegos_Integrata GmbH

• Course Introduction
• AWS Purpose-Built Databases
• Amazon Relational Database Service (Amazon RDS)
• Amazon Aurora
• Amazon DynamoDB
• Amazon Keyspaces (for Apache Cassandra)
• Amazon DocumentDB (with MongoDB compatibility)
• Amazon Quantum Ledger Database (Amazon QLDB)
• Amazon Neptune
• Amazon Timestream
• Amazon ElastiCache
• Amazon MemoryDB for Redis
• Amazon Redshift
• Tools for Working with AWS Databases

• Course overview

• Discussing well-architected databases
• Analyzing workload requirements
• Choosing the data model
• Choosing the right purpose-built database
• Knowledge check

• Discussing a relational database
• What is Amazon RDS?
• Why Amazon RDS?
• Amazon RDS design considerations
• Knowledge check

• What is Amazon Aurora?
• Why Amazon Aurora?
• Aurora design considerations
• Knowledge check

Class Activity 1: Choose the Right Relational Database

• Discussing a key value database
• What is DynamoDB?
• Why DynamoDB?
• DynamoDB design considerations
• Knowledge check

• Discussing a wide-column database
• What is Apache Cassandra?
• What is Amazon Keyspaces?
• Why Amazon Keyspaces?
• Amazon Keyspaces design considerations
• Knowledge check

• Discussing a document database
• What is Amazon DocumentDB?
• Why Amazon DocumentDB?
• Amazon DocumentDB design considerations
• Knowledge check

• Discussing a ledger database
• What is Amazon QLDB?
• Why Amazon QLDB?
• Amazon QLDB design considerations
• Knowledge check

Class Activity 2: Choose the Right Nonrelational Database

Challenge Lab 2: Working with Amazon DynamoDB Tables

• Discussing a graph database
• What is Amazon Neptune?
• Why Amazon Neptune?
• Amazon Neptune design considerations
• Knowledge check

• Discussing a timeseries database
• What is Amazon Timestream?
• Why Amazon Timestream?
• Amazon Timestream design considerations
• Knowledge check

• Discussing an in-memory database
• What is ElastiCache?
• Why ElastiCache?
• ElastiCache design considerations
• Knowledge check

• What is Amazon MemoryDB (for Redis)?
• Why Amazon MemoryDB?
• Amazon MemoryDB design considerations
• Knowledge check

Class Activity 3: Let’s Cache In

• Discussing a data warehouse
• What is Amazon Redshift?
• Why Amazon Redshift?
• Amazon Redshift design considerations
• Knowledge check

• Data access and analysis with Amazon Athena
• Data migration with SCT and DMS

Class Activity 4: Overall Picture

Challenge Lab 3: Working with Amazon Redshift clusters