Amazon Web Services Databases in Depth By Richard SeroterLearn how to incorporate Amazon RDS, DynamoDB, and Redshift into your data-driven applications. Explore each database and learn how to use it effectively.
This course will walk you through three major databases from Amazon Web Services. For each database, we will review core use cases, native capabilities, and how to build and configure instances for maximum performance and availability. Students will integrate the databases into a pre-built web application to see a practical example of each service in action.
Getting Started
Introduction 1m
About Amazon Databases 1m
Comparing Amazon Databases 3m
Demo: Exploring the Management Console 3m
Database Pricing 4m
Additional Database Charges 2m
Plan for the Course 3m
Sample Application 3m
Demo: Exercise Setup 3m
Summary 1m
Amazon RDS – Creating Instances, Loading Data
Introduction 2m
What Is RDS? 2m
Native Capabilities 3m
What Aspects Are 'Managed'? 2m
Supported RDS Databases 1m
RDS Storage Options 3m
Creating Instances and Upfront Choices 3m
Database Engine Options 2m
Demo: Creating a MySQL Database Instance 5m
IAM Policies 2m
Security Groups 2m
Demo: Securing the Database Instance 1m
Connecting to an Instance 2m
App Table Schemas 1m
Demo: Connect to Instances and Create Tables 3m
Importing Data 4m
Demo: Importing Flat File Data 9m
Summary 2m
Amazon RDS – Lifecycle Activities
Introduction 1m
Backup and Restore 3m
Demo: Restoring a Backup 7m
Working with Snapshots 3m
Demo: Creating and Restoring a Snapshot 2m
Database Scaling 1m
Scaling Databases Up 2m
Demo: Resizing a Database Instance 3m
Read Replicas 6m
Demo: Creating and Testing a Read Replica 6m
High Availability via Multi-AZ Deployment 5m
Demo: Configuring and Testing a Multi-AZ Deployment 6m
Scaling Recap 1m
Using Database Logs 3m
Monitoring RDS 1m
Demo: Reviewing RDS Monitoring Options 5m
Upgrading Database Instances 3m
Summary 1m
Amazon DynamoDB – Creating and Querying
Introduction 2m
NoSQL Database Categories 3m
DynamoDB Defined 0m
Core Concepts 2m
Native Capabilities 3m
DynamoDB Data Model 1m
What Aspects Are 'Managed'? 1m
Creating Tables 2m
Attribute Data Types 2m
Understanding Throughput Units 5m
How Partitioning Works 4m
Table Design Considerations 3m
App Table Structure 1m
Demo: Creating a DynamoDB Table 3m
Loading Data 2m
Demo: Importing Data into Tables 3m
Creating and Updating Items 2m
Demo: Creating and Updating Items 9m
Query and Scan 3m
Demo: Retrieving Data 3m
Summary 1m
Amazon DynamoDB – Tuning and Scaling
Introduction 1m
IAM Policies 2m
Demo: Applying Security 5m
Purpose of Secondary Indexes 1m
Global Secondary Index 3m
App Table Structure 1m
Demo: Adding and Querying a Global Secondary Index 11m
Local Secondary Index 2m
Differences Between Global and Local Secondary Indexes 2m
Scaling Tables 1m
Monitor with CloudWatch 2m
Demo: Reviewing DynamoDB CloudWatch Metrics 3m
Summary 1m
Amazon Redshift – Creating Clusters and Databases
Introduction 2m
What Is Redshift? 0m
About Data Warehouses 2m
Core Concepts 2m
Native Capabilities 2m
Redshift Architecture 3m
Columnar Data Storage 2m
Creating Redshift Clusters 3m
Cluster Creation Considerations 1m
Demo: Create a Redshift Cluster 3m
Redshift Security 2m
Demo: Applying Security to Redshift 2m
Redshift Encryption Support 3m
Connecting from Client Tools 1m
Demo: Connecting from Client Tools 2m
Redshift Tables 5m
Best Practices 3m
App Data Warehouse Table Structure 1m
Demo: Creating Redshift Tables 4m
Summary 1m
Amazon Redshift – Data Loading and Managing
Introduction 1m
Loading Data from Integrated Data Sources 2m
Role of Data Pipeline 1m
Best Practices for Data Loading 2m
Demo: Loading Data into Redshift 9m
Differences from PostgreSQL 3m
Demo: Querying Redshift 4m
Creating and Managing Snapshots 4m
Demo: Creating a Snapshot 3m
Resizing Redshift Clusters 3m
Demo: Resizing a Cluster 3m
Setting up CloudWatch Alarms 1m
VIewing Query and Performance Metrics 1m
Demo: Reviewing Monitoring Metrics 4m
Summary2m