|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/aws-redshift-a-comprehensive-guide/
课程评论：没有评论
课程名称：AWS Redshift - 初学者综合指南 课程概述： Amazon Redshift 是一个快速、易于使用、经济实惠的云数据仓库解决方案，能够处理 PB 级的数据。在本课程中，我们将以循序渐进的方式学习 Redshift 的多个功能。该教程包含动手实验和面试问题集的支持，课程内容分为以下核心领域： 1. **概述**：对 AWS Redshift 的简要介绍，数据仓库系统及相关技术的演变。 2. **开始使用**：通过加载和查询示例数据开始使用 Amazon Redshift。我们将了解 Redshift 生态系统的基本知识，包括 Redshift 控制台、查询编辑器以及与外部 SQL 客户端（如 DBeaver）的集成所需的配置。 3. **工作原理**：深入探讨 Redshift 的核心机制，了解 Redshift 的核心组件及其功能，包括 Redshift 集群、节点、分布键、排序键、结果缓存、AQUA、RA3 实例等。 4. **数据管理**：了解 Redshift 数据类型、数据加载与查询选项、自动表设计、存储过程、物化视图以及工作负载管理等数据管理方面的知识。 5. **AWS 服务**：探讨 Redshift 的一些高级功能，包括 Redshift Spectrum、Redshift ML 和联邦查询。我们还将了解 Redshift 与其他 AWS 服务（如数据湖构建、AWS EMR、AWS Glue、Amazon Kinesis、Amazon QuickSight、AWS SageMaker）的集成。 6. **集群管理**：学习 Redshift 的管理方面，包括基本的集群操作、快照备份、监控、日志记录和数据安全。 7. **总结**：最后，我们将了解 Redshift 的成本与定价、最佳实践及阅读参考等内容。 更新： 2023 年 7 月：更新了课程内容，包含 AWS Redshift Serverless 的概述、入门指南、管理、监控和定价信息。 本课程适合希望深入了解 AWS Redshift 的初学者，并通过实践练习获得实际操作经验。
Amazon or AWS Redshift is a fast, easy to use, cost-effective, peta-byte level, cloud data warehousing solution. In this course we will learn multiple features of Redshift in a step-by-step approach. This tutorial is well supported by hands-on lab exercises and the set of Interview Questions. The course is divided in following core areas Overview - Brief introduction to AWS Redshift, Datawarehouse Systems & evolution of related technologiesGetting Started - We will get started on Amazon Redshift by loading and querying sample data. We will understand the bare minimum of redshift ecosystem including Redshift Console, Query Editor and Configurations needed to integrate an external SQL Client - DBeaver.How does it work - We will jump into the core mechanics of Redshift where we will understand the core components, functions of redshift including Redshift Cluster, Nodes, Distribution Key, Sort Key, Results Cache, AQUA, RA3 Instances, etc.Manage Data - We will move to manage data section where we will understand the redshift data types, data loading & data querying options, automated table design, stored procedures, materialized views and workload management.AWS Services - In this section, we will understand some advanced features of Redshift including Redshift Spectrum, Redshift ML and Federated Queries. We will also understand the integration aspects of redshift with other AWS services such as data-lake formation, aws EMR, AWS glue, Amazon Kinesis, Amazon Quicksight, AWS Sagemaker, etc. Manage Cluster - In this section, we will understand the management aspects of redshift including the basic cluster operations, snapshots as backups, monitoring, logging & data security.Conclude - In the last section, we will understand the redshift cost and pricing, best practices, reading references, etc.UpdatesJuly 2023: Updated the course with AWS Redshift Serverless - Overview, Getting Started Guide, Management, Monitoring and Pricing.
