|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/introduction-to-data-warehouse-and-ssis-for-beginners/
课程评论：没有评论
课程名称：初学者数据仓库与SSIS入门 概述：本课程是面向初学者的培训，教授如何利用微软SQL Server、SQL Server集成服务（SSIS）和SQL Server数据工具（SSDT）实施企业数据仓库解决方案。课程特别关注如何使用SQL Server集成服务实现ETL（提取、转换、加载）流程。学生将学习以下内容： - 部署和配置SSIS包 - 下载和安装SQL Server 2014 - 下载和附加Adventureworks2014数据库 - 下载和安装SSDT - 下载和安装Visual Studio - 描述数据仓库的概念和架构考虑 - 选择合适的数据仓库硬件平台 - 设计和实施数据仓库 - 在SSIS包中实施数据流 - 在SSIS包中实施控制流 - 调试和排除SSIS包的故障 - 实施支持增量数据提取和加载的ETL解决方案 - 使用微软数据质量服务实施数据清洗 - 使用主数据服务加强数据完整性 - 通过自定义脚本和组件扩展SSIS - 理解数据库与数据仓库的区别 - 选择星型和雪花型设计模式 - 探索源数据 - 实施数据流 - 调试SSIS包 - 提取和加载已修改的数据 - 强化数据质量 - 在数据仓库中消费数据 完成本课程后，您将能够：了解数据仓库解决方案的组成部分，实施逻辑和物理设计以创建数据仓库，理解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. Students will learn how to: Deploy and Configure SSIS packages.Download and installing SQL Server 2014Download and attaching Adventureworks2014 databaseDownload and installing SSDTDownload and installing Visual studioDescribe 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 warehousesChoose between star and snowflake design schemasExplore source dataImplement data flowDebug an SSIS packageExtract and load modified dataEnforce data qualityConsume data in a data warehouse After completing this course you will be able to: Understand the components of a data warehousing solutionImplement a logical and physical design to create a data warehouseImplement a physical design for a data warehouseUnderstand SSIS for implementing data flowsCreate dynamic packages using parameters and variablesImplement Data Quality Services and Master Data Services Implement custom components for extending SSIS
