Amazon Web Services Databases in Depth
Learn how to incorporate Amazon RDS, DynamoDB, and Redshift into your data-driven applications. Explore each database and learn how to use it effectively.
What you'll learn
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.
Table of contents
- 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
- 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
- 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
- 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
- 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
- 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
- Summary 2m
About the author
Richard Seroter is currently the Chief Evangelist at Google Cloud and leads the Developer Relations program. He's also an instructor at Pluralsight, a frequent public speaker, the author of multiple books on software design and development, and a former InfoQ.com editor plus former 12-time Microsoft MVP for cloud. As Chief Evangelist at Google Cloud, Richard leads the team of developer advocates, developer engineers, outbound product managers, and technical writers who ensure that people find, u... more