Amazon Redshift: Data Warehousing, Step by Step
An eight-module course on Amazon Redshift: architecture and Serverless setup, table design, loading data, SQL and semi-structured data, tuning, Spectrum, security and data sharing, and operations.
8 lessons · about 78 minutes of reading
Log in to track your progress through this course.
Start lesson 1- 1
Amazon Redshift Module 1: Architecture and Setting Up Serverless
Understand how Redshift stores and queries data, choose between Serverless and provisioned, and create a workgroup with cost limits.
9 min read
- 2
Amazon Redshift Module 2: Designing Tables with Distribution Keys and Sort Keys
Create tables with the right data types, distribution styles, sort keys, and compression for fast queries.
10 min read
- 3
Amazon Redshift Module 3: Loading Data with COPY and Exporting with UNLOAD
Load files from S3 into Redshift with COPY, troubleshoot load errors, and export query results with UNLOAD.
10 min read
- 4
Amazon Redshift Module 4: Querying, Window Functions, and Semi-Structured Data
Write analytical SQL with CTEs and window functions, and query JSON with the SUPER data type.
10 min read
- 5
Amazon Redshift Module 5: Performance Tuning and Maintenance
Read query plans, find slow queries, understand caching and concurrency scaling, and keep tables healthy.
10 min read
- 6
Amazon Redshift Module 6: Redshift Spectrum and Querying the Data Lake
Query data that stays in Amazon S3 using external schemas and the Glue Data Catalog, and combine it with warehouse tables.
9 min read
- 7
Amazon Redshift Module 7: Security, Data Sharing, and Integrations
Control access with roles and fine-grained permissions, share live data between warehouses, and understand zero-ETL integrations.
10 min read
- 8
Amazon Redshift Module 8: Operations, Cost, and a Capstone Project
Back up and restore, monitor and control cost, and finish by building a small analytics warehouse end to end.
10 min read