Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

AWS Redshift - The Complete Masterclass

Name: AWS Redshift - The Complete Masterclass
Rating: 4.8 (53 reviews)

Master Redshift end-to-end: COPY, Spectrum, Data API, Datashare, Federated Query, Kinesis, Operations, ML, Zero-ETL

Role Play

Highest Rated

Created byData Soup

Last updated 2/2026

English

What you'll learn

Set up Amazon Redshift (Serverless + Provisioned) with the right IAM roles, networking basics, and KMS encryption
Load data into Redshift using COPY (S3, manifests, compression, JSON/Parquet patterns, and error handling)
Automate Redshift loads with the Redshift Job Scheduler and EventBridge-style orchestration patterns
Build ELT workflows in Redshift using stored procedures (atomic/non-atomic), MERGE, UDFs, and materialized views
Use the Redshift Data API with AWS Lambda and boto3 to run SQL securely without long-lived connections
Query S3 data using Redshift Spectrum by creating external tables with the AWS Glue Data Catalog
Create views and join external Spectrum tables with internal Redshift tables for analytics workflows
Share live data using Redshift Datashare, including cross-account sharing patterns and permissions
Use Federated Query to access data in RDS/Aurora from Redshift and understand performance tradeoffs
Ingest streaming data into Redshift using Kinesis-based patterns and design for near real-time analytics
Troubleshoot performance issues: WLM queue waits, spills, skew, and concurrency bottlenecks in real workloads
Apply operational best practices: VACUUM/ANALYZE/GRANT security design, and production monitoring habits

Course content

12 sections • 78 lectures • 6h 0m total length

Course Overview4:02
Course Material1:43
Redshift Serverless and AWS Account BIlling Information1:40

Section Overview2:06
Modern Data Architecture 1016:27
Redshift 101 and Benefits4:41
Discover Amazon Redshift, a fully managed petabyte-scale cloud data warehouse for business intelligence, operational analytics, data sharing, and Redshift machine learning with SageMaker.
Redshift Features6:21
Redshift Architecture Assignment
Section and Architecture Assignment Recap3:45
Explore redshift’s mpp, olap, and columnar data warehouse, learn encoding and compression, leader node coordination, data distribution, and spectrum external tables for modern data architecture.
Quiz - Redshift Architecture and Core Concepts

Section Overview2:37
IAM 1012:38
Explore identity and access management in AWS, distinguishing authentication from authorization, and map identities to policies that grant S3 and AWS Glue permissions through IAM roles and policies.
IAM Policies4:45
KMS 1013:03
Hands On Lab - Creating Redshift Serverless Instance7:39
Hands On Lab - Connecting and Running Query in Redshift Serverless3:02
Demo - Setting Up Redshift Provisioned6:26
Demo - WLM and Other Properties Redshift Provisioned4:22
Assignment - WLM and other ADMIN Redshift Features Deep Dive
Redshift Serverless Vs Redshift Provisioned3:24
Compare Redshift serverless and provisioned deployments, highlighting automatic scalability, no manual intervention, pricing implications, backups, and performance tuning to guide use-case decisions.

Section Overview3:52
Data Ingestion 1013:45
COPY Command 1017:29
Master how the copy command loads data into a Redshift table from S3 or DynamoDB, with required table name, data source, and authorization, plus column mapping and data format options.
Hands On Lab - Ingesting Data from Data Lake - COPY Command6:04
Learn to use the copy command to ingest csv data from S3 into an Amazon Redshift serverless table, fix syntax issues, and review load errors and ignore-header options.
Hands On Lab - Manifest file in COPY Command4:40
Load data into AWS Redshift using the copy command with a manifest file, specifying S3 paths and mandatory files to ensure loading succeeds or fails when files are missing.
Hands On Lab - Ingesting and Querying Semi Structured Data5:11
Hands On Lab - Continue Querying Semi Structured Data5:38
Hands On Lab - Extract Load Transform (ELT) While Querying Semistructured Data6:58
Master ELT on semi-structured data in AWS Redshift by creating a transaction set table, loading JSON from S3, and traversing top level to nested orders and line items.
COPY Command Performance Enhancement6:13
Improve copy command performance by loading multiple files in parallel, compressing data, using parquet over csv, and applying proper distribution and sort keys.
Assignment - Ingesting Data from Data Lake - COPY Command
Hands On Lab- Automating COPY Command with Redshift Job Scheduler7:57
Automate the copy command in Redshift by scheduling queries with EventBridge, configuring required IAM roles, and using the Query Editor v2 to load nightly S3 data into Redshift.
Event Bridge Rule and Automated Job Scheduling Execution Verification3:07
Discover how to create an EventBridge rule to schedule Redshift Serverless queries, monitor execution, and chain dependent tasks, including disabling rules to control costs.
AWS Data Migration Services (DMS) 1011:01
Copy Command Help
Quiz: COPY Command

