课程图谱

Implementing ETL with SQL Server Integration Services (SSIS)

所在平台: EdxArchive

课程类别: 其他类别

大学或机构: Microsoft

授课老师： 其他

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

课程评论：没有评论

第一个写评论        关注课程

课程简介

Learn how to use SSIS to build high performance integration solutions and ETL packages for data warehousing.

课程大纲

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条)

课程详情

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.

课程标签

0人关注该课程

主题相关的课程