Important Planning and Designing Databases with AWS Course Information
Requirements
We recommend that attendees of this course have the following prerequisites:
- Familiarity with AWS Database Services, equivalent to AWS Database Offerings digital training
- Understanding of database design concepts, and/or data modeling for relational or nonrelational databases
- Familiarity with cloud computing concepts
- Familiarity with general networking and encryption concepts
- Understanding of the three V’s of data (volume, velocity, and variety)
- Familiarity with basic data analytics concepts, equivalent to Data Analytics Fundamentals digital training
- Understanding of general architecting best practices and the AWS Well-Architected Framework, equivalent to Architecting on AWS classroom training
Who Should Attend This Course
- Data Engineers who are new to designing cloud databases or nonrelational databases
- Solutions Architects who are designing services or architectures that are integrated with databases
- Developers that are building cloud database-enabled applications
Course Outline
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 on Amazon EC2 and Amazon RD2
- 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 Aura
- Amazon Aurora overview
- Amazon Aurora distinguishing features
- Amazon Aurora design considerations
- 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
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