|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-srver-integration-servicesssis/
课程评论：没有评论
课程名称：SQL Server Integration Services (SSIS) 课程概述： 本课程旨在教授如何使用SQL Server Integration Services（SSIS）创建强大且复杂的数据提取、转换和加载（ETL）解决方案。学员将学习设计、创建、部署和管理满足日常业务需求的SSIS包。SSIS可用于数据迁移和数据集成，课程将比较SSIS与其他ETL工具，如Informatica、DataStage、Ab Initio和Data Integrator的不同之处。 角色与职责： - SSIS开发者角色： - 开发SSIS包 - 错误处理 - 包调试 - 优化包 - 使用脚本化的SSIS包 - SSIS管理员角色： - 安装 - 配置 - 部署 - 安全管理 - 手动执行包 - 调度 - 监控及故障排除 SSIS架构： 课程将介绍SSIS的四个组成部分： 1. SSIS对象模型 2. SSIS服务 3. SSIS运行时引擎 4. 数据流引擎 学员将学习如何通过使用SSIS对象模型开发包、管理和执行已部署的包。 SSIS设计器的各个部分： - 控制流：管理任务执行的工作流程和顺序。 - 数据流：进行ETL操作，包括从多个源提取数据、执行转换并将数据加载到多个目标中。 - 事件处理程序：实现控制流任务的错误处理和调试。 - 包资源管理器：浏览包的内容，包括任务、优先约束、日志提供程序、变量、事件处理程序和连接管理器。 - 参数：替代当前版本SSIS中的配置，允许在包执行时为包内属性分配值。 通过本课程，学员将掌握SSIS的核心功能与实践技能，为数据管理与整合提供有力支持。
· SSIS makes it easy to create robust and complex solutions for extracting, Transforming and Loading the data.· These will help you to design, create, deploy and manage packages that address everyday business requirements.· SSIS can be used for data migration as well as data integration purpose.· Other ETL tools areInformatica, DataStage, abinito and data integrator.SSIS Dev roles:· Developing packages· Error handling· Debugging of packages· Optimizing packages· Using Scripting SSIS packages.SSIS Administrator Roles:· Installation· Configuration· Deployment· Security· Executing the packagesManuallyScheduling· Monitoring and trouble shooting in SSIS.SSIS Architecture:It means that four components.1. SSIS Object model2. SSIS Service3. SSIS Runtime engine and4. Dataflow engine.1. Develop the SSIS packages by consuming the ssis object model.2. SSIS service will manage the deployed packages.3. SSIS runtime engine will execute the different tasks in the package.4. Dataflow engine will executes the dataflow tasks in the package.Sections in SSIS Designer:Control Flow:Work flow of task execution / order of tasks execution.Controlling the flow of SSIS package execution.Data Flow: ETLIt contains extracting the data from one more sources with the help of source adapters, performing transformations and loading the data into one more destinations with the help of destination adapters.Event Handlers:It allows you to implement error handling and debugging of control flow tasks in SSIS packages.Package Explorer:It allows you to browse the package contents. Package contains tasks, precedence constraints, log providers, variables, event handlers and connection managers.Parameters:Parameters are the replacement for configurations that are in the current version of SSIS. It allows you to assign values to properties within packages at the time of package execution.
