Working with Amazon Redshift

Languages Available: Español (Latinoamérica) | Français | Bahasa Indonesia | Italiano | 日本語 | 한국어 | Português (Brasil) | 中文（简体)

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

2 Hours 0 Minutes

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