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

Requirements

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

Need help picking the right course?
Call us +971 4871 6715

Testimonials

I genuinely liked the new technology.

- PCCW

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

Michał Krasucki - Instytut Lotnictwa

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.

Related Courses

Advanced AWS Lambda

 14 hours

AWS Lambda is a compute service that allows developers to write and run code without having to spin up containers and virtual machines, maintain storage, or procure the resources for running the code at scale. This instructor-led, live training

AWS Lambda for Developers

 14 hours

AWS Lambda is a "serverless" computing platform that allows engineers to create a small function, configure it in AWS console, and execute it without needing to provision servers—paying only for the resources used during

Advanced Amazon Web Services (AWS) CloudFormation

 7 hours

Amazon Web Services (AWS) CloudFormation is a service that simplifies infrastructure management by treating infrastructures as code. CloudFormation templates can be used to manage and provision AWS resources. This instructor-led, live training

AWS CloudFormation

 7 hours

Managing an AWS environment is a complex and error-prone job. CloudFormation enables the provisioning of a cloud environment using text based YAML templates.  This instructor-led, live training (online or onsite) is aimed at engineers who

Amazon DynamoDB for Developers

 14 hours

DynamoDB is a NoSQL database service offered by AWS as part of the AWS portfolio. It is a key-valued and document based database that delivers fast performance. This instructor-led, live training (online or onsite) is aimed at developers who wish

AWS IoT Core

 14 hours

This instructor-led, live training (online or onsite) is aimed at engineers who wish to deploy and manage IoT devices on AWS. By the end of this training, participants will be able to build an IoT platform that includes the deployment and

Amazon Web Services (AWS) IoT Greengrass

 21 hours

Amazon Web Services (AWS) Greengrass is an open source, cloud service that helps users create and deploy Internet of Things (IoT) applications on devices in homes, cars, hospitals, businesses, and more. AWS IoT Greengrass provides local compute,

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

 4 hours

Summery: Basics of IoT architecture and functions “Things”, “Sensors”, Internet and the mapping between business functions of IoT Essential of all IoT software components- hardware, firmware, middleware, cloud and

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

 8 hours

Summary: Basics of IoT architecture and functions “Things”, “Sensors”, Internet and the mapping between business functions of IoT Essential of all IoT software components- hardware, firmware, middleware, cloud and

Big Data & Database Systems Fundamentals

 14 hours

The course is part of the Data Scientist skill set (Domain: Data and Technology).

Pivotal Greenplum for Developers

 21 hours

Pivotal Greenplum is a Massively Parallel Processing (MPP) Data Warehouse platform based on PostgreSQL. This instructor-led, live training (online or onsite) is aimed at developers who wish to set up a multi-node Greenplum database. By the end

MemSQL

 28 hours

MemSQL is an in-memory, distributed, SQL database management system for cloud and on-premises. It's a real-time data warehouse that immediately delivers insights from live and historical data. In this instructor-led, live training,

Data Vault: Building a Scalable Data Warehouse

 28 hours

Data Vault Modeling is a database modeling technique that provides long-term historical storage of data that originates from multiple sources. A data vault stores a single version of the facts, or "all the data, all the time". Its

Apache Druid for Real-Time Data Analysis

 21 hours

Apache Druid is an open-source, column-oriented, distributed data store written in Java. It was designed to quickly ingest massive quantities of event data and execute low-latency OLAP queries on that data. Druid is commonly used in business

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

 14 hours

Apache Kylin is an extreme, distributed analytics engine for big data. In this instructor-led live training, participants will learn how to use Apache Kylin to set up a real-time data warehouse. By the end of this training, participants will