Advanced Operations Using Amazon Redshift

4 Steps 5 hours 43 Credits




Quest Outline

Hands-On Lab

Working with Amazon Redshift


English 日本語 简体中文
Hands-On Lab

Using Tableau Desktop with Amazon Redshift


English 日本語
Hands-On Lab

warning Advanced Amazon Redshift: Data Loading

In this lab, you will experiment with and compare different types of data loading using Amazon Redshift. You will create tables, load data using S3, remote hosts, and practice troubleshooting data loading errors. For the lab to function as written, please DO NOT change the auto assigned region.

English 日本語
Hands-On Lab

Advanced Amazon Redshift: Table Layout and Schema Design

In this lab, you will take a close look at different types of table layout and schema design. You will create tables using various methods for data compression and distribution, and analyze which methods work best, including incorporating Amazon Redshift recommendations. You will conclude the lab by building five different versions of the same table, and analyzing how the differences impact storage requirements and query performance. Pre-requisites: To successfully complete this lab, you should be familiar with Redshift concepts. Knowledge of SQL programming is required, although full solution code is provided.

Enroll Now
