Planning and Designing Databases on AWS

Price
$2,025.00 USD

Duration
3 Days

Delivery Methods
Virtual Instructor Led
Private Group

Add Exam Voucher
$300.00

Request More Information

Download Course Details

Course Details Only
Course Details & Schedule

Skip to Class Dates

Course Overview

Choosing the right database service can make or break your cloud architecture. Planning and Designing Databases on AWS gives you the knowledge and hands-on experience to design data solutions that align with your application’s performance, scalability, and cost requirements.

You’ll explore the process of planning and designing both relational and nonrelational databases on AWS. Learn the trade-offs of hosting on Amazon EC2 versus using fully managed services, and dive deep into AWS database offerings including Amazon RDS, Aurora, Redshift, DocumentDB, DynamoDB, ElastiCache, Neptune, and QLDB.

By the end of the course, you’ll understand the unique capabilities of each service, how to evaluate them for specific workloads, and how to build secure, optimized, and future-ready database solutions in the cloud.

Course Objectives

By the end of the Planning and Designing Databases on AWS course, you’ll understand how to apply core database concepts and data modeling techniques within the AWS ecosystem. You'll evaluate the pros and cons of hosting databases on Amazon EC2 versus AWS-managed services and learn how to design using Amazon RDS, Aurora, Redshift, DocumentDB, DynamoDB, Neptune, ElastiCache, and QLDB. You'll also learn how to apply service-specific management principles and select the right database solutions based on business and technical requirements.

Who Should Attend?

Data platform engineers, Database administrators, Solutions architects, IT professionals

Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

What is the Planning and Designing Databases on AWS course?

This course teaches professionals how to plan, design, and evaluate AWS database services, including both relational and nonrelational options like RDS, Aurora, DynamoDB, and Redshift.

How does Planning and Designing Databases on AWS benefit me?

It gives you the knowledge to confidently architect and select the right AWS database solutions based on technical needs, performance, and scalability—helping you make cost-effective and future-proof design decisions.

How does this course help with database design on AWS?

You’ll gain a clear understanding of how to match specific AWS database services to different workload requirements, use case scenarios, and performance goals.

Can I use this course to prepare for an AWS certification?

While it’s not directly tied to an exam, the course provides foundational knowledge useful for certifications like AWS Certified Database – Specialty or AWS Solutions Architect certifications.

Is private group training available for this course?

Yes, we offer private team training tailored to your organization's schedule and goals. Contact us to learn more.

Course Prerequisites

Relational Database experience
Understanding of AWS foundational services: EC2, VPC, IAM
Attended one of Architecting on AWS, Developing on AWS, or Systems Operations on AWS

Agenda

1 – Planning and Designing Databases on AWS
Course overview, structure, and database design goals
Introduction to AWS’s portfolio of database services
2 – Database Concepts and General Guidelines
Review of relational and nonrelational database fundamentals
Best practices for cloud-native database design
3 – Database Planning and Design
Workload assessment and design decision-making
Key criteria: performance, cost, scalability, and availability
4 – Databases on Amazon EC2
Self-managed databases on EC2: when and why
Trade-offs vs managed services
Cost, maintenance, and availability considerations
5 – Purpose-Built Databases on AWS
Overview of AWS’s purpose-built database strategy
Matching use cases to services (key-value, document, graph, etc.)
6 – Amazon RDS
Features and capabilities of Amazon RDS
Supported engines and deployment models
Use cases for managed relational databases
7 – Amazon Aurora
Aurora architecture and performance benefits
Aurora MySQL vs Aurora PostgreSQL
Replication, backups, and high availability
8 – Amazon DocumentDB (with MongoDB compatibility)
Designing document-based applications
Scaling and querying document data
Differences between DocumentDB and MongoDB
9 – Amazon DynamoDB
Key-value and NoSQL data models
Partitioning, throughput, and access patterns
Design best practices for performance and cost
10 – Amazon Neptune
Graph database use cases and data models
Working with Gremlin and SPARQL queries
Design considerations for connected data
11 – Amazon Quantum Ledger Database (QLDB)
Immutable ledger design and cryptographic verification
Use cases for financial records, supply chains, and auditing
How QLDB differs from blockchain and relational models
12 – Amazon ElastiCache
In-memory caching with Redis and Memcached
Boosting performance and reducing database load
Common caching patterns and considerations
13 – Amazon Redshift
Data warehousing and analytics at scale
Columnar storage and performance optimization
Redshift Spectrum and integration with AWS services
14 – Course Review and Design Application
Recap of all AWS database services
Workload matching and final design scenarios
Q&A and review exercises

Get in touch to schedule training for your team
We can enroll multiple students in an upcoming class or schedule a dedicated private training event designed to meet your organization’s needs.