|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-ssis/
课程评论：没有评论
**微软 SQL Server Integration Services (SSIS) 培训课程内容总结** 本课程是一门关于微软 SQL Server Integration Services (SSIS) 的综合性培训，旨在帮助学习者掌握这款商业智能工具，并对其开发和应用充满信心。 **课程核心内容：** * **SSIS 基础理论与开发工具：** 深入了解 SSIS 的基本概念，以及 SQL Server Data Tools (SSDT) 等开发工具的功能和强大之处。 * **数据集成与转换：** 学习如何设计 SSIS 包，处理在开发过程中可能遇到的各种问题并找到解决方案。掌握数据集成和转换的基本流程，包括数据清洗以及应用不同转换后的结果。 * **SSIS 包的创建与管理：** * 创建 Integration Services 项目。 * 使用 SSDT 的基本功能。 * 创建各种 Integration Services 任务。 * 建立 SSIS 包的连接，包括连接到 SQL Server 数据库以及从 SSIS 包导出数据。 * 在 SSDT 中执行 SSIS 包。 * 应用 Foreach Loop 并进行变量映射。 * 控制多个平面文件的数据流。 * 使用表达式更改平面文件连接。 * 使用表达式更改命令行应用程序参数。 * **数据变更捕获 (CDC) 与增量加载：** * 理解 CDC 数据库对象。 * 准备数据以进行 CDC。 * 执行增量加载。 * **常用数据转换：** 学习最常见的数据转换概念。 **课程价值：** 本课程通过实际场景的应用，帮助学习者建立扎实的 SSIS 技能，为在数据集成和商业智能领域的职业发展奠定基础。课程还包含对 SSIS/ETL 开发岗位的薪资预期进行介绍，为学习者提供职业规划的参考。
Now is your chance to learn Microsoft SQL Server Integration Services (SSIS) with this extensive course that will give you the confidence and skills to use this Business Intelligence tool. It will be the golden ticket to your success in this industry. You will learn the basics about the development tools and what they are capable of, clear instruction on how to handle various issues that you might face when designing your packages and how to overcome them. By the end of this course you will understand many basic concepts and how to perform data integration and transformation. This course also includes the process of cleansing data and how to get the end result after applying different transformations. It also gives some real world scenarios that you might face and what salary to expect from working as an SSIS/ETL developer. By taking this course you will learn about:Creating an Integration Services ProjectBasic SQL Server Data Tools featuresCreating Integration Services TasksCreating connections to and from an Integration Services PackageWriting data to a SQL Server databaseExecuting a package from SQL Server Data ToolsCreating a Foreach Loop and map VariablesControlling Data Flow for multiple Flat FilesChanging a Flat File Connection using ExpressionsChanging command-line application arguments using ExpressionsChange Data Capture(CDC) database objectsPreparing data for CDC and performing Incremental loadingMost Familiar Data Transformations concepts
