|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-the-fundamentals-of-ssis/
课程评论：没有评论
课程名称：掌握SSIS基础知识 课程概述：SQL Server集成服务（SSIS）是用于执行ETL（提取、转换和加载）操作的工具。本课程将帮助您理清SSIS的不同版本和名称变更，例如，在SQL Server 2014中，微软决定不再将SQL Server数据工具（另一种用于SSIS的Visual Studio外壳）作为正常安装的一部分，这造成了许多混淆。此外，您需要根据已有的软件下载和安装不同的工具。 本课程将为您提供SQL Server集成服务的坚实基础，涵盖从设计器到创建高质量包的所有内容。尽管ETL处理在数据仓库应用中很常见，但SSIS并不仅限于数据仓库的应用。例如，在SQL Server管理工作室（SSMS）中创建维护计划时，会自动生成SSIS包。 您将学习与SSIS相关的术语和核心组件，详细了解包的概念。包是用于检索、执行和保存工作的单位。从高层次来看，SSIS能够从几乎任何来源检索数据，对数据进行转换，将数据从一种类型转换为另一种类型，将数据加载到几乎任何源，并定义复杂的工作流，以便在任何组织中移动不同的数据。 在本课程中，您将学习如何使用SSIS开发数据集成、迁移和整合包，适用于任何有数据的组织，无论您是数据库管理员（DBA）还是开发者。我们还将讨论SSMS等其他SQL Server产品的集成，SQL Server管理工作室提供的集成服务帮助您管理包、监控运行中的包，并确定集成服务和SQL Server对象的数据影响和来源。 期待在课程中见到您！立即加入吧！！！
SQL Server Integration Services (SSIS) is a tool that we use to perform ETL operations; i.e. extract, transform and load data.We will also sort out the various versions and name changes. For example, in SQL Server 2014 Microsoft decided to no longer include SQL Server Data Tools (Another Visual Studio shell for SSIS) as part of the normal install. This confused everyone. To make matters worse, you now download and install different tools depending on what you have already.This course will provide you with a solid foundation of SQL Server Integration Services. We will cover everything from the designer to crafting high quality packages.While ETL processing is common in data warehousing (DW) applications, SSIS is by no means limited to just Data warehousing approaches.For example, when you create a Maintenance Plan using SQL Server Management Studio (SSMS) an SSIS package is created.You'll learn all the vernacular associated with SSIS as well as all the core components.We'll cover the package in detail. The package is the unit of work that is retrieved, executed, and saved.At a high level, SSIS provides the ability to retrieve data from just about any source, perform transformations on data, covert data from one type to another, load data into just about any source and define complex workflows that move disparate data throughout any organization.In this course you'll learn how to use SSIS to develop data integration, migration and consolation packages that you as a DBA or developer can use in any organization that has data.In the course we will cover the integration with other SQL Server products like SSMS. SQL Server Management Studio provides the Integration Services service that you use to manage packages, monitor running packages, and determine impact and data lineage for Integration Services and SQL Server objects.I look forward to seeing you in the course. Join Now!!!!!
