|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-warehousing-for-beginners/
课程评论：没有评论
课程名称：数据仓库基础 课程概述：本课程是为初学者设计的，旨在教授如何使用微软SQL Server、微软SQL Server集成服务（SSIS）和微软SQL Server数据工具（SSDT）来实施企业数据仓库解决方案。您将学习如何利用SQL Server集成服务实现ETL（提取、转换、加载）过程。课程内容还将指导您设计事实表和维度表，这两种表是数据仓库中的主要表类型。此外，您将学习用于设计维度表的星型和星雪花技术。 学习内容包括： - 部署和配置SSIS包 - 下载和安装SQL Server 2014 - 下载和附加Adventureworks2014数据库 - 下载和安装SSDT - 下载和安装Visual Studio - 描述数据仓库概念和架构考虑 - 为数据仓库选择合适的硬件平台 - 设计和实施数据仓库 - 在SSIS包中实现数据流 - 在SSIS包中实现控制流 - 调试和故障排除SSIS包 - 实现支持增量数据提取的ETL解决方案 - 实现支持增量数据加载的ETL解决方案 - 使用微软数据质量服务进行数据清洗 - 实施主数据服务以确保数据完整性 - 通过自定义脚本和组件扩展SSIS - 数据库与数据仓库的区别 - 选择星型和雪花设计模式 - 探索源数据 - 实现数据流 - 调试SSIS包 - 提取和加载修改过的数据 - 确保数据质量 - 在数据仓库中消费数据 通过课程学习，您将掌握足够的技能，以实施数据仓库解决方案。
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 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. What You will learn includes: ••Deploy and Configure SSIS packages.••Download and installing SQL Server 2014••Download and attaching Adventureworks2014 database••Download and installing SSDT••Download and installing Visual studio••Describe data warehouse concepts and architecture considerations.••Select an appropriate hardware platform for a data warehouse.••Design and implement a data warehouse.••Implement Data Flow in an SSIS Package.••Implement Control Flow in an SSIS Package.••Debug and Troubleshoot SSIS packages.••Implement an ETL solution that supports incremental data extraction.••Implement an ETL solution that supports incremental data loading.••Implement data cleansing by using Microsoft Data Quality Services.••Implement Master Data Services to enforce data integrity.••Extend SSIS with custom scripts and components.••Databases vs. Data warehouses••Choose between star and snowflake design schemas••Explore source data••Implement data flow••Debug an SSIS package••Extract and load modified data••Enforce data quality••Consume data in a data warehouse By the end of this course you would have acquired enough skills to implement a data warehouse solution.
