Cloud Wizard - Data Warehousing on AWS - 3 Days ILT

Cloud Wizard Consulting is an AWS Advanced Training Partner and Select Tier Consulting Partner that has trained more than 5,000 professionals. Our authorized instructors hold all AWS certifications and deliver a 100% exam passing rate for course participants. When your team needs to scale analytics, reduce query costs, or migrate from on-premises warehouses to the cloud, this course gives them the skills to deploy a production-ready Amazon Redshift environment following Well-Architected best practices.

Data Warehousing on AWS is an advanced, 3-day instructor-led course with 9 hands-on labs. Participants learn to design, implement, optimize, and secure cloud-based data warehouses using Amazon Redshift and supporting AWS services. By the end of Day 2, participants will have built and performance-tuned a Redshift Serverless cluster processing millions of rows - a tangible deliverable they can replicate in production.

• Reduce time to insight by learning to ingest streaming and batch data from Amazon S3, relational databases, and other sources into a centralized Redshift warehouse.
• Lower query costs through performance tuning techniques including materialized views, workload management, and query analysis.
• Predict customer behavior using Amazon Redshift ML - for example, a retail analytics team can build churn prediction models across millions of subscriber records without leaving the warehouse.
• Ensure business continuity by designing and implementing disaster recovery strategies for both provisioned and serverless Redshift deployments.
• Strengthen security posture through authentication, encryption, access control, and compliance auditing aligned to enterprise standards.

A retail analytics team ingesting hundreds of millions of daily clickstream events into Redshift Serverless, transforming them with ELT pipelines, and using Redshift ML to predict churn across 2 million subscribers - all orchestrated with AWS Step Functions.

Participants will learn to:

• Describe Amazon Redshift architecture and its roles in a modern data architecture
• Design and implement a cloud data warehouse using Amazon Redshift
• Load data from Amazon S3, streaming sources, and relational databases
• Analyze data using SQL Query Editor v2 notebooks
• Design disaster recovery strategies for Amazon Redshift
• Perform maintenance and performance tuning
• Secure and manage access with authentication, encryption, and auditing
• Share data between multiple Redshift clusters in an organization
• Orchestrate workflows using AWS Step Functions and Amazon MWAA
• Create ML models and configure predictors using Amazon Redshift ML

Day 1: Data Warehouse Concepts, Setting up Amazon Redshift, Loading Data (3 labs)

Day 2: SQL Query Editor v2 and Notebooks, Backup and Recovery, Performance Tuning, Securing Amazon Redshift (4 labs)

Day 3: Orchestration with Step Functions and MWAA, Amazon Redshift ML, Data Sharing, End-of-Course Challenge Lab (3 labs - including predicting customer churn)

• Data engineers
• Data architects
• Database administrators and developers

• Fundamentals of Analytics on AWS (Parts 1 and 2)
• Building Data Lakes on AWS
• Building Data Analytics Solutions Using Amazon Redshift

This course is delivered as a 3-day instructor-led training. Contact Cloud Wizard Consulting to discuss available dates, group enrollment options, and how this training fits your team's cloud goals.