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.
Create Your First Redshift Cluster
You will create your first redshift cluster.
Create Tables in the Redshift Cluster
You will create tables in the database in the Redshift cluster.
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.
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.
Load Data From S3 into the Redshift Tables
You will load data from S3 into the Redshift tables.
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.
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.
- Familiarity with the AWS Console, S3, and IAM is preferable.