Course Code



21 Hours


  • 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


  • Developers
  • IT Professionals

Format of the course

  • Part lecture, part discussion, exercises and heavy hands-on practice


  • 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


Summary and Conclusion


     Feedback (13)

I genuinely liked the new technology.


Practice parts

- Instytut Lotnictwa

The training is practical and it is good for understanding how to use AWS step by step


That it was all new technology and offerings to myself. After being shown how quick and easy it is to set up certain services in AWS, I feel I could get a real benefit out of it for quick project and proposal prototyping.

MDA Systems Ltd.

Fernando knew the products and how to use them. His willingness and friendliness to assist in the hands-on lab was great.

MDA Systems Ltd.

There was a good general pass over what seemed like the most important parts of AWS. The instructor was open to questions and addressed areas of AWS that were not part of the outline based on our questions.

MDA Systems Ltd.

I liked getting to understand the breadth of the services offered by AWS and gaining a better understanding of their pricing model for each of those services.

William Crowdis - MDA Systems Ltd.

Thought it was a good overview of a lot of different services. Liked the detail on IAS.

MDA Systems Ltd.

Explaining why it's financially viable to do these things

MDA Systems Ltd.

It provided context for the things we do in AWS.

MDA Systems Ltd.

Everything. I had played around with AWS before but just on my own personal time. The training really brought everything together, with real world examples and how many individual pieces can be bolted together for a applicable solution.

Matt Sartain - MDA Systems Ltd.

Hands-on labs

MDA Systems Ltd.

examples, preparation of materials, level of knowledge of trainer, excellent communication

Michał Krasucki - Instytut Lotnictwa

The course could be tailored to suit your needs and objectives. It can also be delivered on your premises if preferred.



Online Price per participant 6000 AED


Classroom Price per participant 6000 AED





  Workday courses take place between 9:30 and 16:30


  Show venue details

Number of Participants

Related Courses

Total Courses 8


Advanced AWS Lambda

  14 hours

AWS Lambda for Developers

  14 hours


Advanced Amazon Web Services (AWS) CloudFormation

  7 hours

AWS CloudFormation

  7 hours


Amazon DynamoDB for Developers

  14 hours

AWS IoT Core

  14 hours

Amazon Web Services (AWS) IoT Greengrass

  21 hours

Industrial Training IoT (Internet of Things) with Raspberry PI and AWS IoT Core 「4 Hours Remote」

  4 hours

Industrial Training IoT (Internet of Things) with Raspberry PI and AWS IoT Core 「8 Hours Remote」

  8 hours


Big Data & Database Systems Fundamentals

  14 hours

Pivotal Greenplum for Developers

  21 hours


  28 hours


Data Vault: Building a Scalable Data Warehouse

  28 hours


Apache Druid for Real-Time Data Analysis

  21 hours


Apache Kylin: From Classic OLAP to Real-Time Data Warehouse

  14 hours

Discounted Public Courses

This site in other countries/regions