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
 

Testimonials

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