Skip to content

ETL with SQL Server Integration Services (SSIS) - In-house training’

Enquire for in-house and bespoke options’

Pairview Training

Summary

Price
Enquire to get more info on pricing
Study method
Onsite
Qualification
No formal qualification
Additional info
  • Tutor is available to students

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.

You will learn to…


- Create a well-designed package of Business Intelligence Studio
- Use different tasks on control flow elements, including various containers
- Write data to multiple destinations
- Apply the best practices that will make it easier to maintain a package over task lifecycle
- Administer the storage and security of packages

Description

Course Content

  • 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

4 Benefits of booking this course with us

Benefit 1

Intensive training of the most required skills in the Analytics sector, provided by attentive experienced industry practitioners.

Benefit 2
Hands-on, practical experience of applying the skills in different business scenarios.

Benefit 3
Flexible timetables and part-time courses.

Benefit 4

Pairview Practitioner Certificate: SSAS.

Who is this course for?

This course is intended for database professionals that handle activities related to data processing, data architecture planning, or SSIS administration.

You will need to have knowledge of Querying Microsoft SQL Server to take this course.

Questions and answers

Reviews

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

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Similar subjects: Microsoft Office, SQL, Business, Coding