Advanced Operations Using Amazon Redshift
2 Steps 4 hours 18 Credits
In this Quest, you will delve deeper into the uses and capabilities of Amazon Redshift. You will use a remote SQL client to create and configure tables, and gain practice loading large data sets into Redshift. You will explore the effects of schema variations and compression. You will explore visualization of Redshift data, and connect Redshift with Amazon Machine Learning to create a predictive data model.
Objectives:The labs in this quest will provide hands-on experience with the practical aspects of loading, manipulating, querying, and connecting to Amazon Redshift to gain insight and business benefit from large data sets.
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.
In this hands-on lab, you'll learn how to load data from Amazon S3 into an Amazon Redshift cluster and use Tableau Desktop for creating visualizations from that dataset. Note: registration and providing your personal contact information to Tableau is required for access to the trial version of Tableau Desktop needed for this lab. You may be contacted by Tableau as per their license agreements, which are provided during installation.