on-demand course

Hands-On Amazon Redshift for Data Warehousing

with James Cross

January 2019

Intermediate to advanced

2h 13m

English

Packt Publishing

Closed Captioning available in English

Watch now

Unlock full access

Includes

Earns Badge

Course outline

The Course Overview
2m 51s
Do We Still Need a Data Warehouse?
6m 20s
Data Technologies Compared: Relational, Data Warehouse, NoSQL, and Big Data
5m 4s
Providing Business Intelligence on Internet-Scale Data
5m 38s
Cloud-Native Data Warehousing
3m 34s
Launching a Redshift Data Warehouse on AWS
5m 45s
Launching a Redshift Data Warehouse Using Cloudformation
8m 8s
Redshift Technology Deep Dive: Columnar Filesystem
5m 15s
Redshift Technology Deep Dive: Massively Parallel Processing
4m 20s
Sourcing Appropriate Data Sets
5m 2s
Ingesting Various Sizes of Data Set into Redshift
9m 15s
Connecting to and Querying the Data Warehouse
5m 22s
Redshift Technology Deep Dive: Query Caching
4m 47s
Ingesting Enormous Volumes of Data by Copying Directly from S3
7m 16s
Optimizing Redshift Data Types for Query Performance at Scale
5m 2s
Evenly Distributing Data Across Your Cluster to Improve Filters and Joins
6m 43s
Exploratory Analytics for Disconnected Data
6m 43s
Loading a Disconnected Dataset
7m 56s
Glue Data Catalog - Creating a Schema for the External Dataset
6m 55s
The BI Use Case for Data Warehousing
4m 59s
Introducing Amazon Quicksight
6m 6s
What Is Spice and How Can It Be Used to Accelerate Analysis?
4m 51s
Loading Data into SPICE
5m 55s

Overview

In this 2-hour course, you'll learn how to leverage Amazon Redshift for data warehousing, focusing on its ability to scale from gigabytes to petabytes with ease. We'll explore its integration within the AWS ecosystem, emphasizing its high performance and scalability for cloud-based data operations.

What I will be able to do after this course

Understand the principles of data warehousing and Redshift's architecture.
Learn to create and optimize a cloud-native data warehouse using Redshift.
Master techniques for combining datasets stored across Redshift and Amazon S3.
Discover how to visualize and analyze data using Amazon QuickSight.
Gain hands-on experience connecting and querying data within Redshift.

Course Instructor(s)

James Cross is a seasoned data warehousing expert and AWS professional with years of experience in designing, implementing, and teaching cutting-edge cloud-based data solutions. Passionate about simplifying complex technologies, James combines hands-on practice with comprehensive guides to empower students in mastering scalable data systems.

Who is it for?

This course is designed for data analysts, data scientists, and AWS professionals seeking to integrate robust data warehousing solutions using Amazon Redshift. Ideal for learners familiar with AWS, including its DynamoDB and RDS services, who aim to enhance their data management strategies with the scalability and performance of modern cloud solutions.