Hands-on with Amazon Redshift

Video description

Hands-on with Amazon Redshift

Video description

In this Hands-on with Amazon Redshift training course, expert author Rich Morrow will teach you everything you need to know to be able to work with Redshift. This course is designed for the absolute beginner, meaning no previous knowledge of Amazon Redshift is required.

You will start with an introduction to the course, learning what a data warehouse is, the benefits of Redshift, and how Redshift compares to other analytics tools. From there, Rich will teach you the basics of Redshift, including data loading, data distribution concepts, and basic Redshift usage. Finally, this video tutorial will cover advanced topics, such as data loading best practices and tuning query performance.

Once you have completed this computer based training course, you will have learned everything you need to know to get started with Amazon Redshift.

Publisher resources

Download Example Code

Introduction

Introduction 00:03:23

About The Author 00:03:31

What Is A Data Warehouse? - Part 1 00:09:00

What Is A Data Warehouse? - Part 2 00:07:02

What Is A Data Warehouse? - Part 3 00:04:48

Shortcomings Of Self-Owned Data Warehouses 00:05:00

Benefits Of A Public Cloud Data Warehouse 00:08:36

Benefits Of Redshift - Part 1 00:06:49

Benefits Of Redshift - Part 2 00:07:35

Benefits Of Redshift - Part 3 00:08:30

How Companies Use Redshift - Part 1 00:07:55

How Companies Use Redshift - Part 2 00:06:04

Third Party Visualization Tools Overview 00:05:28

How Redshift Compares To Other Analytics Tools - Part 1 00:05:36

How Redshift Compares To Other Analytics Tools - Part 2 00:06:13

How To Use The Working Files 00:01:15

Redshift Basics

Architecture 00:08:09

Data Loading 00:10:15

Data Distribution Concepts 00:08:11

Basic Redshift Usage - Part 1 00:08:55

Basic Redshift Usage - Part 2 00:06:54

Lab: Creating An AWS Account 00:05:42

Lab: Creating A Redshift Cluster 00:14:31

Lab: Configuring SQL Workbench 00:07:32

Lab: Loading Data Into S3 00:08:08

Lab: Loading Data Into A Redshift Cluster - Part 1 00:05:48

Lab: Loading Data Into A Redshift Cluster - Part 2 00:12:00

Lab: Loading Data Into A Redshift Cluster - Part 3 00:12:34

Lab: Querying A Redshift Cluster - Part 1 00:09:44

Lab: Querying A Redshift Cluster - Part 2 00:09:39

Advanced Topics

Data Loading Best Practices - Part 1 00:07:50

Data Loading Best Practices - Part 2 00:07:44

Tuning Query Performance - Part 1 00:06:30

Tuning Query Performance - Part 2 00:07:25

Lab: Connecting Tableau 00:06:14

Lab: Tableau Usage 00:09:44

Conclusion

Wrap Up 00:01:56

Start your Free Trial

Self paced

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.