Data Warehousing on AWS

Unlock the power of cloud-based data warehousing with our specialized course on AWS Redshift, designed for database architects, administrators, and data analysts to enhance your data strategy and business intelligence capabilities.

Course Thumbnail

Essential Skills Gained

Checkmark

Design a scalable data warehousing solution using AWS Redshift.

Checkmark

Implement data collection, storage, and preparation using AWS services.

Checkmark

Analyze data with business intelligence tools for informed decision-making.

Checkmark

Understand best practices and strategies for data warehousing on AWS.

Format

  • Instructor-led
  • 3 days with lectures and hands-on labs.

Audience

  • Database architects
  • Database administrators
  • Database developers
  • Data analysts and scientists

Description

In this course, you will learn new concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. You will learn 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.

Calendar icon

Upcoming Course Dates

July 8-10, 2025

6:30 AM - 2:30 PM

Virtual: Online - America/Los_Angeles

Guaranteed to Run

Enroll

$2025

July 15-17, 2025

9:00 AM - 5:00 PM

Virtual: Online - US/Eastern

Enroll

$2025

September 9-11, 2025

6:30 AM - 2:30 PM

Virtual: Online - America/Los_Angeles

Enroll

$2025

Course Outline

Download PDF

Lesson 1: Course Introduction

Lesson 2: Introduction to Data Warehousing

Lesson 3: Introduction to Amazon Redshift

Lesson 4: Understanding Amazon Redshift Components and Resources

Lesson 5: Launching an Amazon Redshift Cluster

Lesson 6: Reviewing Data Warehousing Approaches

Lesson 7: Identifying Data Sources and Requirements

Lesson 8: Designing the Data Warehouse

Lesson 9: Loading Data into the Data Warehouse

Lesson 10: Writing Queries and Tuning Performance

Lesson 11: Maintaining the Data Warehouse

Lesson 12: Analyzing and Visualizing Data

Lesson 13: Course Summary

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.