ETL Developer Training Course (11 modules / 38 topics)

(Video On-demand – Member restricted area)

$129 Only. Sign Up Today!

Module 1: Introduction and Installation of SSIS

This modules covers 4 lessons that include:

  1. Elements of Integration Services
  2. Installing SSIS & Sample Databases
  3. Exploring SSIS 2014 Data Tools
  4. Upgrading SSIS Packages

Module 2: Understanding and working with Control Flow in SSIS

This module covers 2 lessons that include:

  1. Implementing Precedence Control
  2. Working with Work-flow tasks

Module 3: Understanding and working with Data Flow in SSIS

This module covers 4 lessons that include:

  1. Extracting and loading data
  2. Data Conversion and derived columns
  3. Aggregate & Sort transforms
  4. Understanding and working with Lookup, Row count, & Union All

Module 4: Cleaning and Handling Data in SSIS

This module covers 4 lessons that include:

  1. Cleansing data in SSIS
  2. Separating data in SSIS
  3. Altering rows in SSIS
  4. Handling bad data in SSIS

Module 5: Understanding and learning to create dynamic packages

This module covers 4 lessons that include:

  1. Dynamic packages using variables
  2. Dynamic packages using parameters
  3. Dynamic connections
  4. Dynamic tasks

Module 6: Working with common ETL scenarios

This module covers 4 lessons that include:

  1. Loading data incrementally
  2. Using Change Data Capture (CDC) and Data Quality Service (DQS) components
  3. Data Quality Services (DQS) cleansing transform
  4. Creating a master package

Module 7: Understanding and working with containers

This module covers 3 lessons that include:

  1. Organizing a package
  2. Repeating control flow tasks
  3. Looping through object collection

Module 8: Configuring SSIS Packages

This module covers 3 lessons that include:

  1. Using configuration table
  2. Using configuration files
  3. Configuring child packages

Module 9: Troubleshooting SSIS Packages

This module covers 4 lessons that include:

  1. Loading package data
  2. Using event handlers
  3. Troubleshooting errors
  4. Using data viewers and breakpoints

Module 10: Managing and Administering SSIS Packages

This module covers 3 lessons that include:

  1. Understanding SSIS catalog
  2. Deploying to package catalog
  3. Configuring package and service

Module 11: Package security and scheduling

This module covers 3 lessons that include:

  1. Securing SSIS packages
  2. Executing SSIS packages
  3. Scheduling SSIS packages