|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/a-real-world-introduction-to-amazons-redshift/
课程评论:没有评论
课程名称:现实世界中的亚马逊Redshift入门 课程概述:本课程的第一部分大多数是免费的,建议您观看这些免费的视频,以了解课程的结构。亚马逊Redshift被简化地视为传统数据仓库平台,数据仓库已经存在多年,并经历了数据建模、存储及用户可用工具的多次演变。随着行业向自助商业智能解决方案的转变,数据存储方式也在发生变化。Redshift是一个“颠覆性”的平台,不仅降低了总体成本,还增加了存储更多数据的能力,以便做出更好的商业决策。 亚马逊的服务特点之一是许多繁琐的管理任务已经被简化。硬件、软件补丁和磁盘管理的工作由亚马逊承担,尤其是自动化磁盘故障恢复和在恢复过程中开始查询集群的能力,极大减轻了用户的负担,并提高了系统的可用性。 在课程中,我们将创建节点,即Redshift集群。启动节点后,我们可以上传数据集并进行数据分析。我们将逐步讲解在现实世界中使用Redshift集群的所有必要步骤。Redshift的一个重要优势是其快速的查询性能,这主要来自于列存储技术的使用和多节点并行查询(即大规模并行处理,MPP)。 其基础硬件设计用于高性能数据处理,利用本地存储以最大化CPU与磁盘之间的吞吐量,并通过10GigE网格网络最大化节点间的吞吐量。 对于传统数据仓库,成本是最后一根稻草,Redshift以传统数据仓库的一小部分成本实现了上述所有功能。如果您希望扩展自己对亚马逊数据平台,特别是其Redshift服务的知识,那么本课程将非常适合您。欢迎来到Redshift!
Note: The vast majority of the first section is free. Please view these free videos. They will give you an idea of how the rest of the course is structured. Thank you. Although a gross oversimplification, Amazon Redshift is a traditional data warehouse platform. Data warehousing has been around for quite a number of years now. There have been many evolutions in data modeling, storage, and ultimately the vast variety of tools that the business user now has available to help utilize their quickly growing stores of data. As the industry is moving more towards self service business intelligence solutions for business users, there are also changes in how data is being stored. Amazon Redshift is one of those "game-changing" platforms that is not only driving down the total cost, but also driving up the ability to store even more data to enable even better business decisions to be made. One of the greatest features about all Amazon's service is that much of the mundane administration tasks have been removed. The hardware, software patching, and disk management (all of which are no small tasks) have been taken on by Amazon. Disk management, particularly the automated recovery from disk failure, and even the ability to begin querying a cluster that is being restored (even before it is done) are all powerful and compelling things Amazon has done to reduce your workload and increase up-time. In the course we will create nodes, called redshift cluster. Once we spun up a node we can upload our data sets and perform data analysis. We will walk through all the steps necessary to begin using a redshift cluster in the real world. One of the greatest benefits of Redshift is blazing fast query performance. There are two core items that are responsible for this. The use of columnar storage technology to improve I/O efficiency and parallelizing queries across multiple nodes. The parallelizing of queries across many nodes is known as MPP or Massive Parallel Processing. The underlying hardware is designed for high performance data processing, using local attached storage to maximize throughput between the CPUs and drives, and a 10GigE mesh network to maximize throughput between nodes. The last nail in the coffin for the traditional brick and mortal data warehouse is cost. Redshift accomplishes all this at a fraction of the cost of the traditional data warehouse. If you are looking to expand your knowledge about Amazon's data platform and specially about their Redshift service then this course is for you. Thank you and welcome to Redshift.