Hands-on with Amazon Redshift

Name: Hands-on with Amazon Redshift
Rating: 4.2 (1811 reviews)

Large Scale Data Warehouse Design in the Cloud

Created byInfinite Skills

Last updated 1/2017

English

What you'll learn

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

Course content

4 sections • 37 lectures • 4h 30m total length

Important - Download These First - Working Files0:01
Introduction3:23
About The Author3:30
What Is A Data Warehouse? - Part 19:00
What Is A Data Warehouse? - Part 27:02
What Is A Data Warehouse? - Part 34:48
Materialize data into multi-dimensional cubes for fast queries across customer, product, and time, while recognizing exponential growth and OLAP licensing limits as dimensions expand.
Shortcomings Of Self-Owned Data Warehouses4:59
Benefits Of A Public Cloud Data Warehouse8:36
Benefits Of Redshift - Part 16:48
Benefits Of Redshift - Part 27:35
Explore the benefits of Amazon Redshift, including easy setup with a web GUI and API access, automatic fault tolerance, and incremental backups to S3 for simple disaster recovery.
Benefits Of Redshift - Part 38:30
How Companies Use Redshift - Part 17:55
See how Pinterest and Nasdaq use Amazon Redshift to speed analytics, from data sources like Kafka, Hive, Hadoop, and a data lake on S3, delivering real-time KPI dashboards.
How Companies Use Redshift - Part 26:03
Third Party Visualization Tools Overview5:27
How Redshift Compares To Other Analytics Tools - Part 16:12
How Redshift Compares To Other Analytics Tools - Part 25:35

Architecture8:08
Data Loading10:15
Explore data loading options for Amazon Redshift, optimize parallel loads across slices, and apply the copy command from S3 while using data distribution, slicing, and vacuuming concepts.
Data Distribution Concepts8:11
Basic Redshift Usage - Part 18:54
Explore practical redshift usage from basic syntax and expressions to core copy, ddl/dml commands, data types and functions, and user and group permissions.
Basic Redshift Usage - Part 26:54
Lab: Creating An AWS Account5:42
Create an AWS account to spin up a redshift cluster and sign into the console. Set up Virginia region CloudWatch billing alarms for five and ten dollars.
Lab: Creating A Redshift Cluster14:30
Create a multi-node Amazon Redshift cluster, configure the VPC security group for external access, create an IAM user and credentials, and learn to stop, restart, and snapshot to control costs.
Lab: Configuring SQL Workbench7:31
Lab: Loading Data Into S38:07
Lab: Loading Data Into A Redshift Cluster - Part 15:47
Load data into a Redshift cluster by configuring a data loading script with credentials, creating tables, and preparing copy commands for part 2 using S3 and sequel work bench.
Lab: Loading Data Into A Redshift Cluster - Part 211:59
Complete part two of the lab by loading data into a Redshift cluster with copy commands, debugging outputs, and monitoring large data loads.
Lab: Loading Data Into A Redshift Cluster - Part 312:33
Lab: Querying A Redshift Cluster - Part 19:43
Practice querying a Redshift cluster, view the queries library, validate data with counts, and optimize queries using create table as select and distribution keys.
Lab: Querying A Redshift Cluster - Part 29:39

Data Loading Best Practices - Part 17:49
Data Loading Best Practices - Part 27:44
Tuning Query Performance - Part 16:29
Learn to tune Amazon Redshift query performance through thoughtful table design, choosing sort and distribution keys, managing compression, and maintaining leader node statistics with vacuum and analyze updates.
Tuning Query Performance - Part 27:25
Lab: Connecting Tableau6:14
Connect Tableau Desktop to your Redshift cluster, configure credentials, and build joined tables (public schema, line order, and customer key) to create interactive visualizations for dashboards.
Lab: Tableau Usage9:43
Learn to explore Redshift data with Tableau, create region and revenue visuals, calculate margins, drill down by nation, and save or refresh worksheets.

Requirements

PC or MAC
No previous knowledge of Amazon Redshift is required

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.

Who this course is for:

This course is designed for the absolute beginner, meaning no previous knowledge of Amazon Redshift is required.
Anyone wanting to learn Amazon Redshift

Hands-on with Amazon Redshift

What you'll learn

Explore related topics

Course content

Introduction16 lectures • 1hr 35min

Redshift Basics14 lectures • 2hr 8min

Advanced Topics6 lectures • 45min

Conclusion1 lecture • 2min

Requirements

Description

Who this course is for: