|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/data-warehouse-fundamentals
课程评论：没有评论
课程名称：数据仓库基础知识 课程概述：无论您是有志的数据工程师、数据架构师、业务分析师还是数据科学家，扎实的数据仓库技能都是必不可少的。通过本课程所获得的实践经验和能力，您的简历将吸引雇主的注意，助力您的职业发展。 数据仓库将来自不同来源的数据集中并组织成一个单一的存储库，使数据专业人员能够更高效地访问、清理和分析集成数据。 课程大纲： 1. 数据仓库、数据集市和数据湖 - 描述：本模块介绍数据仓库系统、数据湖和数据集市的基本概念。通过本模块的学习，您将能够识别并比较这三种数据存储实体的架构，并理解组织如何从中受益。同时，您将学习三种类型的数据仓库系统和知名数据仓库系统供应商的特点。此外，您将了解在转向新的数据仓库系统时需要评估的五个关键标准，包括总拥有成本。 2. 设计、建模和实现数据仓库 - 描述：本模块深入探讨企业数据仓库架构及其一般和参考模型。您将了解数据立方体与星型架构之间的关系，学习如何对数据立方体进行切片、切块、向上或向下钻取、合并和旋转等操作。此外，您还将研究物化视图的功能、好处以及如何应用它们。学习如何使用事实和维度及其相关表来组织信息，并探索如何利用规范化创建雪花模式作为星型模式的扩展。您还将学习填充数据仓库、增量数据更新、验证数据、查询数据和解读星型架构的实体关系图。最终，您将掌握物化视图的创建、立方体和合并选项的应用，以及实施暂存带来的优势。 3. 期末作业和期末测验 - 描述：在本模块中，您将完成实践项目和课程的最终项目，整合前两个模块所学的概念和实践。在最终项目中，您将设计并加载数据到数据仓库中，使用事实和维度表。然后，您将编写使用立方体和合并功能的聚合查询，并创建物化视图。在可选课程中，您将探索IBM Db2数据仓库系统架构的工作原理，查看用例，并了解IBM Db2 Warehouse的关键功能和集成。此课程的实践实验将使您获得如何创建Db2服务实例、如何使用IBM Db2填充数据仓库以及如何使用IBM Db2查询数据仓库的实用知识。
Name:Data Warehouses, Data Marts, and Data Lakes
Description:Welcome to your first module! This module provides an introduction to data warehouse systems, data lakes, and data marts. When you complete this module, you’ll be able to identify and compare data warehouse systems, data marts, and data lakes based on their architecture, and understand how organizations can benefit from each of these three data storage entities. Then, you’ll learn about three types of data warehouse systems and popular data warehouse system vendors. You will learn to help your organization assess new data warehouse system offerings when you know the five essential, critical criteria, including the total cost of ownership, to evaluate before changing to a new data warehouse system.
Name:Designing, Modeling, and Implementing Data Warehouses
Description:In this knowledge-packed module, you’ll explore general and reference enterprise data warehousing architecture. You’ll discover how data cubes relate to star schemas. Then, you’ll learn how to slice, dice, drill up or down, roll up, and pivot relative to data cubes. Next, you will examine the capabilities of materialized views, their benefits, and how to apply them. You’ll learn how a data organization using facts and dimensions and their related tables organizes information. Then, you will explore how to use normalization to create a snowflake schema as an extension of the star schema. You will also learn about populating a data warehouse, incremental data updates, verifying data, querying data, and interpreting an entity-relationship diagram for a star schema. Finally, the module will delve into the creation of a materialized view, the application of cube and rollup options, and examine the advantages organizations gain from implementing staging.
Name:Final Assignment and Final Quiz
Description:In this module, you’ll complete your practice project and final course project, which bring together concepts and practices you previously learned in the first two modules. In the final project, you will design and load data into a data warehouse using facts and dimension tables. Then you’ll write aggregation queries using cube and rollup functions and create a materialized view. In the optional lesson, you will explore the workings of IBM Db2 data warehouse system architecture, view use cases, and understand the key capabilities and integrations available with IBM Db2 Warehouse. The hands-on labs in this lesson will enable you to gain practical knowledge on how to create a Db2 service instance, how to populate a data warehouse using IBM Db2, how to query the data warehouse using IBM Db2.
Whether you’re an aspiring data engineer, data architect, business analyst, or data scientist, strong data warehousing skills are a must. With the hands-on experience and competencies, you gain on this course, your resume will catch the eye of employers and power up your career opportunities. A data warehouse centralizes and organizes data from disparate sources into a single repository, making it easier for data professionals to access, clean, and analyze integrated data efficiently.
