Amazon Redshift Training Course

Course Code

amazonredshift

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

Testimonials

★★★★★
★★★★★

Related Categories

Related Courses

Course Discounts

Course Discounts Newsletter

为尊重您的隐私,我公司不会把您的邮箱地址提供给任何人。您可以享有优先权和随时取消订阅的权利。

Some of our clients

is growing fast!

We are looking to expand our presence in China!

As a Business Development Manager you will:

  • expand business in China
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

This site in other countries/regions