• Online, Self-Paced
Course Description

SSIS is an extensible platform for creating data integration and workflow solutions. In this course, you will explore various options to load data.

Learning Objectives

Data Load Options

  • start the course
  • describe data loading
  • perform an incremental data load strategy
  • perform a full data load strategy
  • describe data mart
  • plan for an incremental update of the relational data mart
  • plan for loads into indexed tables
  • configure bulk load options
  • select an appropriate load technique (SSIS Destination)
  • select an appropriate load technique (T-SQL)
  • select appropriate load partitioned tables

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration
  • Systems Development