Amazon Redshift, AWS cloud data warehouseAmazon Redshift Training

Learn to design, build, manage and scale Redshift clusters, optimize performance, manage security and integrate Redshift with BI and ETL tools.

Book an appointment Call 847-350-9034

Hands-on labsReal-world projectsInterview prep

Built for data and cloud roles

The course includes hands-on labs, real-world projects and interview preparation to build job-ready skills.

Data Engineering

Loading, ETL and performance tuning in Redshift.

Analytics

Redshift SQL and BI dashboards with Power BI, Tableau, QuickSight.

Cloud roles

Cluster setup, security, monitoring and maintenance on AWS.

Detailed course content

Eleven modules from architecture to real-world projects.

1. Introduction to Amazon Redshift

✓What is Amazon Redshift? Key features and use cases✓Redshift vs traditional data warehouses✓Architecture overview, columnar storage and MPP✓Ecosystem and integrations

2. Architecture and core concepts

✓Leader node and compute nodes, node types (RA3, DC2)✓Workload Management (WLM)✓Distribution styles (KEY, EVEN, ALL), sort keys✓Redshift Spectrum overview, pricing and cost basics

3. Setting up Redshift

✓Creating and configuring a cluster✓VPC, subnets, security groups, IAM roles✓Query Editor, DBeaver, SQL Workbench/J✓Users, roles, permissions, parameter groups

4. Redshift SQL fundamentals

✓Databases, schemas and tables✓INSERT, UPDATE, DELETE, SELECT✓COPY and UNLOAD commands✓Temporary tables, views and materialized views

5. Data loading and ETL

✓COPY from S3, DynamoDB and Amazon EMR✓Compression encodings and COPY options (JSON, CSV, Parquet)✓Redshift Spectrum: querying data in S3✓ETL integrations: AWS Glue, Lambda, Kinesis, Informatica, Talend

6. Performance optimization

✓Choosing distribution and sort keys✓Vacuuming and analyzing tables, skew handling✓EXPLAIN for query tuning✓Concurrency scaling, RA3 managed storage, result caching

7. Advanced features

✓Redshift Serverless✓Federated queries to RDS/Aurora✓Materialized view refresh strategy, data sharing✓Lakehouse architecture, QuickSight, Tableau, Power BI

8. Security and compliance

✓Encryption at rest and in transit✓IAM role best practices, PrivateLink✓Audit logging, users, groups and roles✓Compliance: HIPAA, PCI, GDPR

9. Monitoring and maintenance

✓CloudWatch metrics, console monitoring, Performance Insights✓System tables and logs✓Backups, snapshots, resize and pause/resume✓Managing workload with WLM queues

10. BI, analytics and projects

✓Connecting to Power BI, Tableau and QuickSight✓Creating dashboards and reports✓Real-time analytics (Kinesis + Redshift)✓Module 11: real-world projects

Support and salient features

Career support and classroom features that come with the course.

Staffing support

✓Resume preparation✓Mock interview preparation✓Phone interview preparation✓Face to face interview preparation✓Project and technology preparation✓Internship with internal project work✓Externship with client project work

Our salient features

✓Hands-on labs and homework✓Group discussion and case study✓Course project work✓Regular quiz and exam✓Regular support beyond the classroom✓Students can re-take the class at no cost✓Dedicated conference rooms for group project work✓Live streaming for remote students✓Video recording to catch up on a missed class

Ready to learn Amazon Redshift?

Call 847-350-9034 or book an appointment to talk about this course and funding options.Book an appointment Call 847-350-9034 Education grant program

Built for data and cloud roles

The course includes hands-on labs, real-world projects and interview preparation to build job-ready skills.

Data Engineering

Loading, ETL and performance tuning in Redshift.

Analytics

Redshift SQL and BI dashboards with Power BI, Tableau, QuickSight.

Cloud roles

Cluster setup, security, monitoring and maintenance on AWS.

Detailed course content

Eleven modules from architecture to real-world projects.1

Introduction to Amazon Redshift

✓What is Amazon Redshift? Key features and use cases✓Redshift vs traditional data warehouses✓Architecture overview, columnar storage and MPP✓Ecosystem and integrations2

Architecture and core concepts

✓Leader node and compute nodes, node types (RA3, DC2)✓Workload Management (WLM)✓Distribution styles (KEY, EVEN, ALL), sort keys✓Redshift Spectrum overview, pricing and cost basics3

Setting up Redshift

✓Creating and configuring a cluster✓VPC, subnets, security groups, IAM roles✓Query Editor, DBeaver, SQL Workbench/J✓Users, roles, permissions, parameter groups4

Redshift SQL fundamentals

✓Databases, schemas and tables✓INSERT, UPDATE, DELETE, SELECT✓COPY and UNLOAD commands✓Temporary tables, views and materialized views5

Data loading and ETL

✓COPY from S3, DynamoDB and Amazon EMR✓Compression encodings and COPY options (JSON, CSV, Parquet)✓Redshift Spectrum: querying data in S3✓ETL integrations: AWS Glue, Lambda, Kinesis, Informatica, Talend6

Performance optimization

✓Choosing distribution and sort keys✓Vacuuming and analyzing tables, skew handling✓EXPLAIN for query tuning✓Concurrency scaling, RA3 managed storage, result caching7

Advanced features

✓Redshift Serverless✓Federated queries to RDS/Aurora✓Materialized view refresh strategy, data sharing✓Lakehouse architecture, QuickSight, Tableau, Power BI8

Security and compliance

✓Encryption at rest and in transit✓IAM role best practices, PrivateLink✓Audit logging, users, groups and roles✓Compliance: HIPAA, PCI, GDPR9

Monitoring and maintenance

✓CloudWatch metrics, console monitoring, Performance Insights✓System tables and logs✓Backups, snapshots, resize and pause/resume✓Managing workload with WLM queues10

BI, analytics and projects