|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-engineering-how-to-build-an-etl-pipeline-using-ssis/
课程评论：没有评论
**课程名称：** 数据工程 - 如何使用 SSIS 构建 ETL 管道 **课程概述：** 本课程深入介绍了 SQL Server Integration Services (SSIS) 的强大功能，这是一个 Microsoft SQL Server 数据库的重要组成部分，专门用于执行广泛的数据迁移任务。SSIS 是一个集成数据和工作流应用的平台，集成了数据仓库工具，能够高效地完成数据的提取 (Extract)、转换 (Transform) 和加载 (Load)——即 ETL 过程。 ETL 是一种数据集成流程，它能够将来自多个数据源的数据整合成一个单一、一致的数据存储，并最终加载到数据仓库或目标系统中。ETL 管道则是一系列用于将数据从一个或多个源头迁移到数据库（如数据仓库或目标数据库）的过程。 SSIS 提供了一种便捷且统一的方式来读取各种来源的数据（提取），进行聚合和转换（转换），然后将数据整合（加载）以满足数据仓库和分析的需求。特别是在处理海量数据（GB 甚至 TB 级别）时，SSIS 是理想的解决方案。 在本课程中，您将学习如何使用 Visual Studio 2019 中的 SQL Server Integration Services (SSIS) 来构建一个用于数据库迁移的 ETL 管道。您将亲手创建一个 SSIS 包，实现从源数据库提取和转换数据，并将处理后的数据加载到目标数据库的整个流程。
SQL Server Integration Services is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading.ETL, which stands for extract, transform and load, is a data integration process that combines data from multiple data sources into a single, consistent data store that is loaded into a data warehouse or other target system.An ETL pipeline is the set of processes used to move data from a source or multiple sources into a database such as a data warehouse or target databases.SQL Server Integration Service (SSIS) provides an convenient and unified way to read data from different sources (extract), perform aggregations and transformation (transform), and then integrate data (load) for data warehousing and analytics purpose. When you need to process large amount of data (GBs or TBs), SSIS becomes the ideal approach for such workload.In this course you will learn how to build an ETL pipeline for database migration using SQL Server Integration Services (SSIS) in Visual Studio 2019.We will create a SSIS package that will extract and transform data from a source database and then load the data into a target destination database.
