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.
Level
Fundamental
Duration
1 Hours 15 MinutesCourse Objectives
In this course, you will learn how to:
- Launch a Redshift cluster
- Connect an SQL client to the Amazon Redshift cluster
- Load data from an S3 bucket into the Amazon Redshift cluster
- Run queries against data stored in Amazon Redshift
Intended Audience
This course is intended for:
- Architects
- Data Engineers
- Developers
Prerequisites
We recommend that attendees of this course have the following prerequisites:
- Familiarity with relational databases and SQL concepts would be beneficial
Course Outline
- Task 1: Launch an Amazon Redshift Cluster
- Task 2: Use the Redshift Query Editor to Communicate with your Redshift Cluster
- Task 3: Create a Table
- Task 4: Load Sample Data from Amazon S3
- Task 5: Query Data