Implementing ETL with SQL Server Integration Services (SSIS)

开始时间: 04/22/2022 持续时间: 6 weeks

所在平台: EdxArchive 课程类别: 其他类别 大学或机构: Microsoft 授课老师： 其他

课程主页: https://www.edx.org/archive/implementing-etl-sql-server-integration-microsoft-dat217x-0

课程评论：没有评论

第一个写评论        关注课程

课程详情

Microsoft SQL Server Integration Services (SSIS) features graphical tools and wizards for:

• building and debugging packages
• tasks for performing workflow functions
• executing SQL statements
• data sources and destinations for extracting and loading data
• transformations for cleaning, aggregating, merging, and copying data

In this computer science course, you'll extract data from a wide variety of data sources, such as files and relational data sources, perform data integration and transformation solutions, and load data into single or multiple destinations. You will solve complex business problems using best practices and troubleshooting techniques.

课程大纲

You’ll learn design principles and solutions for:

• Deciding on full or incremental loading
• Isolating ETL data
• Creating an ETL script
• ETL abstraction layers
• The design environment
• Control flows
• Data sources
• Data transformations
• Data destinations
• Precedence constraints
• Connection managers
• Execute SQL tasks
• Progress/execution results
• Resetting destination database
• Data flows
• Data flow paths
• Error output paths
• Configuring data sources and destinations
• Executing SSIS packages
• Deploying SSIS packages

课程评论(0条)