reed.co.uk Courses

Header

ETL with SQL Server Integration Services (SSIS)


Pairview Training

Summary

Price
£1,782 inc VAT
Study method
Blended (classroom and online)
Duration
3 Days, Part-time/Full-time
Qualification
No formal qualification
Additional info
  • Tutor is available to students
  • Certificate of completion available and is included in the price

5 students enquired about this course

Add to basket or enquire

Enquire now

Location & dates

Location
Address
Level 33
25 Canada Square
East London
London
E145LQ
United Kingdom

Overview

Microsoft SQL Server 2012 Integration Services (SSIS) is a component of Microsoft Business Intelligence package software. It is a robust ETL tool that is needed when creating a Data Warehousing application or migrating data from one source to another. The process involves loading the data based on business requirements, performing a transformation on the data land defining the workflow of the task. In this course, you will learn how to implement the process of data migration and how a data warehouse is created using different tasks on the control flow elements.

Description

  • Module 1: Overview to Integration Services
    Defining SQL Server Integration Services
    Exploring the need for migrating diverse data
    The role of Business Intelligence (BI)
  • Module 2: Managing Diverse Data Set
    Leveraging the Extract, Transform and Load (ETL) capabilities of SSIS
    Running wizards for basic migrations
    Creating packages for complex tasks
  • Module 3: Demonstrating SISS Architecture
    Differentiating between data flow pipeline and package runtime
    Executing packages on the client side or hosted in the SSIS service
    Bulletproofing a package with package environment configurations
  • Module 4: Simplifying Deployments
    Switching between project and package deployment modes
    Deploying packages to the SSISDB
    Running packages from SQL Server
    Leveraging package parameters
  • Module 5: Implementing Tasks and Containers
    Configuring connection managers
    Adding data flow tasks to packages
    Reviewing progress with data viewers
    Assembling tasks to perform complex data migrations
    Migrating multiple files with FOREACH container
  • Module 6: Operating System Level Tasks
    Copying, moving and deleting files
    Transferring files with the FTP task
    Communicating with external sources
    Sending messages through mail
  • Module 7: Processing XML
    Iterating XML nodes
    Writing XML files from databases
  • Module 8: Writing Expressions
    Making properties dynamic with variables
    Utilising expressions in loop iterations
  • Module 9: Script Task
    Extending functionality with the Script Task
    Debugging, breakpoints, watches
  • Module 10: Transforming with the Data Flow Task
    Converting and calculating columns
    Transforming with Character Map
  • Module 11: Profiling, Combining and Splitting Data
    Merge, Union, Conditional Split
    Multicasting and converting data
  • Module 12: Manipulating Row sets and BLOB Data
    Aggregate, sort, audit and look up data
    Importing and exporting BLOB data
    Redirecting error rows
  • Module 13: Performing Database Operations
    Executing an SQL task
    Bulk inserting data from text files
  • Module 14: Organising Package Workflow
    Defining success, failure, completion and expression precedence constraints
    Handling events and event bubbling
  • Module 15: Designing Robust Packages
    Choosing log providers
    Adapting solutions with package configurations
    Auditing package execution results
    Accessing package data with ADO.NET

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Modals

Mobile Navigation