|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ssis-etl-create-integration-service-project-and-package/
课程评论：没有评论
**课程名称：SSIS ETL：创建集成服务项目和包** **课程概述：** 本课程深入探讨SQL Server Integration Services (SSIS)，一个强大的平台，用于构建企业级数据集成和数据转换解决方案。SSIS是Microsoft SQL Server数据软件的一部分，是Microsoft商业智能套件的核心组件，主要用于实现数据集成和工作流应用程序。 课程将重点介绍SSIS作为一种“ETL”（提取、转换、加载）工具的核心功能，它能够从各种数据源（包括SQL Server、Oracle数据库、Excel、CSV或文本文件等）提取数据，进行清理和处理，最终加载到数据存储中。 然而，SSIS的功能远不止于此。它本质上是一个工作流编排器，能够根据成功、失败或其他因素（如优先级约束）按顺序或并行执行不同的任务和执行路径。这意味着SSIS不仅限于数据仓库场景，还可以应用于其他领域，例如数据库管理员可以利用它来调度和执行数据库备份。 **课程特色：** * **可视化开发：** SSIS主要是一个可视化工具。课程将展示如何在Visual Studio中开发SSIS包，并利用其直观的视觉画布和“控制流”选项卡来组织任务，使得项目更易于理解。 * **解决复杂业务问题：** 学习如何利用SSIS来解决复杂业务问题，包括文件复制/下载、数据仓库加载、数据清理和挖掘，以及管理SQL Server对象和数据。 * **广泛的应用场景：** 超越传统ETL，探索SSIS在数据库管理，如数据库备份调度等方面的应用。 本课程为学习如何有效地使用SSIS进行数据集成和工作流管理提供了一个全面的指南。
Extract, transform, and load (ETL) is the process by which data is acquired from various sources. The data is collected in a standard location, cleaned, and processed. Ultimately, the data is loaded into a datastore from which it can be queried. Legacy ETL processes import data, clean it in place, and then store it in a relational data engine."SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data."SSIS is part of the Microsoft SQL Server data software, used for many data migration tasks. It is basically an ETL tool that is part of Microsoft's Business Intelligence Suite and is used mainly to achieve data integration. This platform is designed to solve issues related to data integration and workflow applications.SSIS is commonly known as an "ETL" product, a means to move and transform data from one point to another from various data sources (SQL Server or Oracle databases, Excel, CSV or Text files and more). But SSIS is so much more. In its bare essence, SSIS is a workflow orchestrator: it executes different tasks, either sequentially or in parallel, and different execution paths can be executed, depending on success, failure or other factors including precedence constraints. This means SSIS can be used in other scenarios than just data warehousing with the corresponding SSAS and SSRS Microsoft Data Platform products. Database administrators can use it for example to schedule and execute backups of their databases.SSIS is mainly a visual tool. Packages are developed in Visual Studio and they use a visual canvas to arrange tasks on the Control Flow tab. This means the solution is more easily understood by someone new to the project.
