|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/developing-etl-solutions-with-ssis-for-beginners/
课程评论：没有评论
课程名称：初学者的SSIS ETL解决方案开发 课程概述： 本课程旨在教授ETL（提取、转换、加载）过程的基础知识和实践，使用微软的SQL Server集成服务（SSIS）构建高性能的数据集成解决方案。ETL是一个三阶段的过程，包括从一个或多个数据源提取数据，转换数据，然后将数据加载到一个或多个目标容器中。 SSIS提供了图形化工具和向导，便于创建和调试ETL包。课程内容涵盖各种任务，包括FTP操作、执行SQL语句和发送电子邮件消息等工作流功能。学员将学习如何配置数据源和目的地，以便提取和加载数据，并应用转换功能来清洗、聚合、合并和复制数据。此外，学员还将接触管理数据库SSISDB，用于管理包的执行和存储。 在课程中，学员将使用SSIS设计器创建一个ETL包，从一个平面文件源提取数据，经过两次查找转换后，将重格式化的数据插入到AdventureWorksDW示例数据库中的FactCurrencyRate事实表的副本中。课程还将教授如何创建新包、配置数据源和目标连接，以及与控制流和数据流组件的操作。 通过本课程，初学者将能够掌握使用SSIS进行ETL开发的基础技能，为后续深入学习数据集成和数据仓库奠定基础。
ETL ( extract, transform, load ) is a three-phase process where data is extracted, transformed and loaded into an output data container. The data can be collated from one or more sources and it can also be outputted to one or more destinations.Microsoft SQL Server Integration Services (SSIS) is a platform for building high-performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing. SSIS includes graphical tools and wizards for building and debugging packages; tasks for performing workflow functions such as FTP operations, executing SQL statements, and sending e-mail messages; data sources and destinations for extracting and loading data; transformations for cleaning, aggregating, merging, and copying data; a management database, SSISDB, for administering package execution and storage; and application programming interfaces (APIs) for programming the Integration Services object model.SSIS Designer is used to create a Microsoft SQL Server Integration Services package. The package that you create takes data from a flat file, reformats the data, and then inserts the reformatted data into a fact table.In this course, we will create a simple ETL package that extracts data from a single flat file source, transforms the data using two lookup transformations, and writes the transformed data to a copy of the FactCurrencyRate fact table in the AdventureWorksDW sample database. We will also create new packages, add and configure data source and destination connections, and work with new control flow and data flow components.
