Building with Amazon Redshift Clusters

During the lab, individuals will use the AWS Management Console and SQL Workbench to experiment with different table layouts and schema designs.

Level

Intermediate

Duration

1 Hours 0 Minutes

Course Objectives

In this course, you will learn how to:

• Use the SQL Workbench for Amazon Redshift
• Understand the COPY command for loading data and working with compression
• Use a manifest file for data imports
• Archive data using the UNLOAD command
• Use ANALYZE and VACUUM operations
• Use the Amazon Redshift console to explore query statistics

Intended Audience

This course is intended for:

• Solutions Architects
• Database Architects
• Developers

Prerequisites

We recommend that attendees of this course have the following prerequisites:

• Familiarity with SQL statements and basic operations
• Familiarity with the AWS Management Console
• A remote connection client (such as Remote Desktop Connection, which is included with most versions of Windows) to connect to your server

Course Outline

Task 1: Connect to the cluster

Task 2: Connect to the Windows instance

Task 3: Import data

Task 4: Use the manifest file to import data

Task 5: Unload data to Amazon S3

Task 6: Use VACUUM and ANALYZE commands

Task 7: Optimize with SORTKEY and DISTKEY

Task 8: View query statistics with the console

Task 9: Run specific scenario queries