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.

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.

Topics:

• 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