|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/create-and-manage-redshift-clusters-on-aws/
课程评论：没有评论
课程名称：在AWS Redshift上构建和部署集群 课程概述：在本课程中，您将学习如何在AWS（亚马逊网络服务）上构建和管理Redshift集群。课程内容涵盖了创建和定制单节点和多节点云集群，您可以在这些集群上执行数据集的存储、检索和分析等多种操作。您还将学习如何管理这些集群，包括调整集群大小、设置报警、定期维护、例行检查和性能监控等。Redshift集群需要与虚拟私有云（VPC）和身份与访问管理（IAM）角色相关联，您将学习如何创建IAM角色，以增强集群的安全性和身份验证，并根据专用网络参数优化VPC，定制子网、互联网网关等网络组件。 在集群准备就绪并在云上运行后，您可以在Redshift查询编辑器上编写和运行SQL查询。课程将指导您编写和执行多个SQL查询，以从数据集中提取见解并根据特定条件执行各种分析操作。此外，您将学习如何保存和调度SQL查询，以便在预定的日期和时间执行。这些定期查询对于例行备份、维护、创建分片、分析和其他任务非常重要。本课程采用实用的方法，通过具体示例帮助学习者轻松快速地理解这些高级概念，而不需浪费时间于冗长乏味的理论课程。这些技能在与数据库管理和云计算相关的多个领域中都非常有用。 关于亚马逊Redshift：亚马逊Redshift是一种全托管的、支持PB级数据的云数据仓库服务，使您能够利用数据从数据集中获取新见解。Redshift是一种先进且流行的AWS数据仓库服务，针对读取进行了优化，使其速度显著快于传统的写入优化关系数据库。 关于数据仓库：数据仓库用于存储通常非常大的数据集，这些数据集旨在用于归档或分析。数据仓库成为历史数据的库，可以进行检索和分析，以便为商业决策提供依据。
In this course, you will learn about building and managing Redshift clusters on AWS or Amazon Web Services. Here you will learn to create and customize both single node and multi-node clusters on the cloud where you can perform various kinds of operations on these clusters such as storage, retrieval and analysis of dataset kept in form of records and tables in databases. You will also learn to manage these clusters and perform various actions such as resizing the cluster, setting up alarms, scheduled maintenance, routine checkup and performance monitoring. A Redshift cluster requires to be linked with a Virtual Private Cloud or VPC, and with an Identity and Access Management role or IAM role on AWS. You will learn to create an IAM role for adding security and authentication to your clusters and VPC for optimal performance on dedicated network paraments where you can customize subnets, internet gateways and other network components.When your cluster is ready and running on the cloud, you may write and run SQL queries on Redshift query editor. Here you will learn to write and execute multiple SQL queries for finding insights from the dataset and to perform various analytical operations based on certain conditions. Moreover, you would also learn to save and provision SQL queries that can be executed at predefined date and time. Scheduled queries are highly important for having a routine backup, maintenance, creating shards, analysis and other tasks.This course has a pragmatic approach, so everything is taught with practical examples to help learners understand these advanced concepts easily and quickly without wasting much time on long boring theoretical lessons. You could find these skills useful in various domains related to Database Administration and Cloud Computing where Redshift cluster in involved. What is Amazon Redshift?Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. This enables you to use your data to acquire new insights from the dataset. Redshift is an advanced and popular data warehousing service on AWS. Redshift is read optimized, that makes it massively faster as compared to traditional relational databases that are write optimized.What is Data Warehousing?Data Warehousing is used to store generally very large dataset that is either meant for archival usage or for analytics. The warehouse becomes a library of historical data that can be retrieved and analyzed in order to inform decision-making in the business.
