1. Home
  2. Training Library
  3. Amazon Web Services
  4. Courses
  5. Amazon Redshift Distribution Styles

Amazon Redshift Distribution Styles

Amazon Redshift Distribution Style - Introduction
Overview
Difficulty
Intermediate
Duration
16m
Students
111
Ratings
5/5
starstarstarstarstar
Description

Amazon Redshift is a cloud-native data warehouse from AWS. It has a Massively Parallel Processing framework that automatically distributes data and the query load across every node available in a cluster. This course explains how Redshift distributes table data, how keys are used inside tables, and the importance of distribution styles.

Learning Objectives

  • Understand the key concepts of data distribution
  • Learn about the three types of distribution styles
  • Understand the difference between distribution keys and sort keys

Intended Audience

This course is intended for database administrators or anyone who wants to enhance their knowledge of Amazon Redshift.

Prerequisites

To get the most from this course, you should have a basic understanding of Amazon Redshift.

Transcript

Amazon Redshift is a cloud-native data warehouse from AWS.  It has a Massively Parallel Processing framework that automatically distributes data and the query load across every node available in a cluster.

AWS can do most of this for you.  However, if you understand your data and the nature of the queries that will be performed, there are ways to optimize the data distribution to improve performance.

In this course, I will explain how Redshift distributes table data, highlight how keys are used inside tables, and the importance of distribution styles.  As a result, to get the most from this course, you should have a basic understanding of Amazon Redshift.

My name is Stephen Cole and I’ll be your instructor for this course.  I’ve been working in the cloud for several years and currently hold many active AWS certifications.

My contact information is shown on the screen.  Please feel free to reach out to me with any questions, comments, or concerns.  

LinkedIn: https://www.linkedin.com/in/mysticole928/

Twitter: https://twitter.com/mysticole928

Alternatively, you can always get in touch with us here at Cloud Academy by sending an email to support@cloudacademy.com and one of our cloud experts will follow up with you.

About the Author
Avatar
Stephen Cole
AWS Certification Specialist
Students
17012
Courses
18
Learning Paths
5

Stephen is the AWS Certification Specialist at Cloud Academy. His content focuses heavily on topics related to certification on Amazon Web Services technologies. He loves teaching and believes that there are no shortcuts to certification but it is possible to find the right path and course of study.

Stephen has worked in IT for over 25 years in roles ranging from tech support to systems engineering. At one point, he taught computer network technology at a community college in Washington state.

Before coming to Cloud Academy, Stephen worked as a trainer and curriculum developer at AWS and brings a wealth of knowledge and experience in cloud technologies.

In his spare time, Stephen enjoys reading, sudoku, gaming, and modern square dancing.