Amazon Redshift

• Basic experience with Amazon Web Services (AWS)
• Familiarity with database concepts

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.

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