Section Overview4:24
Hands On Lab - UNLOAD in Redshift2:56
Redshift Stored Procedure Syntax and Types3:22
Hands On Lab - Creating Stored Procedures4:48
Explore atomic vs non-atomic stored procedures in AWS Redshift, including how to use begin-end blocks, handle exceptions, and implement error logging while updating employee salary and executing SQL commands.
Materialized View and EXPLAIN 1014:39
Hands On Lab - Creating Materialized View3:21
Hands On Lab - MERGE in Redshift Using Stored Procedure4:44
Hands On Lab - Creating UDF in Redshift3:55
Section Recap and Deep Dive on ELT, UPSERT and CTAS4:43
Quiz: Data Processing in Redshift

DATA API 1013:13
Explore how the Redshift Data API enables secure, synchronous, serverless query access via boto3 and the AWS SDK, using secret manager credentials for ETL and event-driven integrations.
Redshift DATA API BOTO3 1013:20
Hands On Lab - Creating Lambda and IAM Role to Run Query Using DATA API7:56
Create a lambda function to call the Redshift Data API, configure an IAM role with necessary permissions and secret manager access, and test with Redshift Query Editor v2.
Hands On Lab - Running Redshift DATA API Lambda2:45
Set up and deploy a Redshift data API lambda, configure environment variables and timeouts, and run a simple query to pull data from the dev Redshift database.
Deep Dive - Redshift DATA API Lambda Code4:00
Explore how to invoke and test a redshift data API lambda, pass events from S3, EventBridge, and CloudWatch, and manage async queries using the query ID, status checks, and results.
Hands On Lab - Completing Lambda Setup to Run Query Using Data API3:05
Section Review and Cross Account Redshift DATA API2:45
Explore how to run Redshift Data API commands, including execute SQL and describe, with Lambda across accounts by configuring cross-account IAM roles and trust policies to assume roles.
Quiz: Redshift Data API

Redshift Spectrum - Section Overview3:15
Explore redshift spectrum fundamentals, external tables, and the AWS Glue catalog, then learn best practices, limitations, use cases, and hands-on lab to query data in S3.
Spectrum 101 and Evaluation Of Spectrum4:08
Redshift Spectrum - KeyConcepts Benefits and Limitations4:43
Learn how redshift spectrum enables querying external tables stored in S3 via the glue data catalog, with metadata, partition pruning, and cost-effective scalability, plus its read-only limitations.
Redshift Spectrum - Usecase and Comparison4:05
AWS Glue Catalog 101 From Glue Master Class For Concept Learning3:28
AWS Glue Crawler 101 From Glue Master Class For Concept Learning6:03
AWS Glue crawler 101 shows how a crawler accesses data using IAM roles, extracts metadata, and creates table definitions in AWS Glue catalog, updating schema, partitions, and classifiers for formats.
Hands On Lab - Creating External Table5:16
Hands On Lab - Running Query on External Table7:46
Log into Query Editor v2, create an external schema linked to the Glue data catalog, and query the external table stored in S3 after updating the IAM role.
Hands On Lab - Creating View on External Table9:16
Design Review: Joining S3 (Glue Catalog) with Redshift Under Heavy Load
Quiz: Redshift Spectrum

