Create, Load, and Query Data on Amazon Redshift
In this lab, you’ll practice different Amazon Redshift operations. When you’re finished with this lab, you’ll have practices creating, loading, and querying data on Amazon Redshift.
Terms and conditions apply.
Challenge
Create Your First Redshift Cluster
You will create your first redshift cluster.
Challenge
Create Tables in the Redshift Cluster
You will create tables in the database in the Redshift cluster.
Challenge
Load Sample Data to the Table and Perform Sample Queries
You will load sample data into a table, and perform sample queries on the data.
Challenge
Copy the S3 Bucket Name and Role ARN Value into Redshift
You will copy the S3 bucket name and Role ARN value into the Redshift tables.
Challenge
Load Data From S3 into the Redshift Tables
You will load data from S3 into the Redshift tables.
Challenge
Perform Analytical Queries on the Redshift Tables
You will perform different analytical queries on the Redshift table.
Provided environment for hands-on practice
We will provide the credentials and environment necessary for you to practice right within your browser.
Guided walkthrough
Follow along with the author’s guided walkthrough and build something new in your provided environment!
Did you know?
On average, you retain 75% more of your learning if you get time for practice.
Recommended prerequisites
- Familiarity with the AWS Console, S3, and IAM is preferable.