Data Warehousing on AWS

Course Duration

3 days

Audience

Employees of federal, state and local governments; and businesses working with the government.

Prerequisites

Familiarity with relational databases and database design concepts. Familiarity with cloud computing concepts. At a minimum, the equivalent knowledge gained by attending AWS Technical Essentials.

Course Description

Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based 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 other AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis Firehose, and Amazon S3. Additionally, this course demonstrates how to use business intelligence tools to perform analysis on your data.

Course Outline

Course Topics

• Introduction to Data Warehousing
• Introduction to Amazon Redshift
• Launching Clusters
• Designing the Database Schema
• Identifying Data Sources
• Loading Data
• Writing Queries and Tuning Performance
• Amazon Redshift Spectrum
• Maintaining Clusters
• Analyzing and Visualizing Data