|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-warehouse-for-beginners/
课程评论：没有评论
**课程名称：** 数据仓库入门 **课程概述：** 本课程是为初学者设计，将指导您如何使用Microsoft SQL Server、Microsoft SQL Server Integration Services (SSIS) 和 Microsoft SQL Server Data Tools (SSDT) 来实现企业级数据仓库解决方案。您将学习如何使用SQL Server Integration Services实现ETL（提取、转换、加载）过程。 本课程的独特性在于，您将使用由Microsoft免费提供的、位于云端的、功能齐全的、最先进的虚拟实验室。您只需要一个Microsoft产品账户（如Hotmail）和一个现代网页浏览器即可访问Microsoft虚拟实验室，无需安装任何软件。 课程将重点讲解数据仓库中两种主要的表类型：事实表和维度表的设计。您还将学习用于设计维度表的星型模型（Star）和雪花模型（Snowflake）技术。 **课程内容摘要：** * 关系数据库与数据仓库的区别 * 星型模型和雪花模型在数据库模式设计中的应用 * 大数据概念简介 * ETL过程的实施 * 使用SSIS和SSDT开发ETL过程 * 使用SQL视图进行物理数据仓库设计 * 数据仓库的设计 * 数据仓库的实施 本课程完全基于视频，以易于理解和跟随的节奏进行授课。 **完成课程后，您将能够：** * 描述数据仓库。 * 设计数据仓库。 * 实施数据仓库。 * 开发ETL过程。 * 使用SSIS包实施ETL过程。 **欢迎您加入本课程！**
This course is a beginners course that will show you how to implement enterprise data warehouse solution using Microsoft SQL Server ,Microsoft SQL Server Integration Services SSIS and Microsoft SQL Server Data Tools -SSDT.You will learn how to implement ETL ( Extract,Transform, Load) process using SQL Server Integration services. This course is unique as you will be using a fully functional and state of the art virtual lab in the cloud provided for free by microsoft. All you need to access the Microsoft virtual labs is an account on any microsoft product like hotmail and a modern web browser. There is nothing absolutely to install for this course. This course will show you how to design fact and dimension tables which are the two main types of table used in data warehouse. You will learn the star and starflake techniques used to design dimension tables. Topics you will learn includes: Differences between a relational database and data warehouseUnderstanding Star and Snowflakes techniques for schema designsIntroduction to big data conceptsImplementing ETL processDeveloping ETL process using SSIS and SSDTPhysical data warehouse design using SQL viewsDesigning a data warehouseImplementing a data warehouse This course is completely video based and taught at a pace that makes it easy for you to follow along and understand. After completing this course you will be able to: Describe data warehouse.Design a data warehouseImplement Data warehouseDevelop ETL process.Implement ETL process using SSIS packages. Thank you and a warm welcome to the course:-)
