Course Code

amazonredshift
 

     Duration

21 Hours
 
 

     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

 

     Feedback (13)

I genuinely liked the new technology.

- PCCW


Practice parts

- Instytut Lotnictwa


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

- PCCW


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

Starts

 

Ends

 

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

Location


  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

MemSQL

  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