High-performance Data Warehousing with Amazon Redshift

Amazon Redshift has an excellent performance reputation, but not by accident. This course focuses on performance and related topics such as architecture, design, configuration best practices, query plans, performance monitoring, and troubleshooting.
Course info
Level
Intermediate
Updated
Aug 8, 2018
Duration
2h 34m
Table of contents
Course Overview
Understanding What Makes Amazon Redshift Fast
Increasing Redshift Data Load Speeds
Designing Redshift Objects for Performance
Writing Lightening Fast Queries, Aggregates, and Reports
Monitoring and Troubleshooting Redshift Performance Issues
Description
Course info
Level
Intermediate
Updated
Aug 8, 2018
Duration
2h 34m
Description

One of the greatest selling points of Amazon Redshift is its high-performance potential. While some of these performance aspects are a natural part of the architecture, there are many others that require proper understanding and application of knowledge. In this course, High-performance Data Warehousing with Amazon Redshift, you’ll learn the keys to getting the highest performance possible out of Amazon Redshift. First, you’ll learn how to implement distribution styles across your nodes to support massively parallel processing. Next, you’ll discover many best practices produced by the AWS labs team to troubleshoot your cluster and deliver lightning-fast aggregates. Finally, you'll develop performance monitoring dashboards using Redshift features such as workload management (WLM) and AWS services such as cloud formation and cloud watch. When you're finished with this course, you'll have a foundational understanding of architecture, design, and configuration best practices in Amazon Redshift.

About the author
About the author

Currently an IT leader in Denver Colorado's financial sector Russ has focused on database development, modelling, administration, and BI since 1997 across the Microsoft stack. Russ is a passionate trainer and SQL community volunteer presenting regularly at PASS SQL Saturday events and local user groups around the US.

More from the author
More courses by Russ Thomas
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
You're familiar with Amazon Redshift and possibly you've even built your own cluster, but does it perform to its utmost potential? Join me, Russ Thomas, as we take a deep dive into all the performance aspects related to Amazon Redshift. In this course, you're going to learn about all the performance aspects necessary to get the most out of your Redshift cluster, things like configuring your distribution styles, how to implement proper compression encodings, how to use advanced features like WLN, dashboards like CloudWatch and CloudFormation, and all the things you need to know to really understand your queries. Do you know to read a query plan? You will after watching this course. Amazon Redshift provides so many places that you can get information about what your cluster is going on the inside. All the system tables and views at your disposal really are kind of staggering, and not to mention, all those Postgres tables that came with it from its Postgres background. We'll spend a lot of time going through these tables and showing how to relate the information and really understand how your cluster is functioning and what it could do better. If you care at all about performance, this course is for you. Especially if you just finished my course Building your First Amazon Redshift Data Warehouse.