menu

Advanced Operations Using Amazon Redshift

5 Steps 4h 54m 43 Credits

In this Quest, you will delve deeper into the uses and capabilities of Amazon Redshift. You will use a remote SQL client to create and configure tables, and gain practice loading large data sets into Redshift. You will explore the effects of schema variations and compression. You will explore visualization of Redshift data, and connect Redshift with Amazon Machine Learning to create a predictive data model.

Objectives

The labs in this quest will provide hands-on experience with the practical aspects of loading, manipulating, querying, and connecting to Amazon Redshift to gain insight and business benefit from large data sets.

Quest Outline

Hands-On Lab

Introduction to Amazon Redshift

The lab will give you the basic understanding of Amazon Redshift data warehouse service. It will demonstrate the basic steps required to get started with Redshift: creating a cluster, loading data and performing queries against that data.

English 日本語
Hands-On Lab

Working with Amazon Redshift

The lab demonstrates how to use Amazon RedShift to create a cluster, load data, run queries and monitor performance. Note: Students will download a free SQL client as part of this lab.

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

Using Tableau Desktop with Amazon Redshift

In this hands-on lab, you'll learn how to load data from Amazon S3 into an Amazon Redshift cluster and use Tableau Desktop for creating visualizations from that dataset. Note: registration and providing your personal contact information to Tableau is required for access to the trial version of Tableau Desktop needed for this lab. You may be contacted by Tableau as per their license agreements, which are provided during installation.

English 日本語
Hands-On Lab

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

Enroll in this quest to track your progress toward earning a badge.

home
Home
school
Catalog
menu
More
More