Duration
21 hours (usually 3 days including breaks)
Requirements
- Basic experience with Amazon Web Services (AWS)
- Familiarity with database concepts
Overview
Amazon Redshift is a petabyte-scale cloud-based data warehouse service in AWS.
In this instructor-led, live training, participants will learn the fundamentals of Amazon Redshift.
By the end of this training, participants will be able to:
- Install and configure Amazon Redshift
- Load, configure, deploy, query, and visualize data with Amazon Redshift
Audience
- Developers
- IT Professionals
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- To request a customized training for this course, please contact us to arrange.
Course Outline
Introduction to Data Warehousing
Overview of Amazon Redshift Features and Architecture
Installing and Configuring Amazon Redshift
Benefits of Using Amazon Redshift
Creating, Resizing, and Launching an Amazon Redshift Cluster
Data Loading in Amazon Redshift
- Introduction to Data Loading
- Designing and Creating Tables
- Loading Sample Data Set into RedShift
- Data Distribution in Redshift
- Data Loading Best Practices
Querying Data within Redshift
- Designing Queries
- Tuning Query Performance
Data Integration, Analysis, and Visualization with Redshift
- Connecting and Using Data Integration (ETL) Tools with Redshift
- Connecting and Using Business Intelligence (BI) Tools with Redshift
Troubleshooting
Summary and Conclusion