Planning and Designing Databases on AWS (PD-DB)

Detailed Course Outline

Day One

Module 1: Database concepts and general guidelines

• Databases in the cloud
• Database design principles
• Transactional compliance

Module 2: Database planning and design

• Workload requirements
• Design considerations

Module 3: Databases on Amazon EC2

• Amazon EC2 for hosting databases

Module 4: Purpose-built databases databases on Amazon EC2 and Amazon RDS

• The journey to AWS
• Data modeling basics

Module 5: Amazon RDS

• Amazon RDS overview
• Amazon RDS distinguishing features
• Amazon RDS design considerations
• Hands-on Lab: working with Amazon RDS databases

Module 6: Amazon Aurora

• Amazon Aurora overview
• Amazon Aurora distinguishing features
• Amazon Aurora design considerations

Day Two

Module 6: Amazon Aurora (continued)

• Hands-on Lab: working with Amazon Aurora databases

Module 7: Amazon DocumentDB (with MongoDB compatibility)

• Amazon DocumentDB overview
• Amazon DocumentDB design considerations
• Amazon DocumentDB distinguishing features
• Hands-on Lab: working with Amazon DocumentDB databases

Module 8: Amazon DynamoDB

• Amazon DynamoDB overview
• Amazon DynamoDB data modeling
• Amazon DynamoDB distinguishing features
• Amazon DynamoDB design considerations
• Hands-on Lab: working with Amazon DynamoDB

Day Three

Module 9: Databases in Amazon Neptune

• Amazon Neptune overview
• Amazon Neptune design considerations

Module 10: Databases in Amazon Quantum Ledger Database (Amazon QLDB)

• Amazon QLDB overview
• Amazon QLDB Design Considerations

Module 11: Databases in Amazon ElastiCache

• Amazon ElastiCache overview
• Amazon ElastiCache for Memcached
• Amazon ElastiCache for Redis

Module 12: Data warehousing in Amazon Redshift

• Amazon Redshift overview
• Amazon Redshift distinguishing features
• Amazon Redshift data modeling
• Amazon Redshift design considerations
• Hands-on Lab: working with Amazon Redshift Clusters

Module 13: Course Overview