پیشنهاد فرادرس

آموزش Data Warehousing با Amazon Redshift

دسته بندی ها: آموزش شبکه ، آموزش های پلورال سایت (Pluralsight)

یکی از بزرگترین نقاط مهم Amazon Redshift پتانسیل عملکرد بالا آن است. در این دوره با افزایش عملکرد Amazon Redshift، پیاده سازی استایل های توزیع در گره ها برای پشتبانی از پردازش موازی و غیره آشنا می شوید.

سرفصل:

  • معرفی دوره
  • الگوهای دسترسی به پایگاه داده رابطه ای
  • مزایای ذخیره سازی ستون گرا
  • گره ها و خوشه های Redshift
  • معماری شبکه
  • بارهای داده Redshift
  • تحلیل فشرده سازی
  • مقایسه Sortkey
  • تحلیل و آمار
  • مدیریت Workload
  • استفاده از WLM برای لاگ کردن
  • Cloud Watch، Cloud Formation و داشبوردها
  • و غیره
High-performance Data Warehousing with Amazon Redshift Publisher:Pluralsight Author:Russ Thomas Duration:2h 34m Level:Intermediate

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.
One of the greatest selling points of Amazon Redshift is its high-performance potential. While some of these performance aspects are a natural part of the architecture, there are many others that require proper understanding and application of knowledge. In this course, High-performance Data Warehousing with Amazon Redshift, you’ll learn the keys to getting the highest performance possible out of Amazon Redshift. First, you’ll learn how to implement distribution styles across your nodes to support massively parallel processing. Next, you’ll discover many best practices produced by the AWS labs team to troubleshoot your cluster and deliver lightning-fast aggregates. Finally, you'll develop performance monitoring dashboards using Redshift features such as workload management (WLM) and AWS services such as cloud formation and cloud watch. When you're finished with this course, you'll have a foundational understanding of architecture, design, and configuration best practices in Amazon Redshift.
Course Overview
Course Overview
1m
Understanding What Makes Amazon Redshift Fast
Course and Module Introduction
4m
Relational Database Access Patterns
2m
Benefits of Column-oriented Storage
4m
Compression Encodings
3m
Redshift Clusters and Nodes
3m
Distribution Styles and Even Distribution
4m
Distribution Styles and Key Distribution
4m
Distribution Styles and All Distribution
5m
Network Architecture
3m
Increasing Redshift Data Load Speeds
Redshift Data Loads
2m
Select Into and Create Table As
3m
Staging Data and Deep Copy
2m
Copy Command Performance Best Practices
4m
Four Node Demo
4m
Parallel vs. Serial Loads
3m
Compression Analysis
4m
Designing Redshift Objects for Performance
Database Objects
2m
Compound and Interleaved Sortkeys
5m
Sortkey Comparison Demo
5m
Data Types and Implicit Conversions
2m
Informational Constraints
2m
User Defined Functions, Views, and Temp Tables
3m
Analyze and Statistics
5m
Writing Lightening Fast Queries, Aggregates, and Reports
Three Query Performance Topics
2m
Optimizing Select, From, and Where
5m
Optimizing Group By, Sort By, and Aggregates
3m
Reading and Improving Query Plans Part 1
5m
Reading and Improving Query Plans Part 2
4m
Workload Management
4m
Workload Management Queue and Slot Behavior
4m
Monitoring and Troubleshooting Redshift Performance Issues
Module Intro
3m
System Tables and Views for Query Metrics and Alerts
4m
System Tables and Views for Scans and Sorts
2m
AWS Labs Utilities
3m
Using WLM for Logging
5m
Cloud Watch, Cloud Formation, and Dashboards
6m
Closing Tips
4m

پیشنهاد فرادرس

لینک های دانلود حجم فایل: 379.0MB همراه با زیرنویس انگلیسی Pluralsight High-performance Data Warehousing with Amazon Redshift_git.ir.rar
captcha