Data Share 1014:27
Data Share Usecase3:36
Explore data share use cases for workload isolation, cross-group collaboration, and data as a service, enabling development agility through producer and consumer clusters without moving data.
Hands On Lab - Producer AWS Redshift Setup (New Account)6:11
Hands On Lab - Consumer AWS Redshift Setup (Hands On AWS Account)4:33
Hands On Lab - Creating Data Share Schema4:01
Learn to create a data share schema in AWS Redshift and query shared data. Use external schemas and two-part naming to access data set tables in the consumer account.
Quiz: Redshift Datashare

Federate 1013:58
Hands On Lab - Creating RDS Database4:43
Hands On Lab - Loading Data into RDS2:27
Hands On Lab - Setting Up IAM Role for Federated Query5:26
Set up a serverless IAM role to access RDS secret from Secrets Manager, update inline policy, and configure security groups to allow Redshift federated query to RDS via Postgres 5432.
Hands On Lab - Joining RDS and Redshift Data6:19
Quiz: Redshift Federated Query

Requirements

Basic SQL (SELECT, JOIN, GROUP BY) is helpful
Basic AWS familiarity (console navigation) is helpful but not required
An AWS account to do the hands-on labs (Free Tier where applicable; some services may incur small charges)
A laptop/desktop with internet
Optional: basic Python knowledge if you want to follow the Lambda + boto3 Data API demos (I explain it step-by-step)
No prior Redshift experience needed — we start from fundamentals and build up to production workflows.

Description

This course contains the use of artificial intelligence. This is a hands-on Amazon Redshift masterclass for SQL-heavy data engineers and analysts who want to go beyond writing queries and learn how to design, build, and operate Redshift in real production environments.

It begins with Redshift fundamentals and architecture, then moves into setting up both Redshift Serverless and Provisioned correctly—covering practical foundations such as IAM, KMS, permissions (GRANT), and core workload concepts.

From there, the course focuses on real-world data ingestion using the COPY command and multiple hands on with all the different options to ingest data in Redshift.

Next, it covers data processing inside Redshift with practical approaches for the all data processing offering from Redshift such as Unload, Stored Proc, Materialized views, UDF and many more.

It also covers how Redshift connects with other AWS services through hands-on examples, including:

Redshift Data API with Lambda and boto3
Redshift Spectrum (external tables and views on S3 using the Glue Data Catalog)
External schemas and querying external data
Cross-account data sharing (Datashare)
Federated queries to RDS
Streaming ingestion using Kinesis

Finally, it wraps up with operations and performance tuning (monitoring, skew/spills/queue waits, vacuum/analyze, concurrency tradeoffs) and finishes with modern capabilities like Redshift ML and Zero-ETL—where they fit, when they don’t, and their limitations.

By the end, you’ll have a practical, production-ready Redshift skillset you can apply immediately.

Who this course is for:

Data engineers / analytics engineers who want production-ready Amazon Redshift skills
SQL-heavy analysts who want to understand ingestion, performance, and real AWS integrations (Spectrum, Data API, Datashare)
AWS developers building pipelines with S3, Glue, Lambda, Kinesis, and Redshift
Anyone preparing for interviews or job work involving COPY, Spectrum, performance tuning, and Redshift architecture

AWS Redshift - The Complete Masterclass

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 7min

Redshift Overview5 lectures • 23min

Setting Up Redshift Serverless and Provisioned9 lectures • 38min

COPY Command - Data Ingestion In Redshift13 lectures • 1hr 2min

Data Processing in Redshift9 lectures • 37min

Redshift DATA API - Data Ingestion7 lectures • 27min

Redshift Spectrum (External Tables on S3)10 lectures • 48min

Redshift Datashare ( Sharing Data Between AWS Accounts)5 lectures • 23min

Federated Query (Query RDS from Redshift)5 lectures • 23min

Kinesis Stream + Redshift Integration4 lectures • 22min

Requirements

Description

Who this course is for: