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.

 

 

 

 

 

Click here Start

 

 

 

 

 

 

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