This course is designed to teach you how to:

• Apply database concepts, database management, and data modelling techniques
• Evaluate hosting databases on Amazon EC2 instances
• Evaluate relational AWS database services and their features (Amazon RDS, Amazon Aurora, and Amazon Redshift)
• Evaluate nonrelational AWS database services and their features (Amazon DocumentDB, Amazon DynamoDB, Amazon ElastiCache, Amazon Neptune, and Amazon QLDB)
• Examine how the design criteria apply to each service
• Apply management principles based on the unique features of each service

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 modelling 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 modelling
  • 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 modelling
  • Amazon Redshift design considerations
  • Hands-on Lab: working with Amazon Redshift Clusters
• Module 13: Course Overview

Instructor-led live training with exercises

Delivered as a live, interactive training: available in-person or online, or in a hybrid format

We recommend that attendees of this course have:

• Understanding of database design concepts, and/or data modelling for relational or non-relational 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.

This course is intended for:

• 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