Amazon Redshift Training Overview
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.
Location and Pricing
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- 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
Prerequisites
No prior experience is required.
Outline
Expand All | Collapse All
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
Training Materials
All Amazon Redshift training students receive comprehensive courseware in electronic format.
Software Requirements
Internet access via Firefox, Chrome, or Microsoft Edge is required in order to access the remote environment used for this training.
