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.

Level

Intermediate

Duration

Course Objectives

In this course, you will learn how to:

• Launch an Amazon Redshift cluster
• Connect to Amazon Redshift by using SQL client software
• Load data from Amazon S3 into Amazon Redshift
• Query data from Amazon Redshift
• Monitor Amazon Redshift performance

Intended Audience

This course is intended for:

• Data Engineers
• Developers

Prerequisites

We recommend that attendees of this course have the following prerequisites:

• Familiar with basic concepts of databases and SQL

Course Outline

• Task 1: Launch your Amazon Redshift Cluster
• Task 2: Connect to Amazon Redshift
• Task 3: Load data
• Task 4: Run Queries
• Task 5: Joining tables
• Task 6: Analyze Performance
• Task 7: Explore the Amazon Redshift Console