Planning and Designing Databases on AWS

Program Code: 3032

Overview
Schedule classes
What you'll learn
Outline
Prerequisites
Who should attend
Certification

Overview

The Amazon Web Services (AWS) authorized Planning & Designing Databases on AWS training course discusses the process of planning and designing both relational and non-relational AWS databases. The course will teach participants how to use workload requirements to define database design considerations. This official AWS course explores the features and capabilities of the eight AWS database services. The course aims to equip participants with the required skills and knowledge to determine which AWS service is right for the workloads as well as how to design the database to meet individual requirements.

Schedule Classes

Looking for more sessions of this class?

Course Delivery

This course is available in the following formats:

Live Classroom
Duration: 3 days

Live Virtual Classroom
Duration: 3 days

What You'll learn

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

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: -built databases on Amazon EC2 and Amazon RDS

The journey to AWS
Data modeling basics

Module 5: Amazon RDS

Overview of Amazon RDS
Distinguishing features of Amazon RDS
Design considerations of Amazon RDS
Lab: Working with Amazon RDS databases

Module 6: Amazon Aurora

Overview of Amazon Aurora
Distinguishing features of Amazon Aurora
Design considerations of Amazon Aurora
Lab: Working with Amazon Aurora databases

Module 7: Amazon DocumentDB (with MongoDB compatibility)

Overview of Amazon DocumentDB
Design considerations of Amazon DocumentDB
Distinguishing features of Amazon DocumentDB
Lab: Working with Amazon DocumentDB databases

Module 8: Amazon DynamoDB

Overview of Amazon DynamoDB
Design considerations of Amazon DynamoDB
Distinguishing features of Amazon DynamoDB
Lab: Working with Amazon DynamoDB

Module 9: Databases in Amazon Neptune

Overview of Amazon Neptune
Design considerations of Amazon Neptune

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

Overview of Amazon QLDB
Design considerations of Amazon QLDB

Module 11: Databases in Amazon Elasticache

Overview of Amazon Elasticache
Amazon Elasticache for Memcached
Amazon Elasticache for Redis

Module 12: Database Warehousing in Amazon Redshift

Overview of Amazon Redshift
Distinguishing features of Amazon Redshift
Amazon Redshift data modeling
Design considerations of Amazon Redshift
Lab: Working with Amazon Redshift clusters

Prerequisites

To attend this course, participants need to have:

Basic Linux administration experience
Basic network administration experience
Basic knowledge of containers and Kubernetes
Completed the Amazon Elastic Kubernetes Service Primer
Completed the AWS Cloud Practitioner Essentials course or have equivalent real-world experience