Course description

Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloudbased data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3. Additionally, this course demonstrates how to use Amazon QuickSight to perform analysis on your data.

Course level: Intermediate

Duration 3 days

Activities

This course includes presentations, group exercises, and hands-on labs.

Intended audience

This course is intended for:

• Database Architects
• Database Administrators
• Database Developers
• Data Analysts
• Data Scientists

Prerequisites

We recommend that attendees of this course have:

• Taken AWS Technical Essentials (or equivalent experience with AWS)
• Familiarity with relational databases and database design concepts

Course Outline

• Module 1: Introduction to Data Warehousing
• Module 2: Introduction to Amazon Redshift
• Module 3: Launching clusters
• Module 4: Designing the database schema
• Module 5: Identifying data sources
• Module 6: Loading data
• Module 7: Writing queries and tuning for performance
• Module 8: Amazon Redshift Spectrum
• Module 9: Maintaining clusters
• Module 10: Analyzing and visualizing data