O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Table of Contents

  1. Introduction
    1. Introduction 00:03:23
    2. About The Author 00:03:31
    3. What Is A Data Warehouse? - Part 1 00:09:00
    4. What Is A Data Warehouse? - Part 2 00:07:02
    5. What Is A Data Warehouse? - Part 3 00:04:48
    6. Shortcomings Of Self-Owned Data Warehouses 00:05:00
    7. Benefits Of A Public Cloud Data Warehouse 00:08:36
    8. Benefits Of Redshift - Part 1 00:06:49
    9. Benefits Of Redshift - Part 2 00:07:35
    10. Benefits Of Redshift - Part 3 00:08:30
    11. How Companies Use Redshift - Part 1 00:07:55
    12. How Companies Use Redshift - Part 2 00:06:04
    13. Third Party Visualization Tools Overview 00:05:28
    14. How Redshift Compares To Other Analytics Tools - Part 1 00:05:36
    15. How Redshift Compares To Other Analytics Tools - Part 2 00:06:13
    16. How To Use The Working Files 00:01:15
  2. Redshift Basics
    1. Architecture 00:08:09
    2. Data Loading 00:10:15
    3. Data Distribution Concepts 00:08:11
    4. Basic Redshift Usage - Part 1 00:08:55
    5. Basic Redshift Usage - Part 2 00:06:54
    6. Lab: Creating An AWS Account 00:05:42
    7. Lab: Creating A Redshift Cluster 00:14:31
    8. Lab: Configuring SQL Workbench 00:07:32
    9. Lab: Loading Data Into S3 00:08:08
    10. Lab: Loading Data Into A Redshift Cluster - Part 1 00:05:48
    11. Lab: Loading Data Into A Redshift Cluster - Part 2 00:12:00
    12. Lab: Loading Data Into A Redshift Cluster - Part 3 00:12:34
    13. Lab: Querying A Redshift Cluster - Part 1 00:09:44
    14. Lab: Querying A Redshift Cluster - Part 2 00:09:39
  3. Advanced Topics
    1. Data Loading Best Practices - Part 1 00:07:50
    2. Data Loading Best Practices - Part 2 00:07:44
    3. Tuning Query Performance - Part 1 00:06:30
    4. Tuning Query Performance - Part 2 00:07:25
    5. Lab: Connecting Tableau 00:06:14
    6. Lab: Tableau Usage 00:09:44
  4. Conclusion
    1. Wrap Up 00:01:56