|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/introduction-to-data-warehousing/
课程评论：没有评论
**课程名称：** 数据仓库导论 **课程概述：** 本课程全面介绍数据仓库基础概念，并提供软件安装指南和分步使用教程。课程共分为三个主要部分： **第一部分：数据仓库基础** * **核心概念探讨：** 深入讲解数据仓库是什么、为何需要数据仓库、什么是ETL（提取、转换、加载）、OLAP与OLTP数据库的区别、星型和雪花型模式，以及事实表和维度表。 * **实践化讲解：** 通过生动的对话和实际案例，帮助学习者理解这些抽象概念，为后续章节的学习打下基础。 **第二部分：数据仓库软件安装** * **软件介绍与协同：** 讲解数据仓库相关软件的功能及其协同工作方式。 * **分步安装指南：** 提供SQL Server Developer、SQL Server Management Studio (SSMS)以及包含SQL Server Integration Services (SSIS)的Visual Studio Community的免费版本安装的详细步骤。 **第三部分：SSIS教程：创建项目与基础包** * **ETL工具SSIS实操：** 通过九个步骤详细演示如何使用SSIS这一ETL工具： 1. 创建新的SSIS项目 2. 添加和配置平面文件连接管理器 3. 添加和配置OLE DB连接管理器 4. 向包中添加数据流任务 5. 添加和配置平面文件源 6. 添加和配置查找转换 7. 添加和配置OLE DB目标 8. 优化Lesson 1包的可读性 9. 测试Lesson 1包 * **教程前析：** 在开始教程前，详细讲解每个步骤，包括源数据、数据转换逻辑以及数据加载到目标数据库的整个过程。
This course is an overview of basic data warehousing concepts, a guide for installing software and a step-by-step tutorial on using the software. This course is divided into three main sections:Data Warehousing BasicsWe begin with a conversation about data warehousing concepts, including the following:What is a data warehouse?Why do we need a data warehouse?What is Extract, Transform and Load (ETL)?The difference between OLAP and OLTP databasesThe Star and Snowflake schemasFact and Dimension tablesThese concepts can be difficult to understand, so I explain them using real conversation and examples. We have this conversation first so that you are familiar with the ideas as they are discussed in the later sections of the course.Data Warehousing Software InstallationIf you want to become good at data warehousing, you need to use the software. In this section I start by talking with you about the software and explain how the different pieces work together. Next is a step-by-step walkthrough of installing SQL Server Developer, SQL Server Management Studio (SSMS) and Visual Studio Community with the SQL Server Integration Services (SSIS) package. The versions of software we download are all free for you to use. SSIS Tutorial: Create a Project and Basic Package with SSISThe last section of the course is a step-by-step tutorial on using the ETL tool SSIS. The tutorial is broken down into nine steps:Step 1: Create a new integration services projectStep 2: Add and configure a flat file connection managerStep 3: Add and configure an OLE DB connection managerStep 4: Add a data flow task to the packageStep 5: Add and configure the flat file sourceStep 6: Add and configure the lookup transformationsStep 7: Add and configure the OLE DB destinationStep 8: Make the Lesson 1 package easier to understandStep 9: Test the Lesson 1 packageBefore we being the tutorial, I discuss the steps in detail. I explain the source data, how the data will be transformed and how we will get the data to it's destination database.
