: 
Last updated 1/2017
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 725.09 MB | Duration: 4h 31m
Large Scale Data Warehouse Design in the Cloud
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
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.
Overview
Section 1: Introduction
Lecture 1 Important - Download These First - Working Files
Lecture 2 Introduction
Lecture 3 About The Author
Lecture 4 What Is A Data Warehouse? - Part 1
Lecture 5 What Is A Data Warehouse? - Part 2
Lecture 6 What Is A Data Warehouse? - Part 3
Lecture 7 Shortcomings Of Self-Owned Data Warehouses
Lecture 8 Benefits Of A Public Cloud Data Warehouse
Lecture 9 Benefits Of Redshift - Part 1
Lecture 10 Benefits Of Redshift - Part 2
Lecture 11 Benefits Of Redshift - Part 3
Lecture 12 How Companies Use Redshift - Part 1
Lecture 13 How Companies Use Redshift - Part 2
Lecture 14 Third Party Visualization Tools Overview
Lecture 15 How Redshift Compares To Other Analytics Tools - Part 1
Lecture 16 How Redshift Compares To Other Analytics Tools - Part 2
Section 2: Redshift Basics
Lecture 17 Architecture
Lecture 18 Data Loading
Lecture 19 Data Distribution Concepts
Lecture 20 Basic Redshift Usage - Part 1
Lecture 21 Basic Redshift Usage - Part 2
Lecture 22 Lab: Creating An AWS Account
Lecture 23 Lab: Creating A Redshift Cluster
Lecture 24 Lab: Configuring SQL Workbench
Lecture 25 Lab: Loading Data Into S3
Lecture 26 Lab: Loading Data Into A Redshift Cluster - Part 1
Lecture 27 Lab: Loading Data Into A Redshift Cluster - Part 2
Lecture 28 Lab: Loading Data Into A Redshift Cluster - Part 3
Lecture 29 Lab: Querying A Redshift Cluster - Part 1
Lecture 30 Lab: Querying A Redshift Cluster - Part 2
Section 3: Advanced Topics
Lecture 31 Data Loading Best Practices - Part 1
Lecture 32 Data Loading Best Practices - Part 2
Lecture 33 Tuning Query Performance - Part 1
Lecture 34 Tuning Query Performance - Part 2
Lecture 35 Lab: Connecting Tableau
Lecture 36 Lab: Tableau Usage
Section 4: Conclusion
Lecture 37 Wrap Up
This course is designed for the absolute beginner, meaning no previous knowledge of Amazon Redshift is required.,Anyone wanting to learn Amazon Redshift
Homepage
https://www.udemy.com/course/hands-on-with-amazon-redshift/
Links are Interchangeable - No Password - Single Extraction