PS – High-performance Data Warehousing with Amazon Redshift

PS – High-performance Data Warehousing with Amazon Redshift
English | Size: 388.88 MB
Category: Tutorial

Amazon Redshift has an excellent performance reputation, but not by accident. This course focuses on performance and related topics such as architecture, design, configuration best practices, query plans, performance monitoring, and troubleshooting.
Resume CourseBookmarkAdd to Channel

Table of contents
Description
Exercise files
Discussion
Recommended
Collapse all
Course Overview1m 22s
Course Overview1m 22s
Understanding What Makes Amazon Redshift Fast37m 1s
Course and Module Introduction4m 35s
Relational Database Access Patterns2m 40s
Benefits of Column-oriented Storage4m 6s
Compression Encodings3m 56s
Redshift Clusters and Nodes3m 57s
Distribution Styles and Even Distribution4m 2s
Distribution Styles and Key Distribution4m 48s
Distribution Styles and All Distribution5m 53s
Network Architecture3m 1s
Increasing Redshift Data Load Speeds26m 8s
Redshift Data Loads2m 47s
Select Into and Create Table As3m 24s
Staging Data and Deep Copy2m 50s
Copy Command Performance Best Practices4m 40s
Four Node Demo4m 16s
Parallel vs. Serial Loads3m 18s
Compression Analysis4m 49s
Designing Redshift Objects for Performance28m 33s
Database Objects2m 55s
Compound and Interleaved Sortkeys5m 51s
Sortkey Comparison Demo5m 19s
Data Types and Implicit Conversions2m 49s
Informational Constraints2m 15s
User Defined Functions, Views, and Temp Tables3m 52s
Analyze and Statistics5m 29s
Writing Lightening Fast Queries, Aggregates, and Reports30m 42s
Three Query Performance Topics2m 22s
Optimizing Select, From, and Where5m 31s
Optimizing Group By, Sort By, and Aggregates3m 19s
Reading and Improving Query Plans Part 15m 51s
Reading and Improving Query Plans Part 24m 59s
Workload Management4m 19s
Workload Management Queue and Slot Behavior4m 17s
Monitoring and Troubleshooting Redshift Performance Issues30m 14s
Module Intro3m 36s
System Tables and Views for Query Metrics and Alerts4m 5s
System Tables and Views for Scans and Sorts2m 52s
AWS Labs Utilities3m 33s
Using WLM for Logging5m 27s
Cloud Watch, Cloud Formation, and Dashboards6m 32s
Closing Tips4m 6s
————————————————————————————————————————
Course Overview1m 22s
Course and Module Introduction4m 35s
Relational Database Access Patterns2m 40s
Benefits of Column-oriented Storage4m 6s
Compression Encodings3m 56s
Redshift Clusters and Nodes3m 57s
Distribution Styles and Even Distribution4m 2s
Distribution Styles and Key Distribution4m 48s
Distribution Styles and All Distribution5m 53s
Network Architecture3m 1s
Redshift Data Loads2m 47s
Select Into and Create Table As3m 24s
Staging Data and Deep Copy2m 50s
Copy Command Performance Best Practices4m 40s
Four Node Demo4m 16s
Parallel vs. Serial Loads3m 18s
Compression Analysis4m 49s
Database Objects2m 55s
Compound and Interleaved Sortkeys5m 51s
Sortkey Comparison Demo5m 19s
Data Types and Implicit Conversions2m 49s
Informational Constraints2m 15s
User Defined Functions, Views, and Temp Tables3m 52s
Analyze and Statistics5m 29s
Three Query Performance Topics2m 22s
Optimizing Select, From, and Where5m 31s
Optimizing Group By, Sort By, and Aggregates3m 19s
Reading and Improving Query Plans Part 15m 51s
Reading and Improving Query Plans Part 24m 59s
Workload Management4m 19s
Workload Management Queue and Slot Behavior4m 17s
Module Intro3m 36s
System Tables and Views for Query Metrics and Alerts4m 5s
System Tables and Views for Scans and Sorts2m 52s
AWS Labs Utilities3m 33s
Using WLM for Logging5m 27s
Cloud Watch, Cloud Formation, and Dashboards6m 32s
Closing Tips4m 6s
——————————————————————————————————–
1.Course Overview1m 22s
2.Course and Module Introduction4m 35s
3.Relational Database Access Patterns2m 40s
4.Benefits of Column-oriented Storage4m 6s
5.Compression Encodings3m 56s
6.Redshift Clusters and Nodes3m 57s
7.Distribution Styles and Even Distribution4m 2s
8.Distribution Styles and Key Distribution4m 48s
9.Distribution Styles and All Distribution5m 53s
10.Network Architecture3m 1s
11.Redshift Data Loads2m 47s
12.Select Into and Create Table As3m 24s
13.Staging Data and Deep Copy2m 50s
14.Copy Command Performance Best Practices4m 40s
15.Four Node Demo4m 16s
16.Parallel vs. Serial Loads3m 18s
17.Compression Analysis4m 49s
18.Database Objects2m 55s
19.Compound and Interleaved Sortkeys5m 51s
20.Sortkey Comparison Demo5m 19s
21.Data Types and Implicit Conversions2m 49s
22.Informational Constraints2m 15s
23.User Defined Functions, Views, and Temp Tables3m 52s
24.Analyze and Statistics5m 29s
25.Three Query Performance Topics2m 22s
26.Optimizing Select, From, and Where5m 31s
27.Optimizing Group By, Sort By, and Aggregates3m 19s
28.Reading and Improving Query Plans Part 15m 51s
29.Reading and Improving Query Plans Part 24m 59s
30.Workload Management4m 19s
31.Workload Management Queue and Slot Behavior4m 17s
32.Module Intro3m 36s
33.System Tables and Views for Query Metrics and Alerts4m 5s
34.System Tables and Views for Scans and Sorts2m 52s
35.AWS Labs Utilities3m 33s
36.Using WLM for Logging5m 27s
37.Cloud Watch, Cloud Formation, and Dashboards6m 32s
38.Closing Tips4m 6s

Buy Long-term Premium Accounts To Support Me & Max Speed

DOWNLOAD:

If any links die or problem unrar, send request to http://goo.gl/aUHSZc

About WoW Team

I'm WoW Team , I love to share all the video tutorials. If you have a video tutorial, please send me, I'll post on my website. Because knowledge is not limited to, irrespective of qualifications, people join hands to help me.

Skip to toolbar