|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ssis-introduction/
课程评论：没有评论
**课程名称：** SQL Server Integration Services (SSIS) 入门 **课程概述：** 本课程是一门面向初学者的 SSIS 入门课程，旨在帮助您掌握 Microsoft SSIS 的数据提取、转换和加载 (ETL) 功能。课程包含可下载的练习文件，让您边学边练。 **核心内容：** * **SSIS 基础：** 学习 SSIS 的目的、实际应用场景，以及如何使用 SQL Server Business Intelligence Development Studio、SSIS 工具箱、解决方案资源管理器和属性窗口等界面元素。 * **控制流和数据流：** 深入理解 SSIS 包中的控制流和数据流，学习如何构建任务流程和管理数据转换。 * **表达式和转换：** 掌握 SSIS 表达式的编写，包括字符串函数，并学习使用各种数据转换组件（如聚合、合并、查找等）来处理数据。 * **自动化和参数：** 学习如何利用循环功能实现自动化，以及如何设置和使用项目级和包级参数，并掌握错误处理技巧。 * **部署：** 了解如何将 SSIS 包部署到 SSISDB 目录。 **学习目标：** 完成本课程后，您将能够： * 解释 SSIS 的目的和实际应用。 * 熟练导航 SSIS 界面。 * 创建 SSIS 包的控制流结构。 * 使用数据流组件进行数据转换。 * 构建 SSIS 表达式来操作数据。 * 运用数学函数和数据转换进行 ETL。 * 实现多样化的 SSIS 数据转换。 * 组合来自多个源的数据（Union All, Merge, Merge Join）。 * 执行数据查找并理解缓存模式。 * 设置使用参数，并进行有效的错误处理。 **课程包含：** * 2.5 小时视频教程 * 19 个视频讲座 * 课程和练习文件 * 结业证书 **总而言之，**这门课程将为您在自动化 SQL Server 数据库维护和 ETL 流程方面打下坚实的基础，提升您的数据处理能力和职业前景。
**This course includes downloadable exercise files to work with**Embark on a transformative journey with our Introduction to SQL Server Integration Services (SSIS) beginner course. This course is your gateway to mastering Microsoft's SSIS, a powerful tool for data extraction, transformation, and loading (ETL).You'll discover how to navigate the tool effortlessly, explore the control and data flow functions, and build a strong foundation in Expressions and Transformations, the building blocks of SSIS workflows. Learn to handle Parameters, troubleshoot errors effectively, and understand how Looping functions enhance automation. In the final session, you'll unlock the art of deploying your packages into the SSISDB catalog, taking your newfound skills to the next level.Throughout the course, you'll grasp the essentials of SSIS, from using the SQL Server Business Intelligence Development Studio to the practical applications of SSIS in real-world scenarios. With an in-depth look at the SSIS Toolbox, Solutions Explorer, and Properties Window, you'll easily navigate SSIS. You'll also delve into the Control Flow, Data Flow, SSIS Expressions, and Transformations, gaining a comprehensive understanding of each component's role and functionality.By the end of this course, you'll be equipped with the knowledge and skills to help you excel in using SSIS for automating SQL Server database maintenance and ETL processes. Whether you aim to enhance your career prospects or streamline data management, this course will help empower you. Join us today and become a proficient SSIS user, expanding your abilities and career opportunities in the world of data management. Take advantage of this opportunity to boost your data-handling capabilities!By the end of this course, you will be able to:Explain the purpose and real-world applications of SQL Server Integration Services (SSIS).Navigate the SSIS interface, including using the SSIS Toolbox and Solutions Explorer.Create control flow structures in SSIS packages to manage tasks efficiently.Manage data transformation using different components in the Data Flow section.Construct SSIS expressions, including string functions, to manipulate data.Utilize mathematical functions and data conversion transformations for ETL processes.Implement various SSIS transformations to aggregate, merge, and modify data.Combine data from multiple sources using Union All, Merge, and Merge Join transformations.Perform data lookups and understand the options for SSIS Lookup cache modes.Set up and use parameters at both project and package levels, and handle errors efficiently in your SSIS packages.This course includes:2.5 hours of video tutorials19 individual video lecturesCourse and Exercise files to follow alongCertificate of completion
