Introduction to Amazon Redshift

Introduction to Amazon Redshift

This Amazon Redshift training prepares attendees for success with the Amazon Redshift data warehouse in the AWS cloud. Students learn the benefits of Redshift and how Redshift compares to other analytics tools, as well as the fundamentals of Redshift, including data loading, data distribution, and tuning query performance.

AMAZON REDSHIFT TRAINING OBJECTIVES

All students will learn how to:

• Create an AWS account
• Create a Redshift Cluster
• Configure SQL Workbench
• Load data into S3
• Load data into a Redshift Cluster
• Query a Redshift Cluster
• Connect with and use Tableau

AMAZON REDSHIFT TRAINING PREREQUISITES

No prior experience is required.

AMAZON REDSHIFT TRAINING MATERIALS

All Amazon Redshift training students receive comprehensive courseware in electronic format.

SOFTWARE NEEDED FOR EACH PC:

Internet access via Firefox, Chrome, or Internet Explorer is required in order to access the remote environment used for this training.

For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.

AMAZON REDSHIFT TRAINING OUTLINE

• Introduction
  • What Is A Data Warehouse?
  • Shortcomings Of Self-Owned Data Warehouses
  • Benefits Of A Public Cloud Data Warehouse
  • Benefits Of Redshift
  • How Companies Use Redshift
  • Third Party Visualization Tools Overview
  • How Redshift Compares To Other Analytics Tools
  • How To Use The Working Files
• Redshift Basics
  • Architecture
  • Data Loading
  • Data Distribution Concepts
  • Basic Redshift Usage
• Advanced Topics
  • Data Loading Best Practices
  • Tuning Query Performance
• Conclusion