Packt

AWS Redshift: Infrastructure, Performance, and Security

Packt

AWS Redshift: Infrastructure, Performance, and Security

Included with Coursera PlusLearn more

Gain insight into a topic and learn the fundamentals.
Intermediate level

Recommended experience

2 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
Intermediate level

Recommended experience

2 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace

What you'll learn

  • Design OLTP, OLAP, and dimensional data models

  • Use Amazon S3 for distributed storage patterns

  • Configure Redshift objects, security, and workloads

Details to know

Shareable certificate

Add to your LinkedIn profile

Recently updated!

October 2026

Assessments

12 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

 logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Data Engineering on AWS Vol 1 - OLAP & Data Warehouse Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate

There are 11 modules in this course

This module covers the fundamentals of setting up and managing a data warehouse on AWS using Redshift. Learners will explore key architectural concepts, practical workflows, and best practices for cluster management and data storage optimization.

What's included

8 videos1 reading1 assignment

This module covers essential aspects of Amazon Redshift, including querying techniques, data types, transaction management, and locking mechanisms. Learners will gain hands-on experience with Redshift objects, SQL operations, and the SUPER data type for JSON handling. The content emphasizes practical application and performance optimization in a cloud data warehouse environment.

What's included

10 videos1 assignment

This module explores essential Amazon Redshift concepts including data distribution, compression techniques, ETL processes, and table maintenance. Learners will gain hands-on experience with commands like COPY and UNLOAD, and learn how to migrate data from OLTP to DWH using AWS DMS. Practical exercises reinforce understanding of key operations and best practices for efficient data management.

What's included

12 videos1 assignment

This module explores advanced features of Amazon Redshift, including materialized views, query federation, Redshift Spectrum, streaming ingestion, and real-time data handling. Learners will gain practical insights into integrating Redshift with other AWS services and optimizing performance for large-scale data workloads.

What's included

6 videos1 assignment

This module focuses on optimizing Redshift queries through understanding execution plans, data distribution strategies, and hands-on tuning techniques. Learners will gain practical skills in analyzing and improving query performance for scalable data processing.

What's included

8 videos1 assignment

This module provides learners with a comprehensive understanding of Amazon Redshift Workload Management, including how to configure and optimize query queues, utilize concurrency scaling, and implement short query acceleration for improved performance.

What's included

6 videos1 assignment

This module covers essential security concepts in Amazon Redshift, including role-based access control, row and column-level security, dynamic data masking, and audit logging. Learners will gain practical skills in implementing and managing security policies to protect data integrity and compliance. The content combines theoretical knowledge with hands-on practice to reinforce real-world application.

What's included

9 videos1 assignment

This module covers essential techniques for monitoring Amazon Redshift, including using the console, interpreting system views, and analyzing performance metrics. Learners will gain hands-on knowledge of how to monitor and troubleshoot Redshift clusters effectively. The content emphasizes practical application of monitoring tools and data analysis for optimal system performance.

What's included

2 videos1 assignment

This module covers the fundamentals of Amazon Redshift Serverless, including how to create and manage resources, perform data loading and unloading, integrate with ZeroETL, and migrate from provisioned clusters. Learners will gain hands-on experience with query tuning, performance optimization, and architectural best practices.

What's included

7 videos1 assignment

This module explores the key factors influencing Amazon Redshift pricing, including compute, storage, and various deployment models. Learners will understand how to plan and estimate costs using AWS tools. It equips learners with practical skills to analyze and manage Redshift billing scenarios.

What's included

3 videos1 assignment

This module explores the integration, comparison, best practices, and limitations of AWS Redshift within the broader data warehousing landscape. Learners will gain insights into its behavior, use cases, and challenges compared to other services like Snowflake, while also practicing practical workflow applications.

What's included

4 videos1 reading2 assignments

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Packt - Course Instructors
Packt
2,520 Courses742,333 learners

Offered by

Packt

Explore more from Software Development

Why people choose Coursera for their career

Felipe M.

Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

What brings you to Coursera today?

Frequently asked questions