Data Warehousing with Amazon Redshift

Focused View

John Montgomery

1:30:09

78 View

0. Course Overview

0. Course Overview.mp4

01:34

1. Creating Your First Redshift Cluster

0. Introduction.mp4

01:25

1. What Is Redshift-.mp4

02:48

2. Demo- Creating a Redshift Cluster.mp4

09:07

2. Loading Data into Your Redshift Cluster

0. Bulk Loading Data into Redshift.mp4

03:20

1. Demo- Loading Data into Redshift from S3.mp4

05:59

2. Demo- Querying Data from S3 Using Redshift Spectrum.mp4

05:24

3. Deciding between Local and Spectrum Tables.mp4

02:44

3. Creating Efficient Tables in Redshift

0. Intro to Table Design.mp4

02:57

1. Redshift Distribution Styles.mp4

06:43

2. Demo- Setting a KEY Distribution Style.mp4

10:31

3. Redshift Sort Strategies.mp4

04:18

4. Demo- Comparing Sorting Strategies.mp4

04:12

5. Redshift Compression Encodings.mp4

06:57

4. Adding New Functionality to Your Redshift Cluster

0. Introduction to User-defined Functions.mp4

06:28

1. Demo- Creating and Using User-defined Functions.mp4

02:56

5. Prioritizing Tasks in Your Redshift Cluster

0. Introduction to Workload Management.mp4

05:25

1. Demo- Submitting Queries to Different Queues.mp4

07:21

Description

Proper tools must be used to handle the vast amounts of data being processed in today's world. In this course, you will learn how to set up a Redshift cluster for your own organization.

What You'll Learn?

The scale of data being processed today is vastly larger than ever before, and the proper tools must be used to handle and process this data efficiently. In this course, Data Warehousing with Amazon Redshift, you will gain an understanding of how to use Redshift for large-scale, data processing tasks. First, you will learn how to build and configure your own Redshift cluster. Next, you will discover how to design tables for optimal efficiency and performance, and load the data into Redshift from S3. Finally, you will create your own custom transformations for the data. By the end of the course, you will have the skills and knowledge to set up a Redshift cluster for your own organization.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Amazon AWS

John Montgomery

Instructor's Courses

John Montgomery has been employed as a software developer for nearly a decade across the government, financial, and commercial sectors. Being able to automate away tedious tasks for others is one of his great joys. He's CISSP and Security+ certified, and he's been involved in computer security in one way or another since he was 17, when he made his first honeypot (before he even knew what a honeypot was), and helped the police stop a cyberbullying issue. He's also very passionate about education, and enjoys helping others learn, grow, and become their best selves.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.