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
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 hoursAWS 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 hoursAWS 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 hoursAmazon 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 hoursManaging 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 hoursDynamoDB 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 hoursThis 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 hoursAmazon 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 hoursSummery: 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 hoursSummary: 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 hoursThe course is part of the Data Scientist skill set (Domain: Data and Technology).
Pivotal Greenplum for Developers
21 hoursPivotal 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 hoursMemSQL 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 hoursData 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 hoursApache 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 hoursApache 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