SSIS Training | Microsoft SSIS Certification Course Online

Key Highlights

+1 930 200 4823

( Toll Free )

10 Hrs Instructor Led Training

Self-paced Videos

20 Hrs Project & Exercises

Certification

Job Assistance

Flexible Schedule

Lifetime Free Upgrade

Mentor Support

Curriculum

A complete index of
job-ready skills curated
to meet the industrial need.
Explore.

Introduction to Integration Services

Defining SQL Server Integration Services (SSIS)
Exploring the need for migrating diverse data
The role of Business Intelligence (BI)

SSIS Architecture and Tools

Managing heterogeneous data
Leveraging the Extract, Transform and Load (ETL) capabilities of SSIS
Running wizards for basic migrations
Creating packages for complex tasks
Explore other supported data sources, such as Hadoop and NoSQL

Illustrating SSIS architecture

Distinguishing between data flow pipeline and package runtime
Executing packages on the client side or hosted in the SSIS service
Bulletproofing a package with package environments
Package restart-ability with checkpoint files

Simplifying deployments

Distinguishing between project and package deployment modes
Deploying packages to the SSISDB
Running packages from SQL Server
Leveraging package parameters

Implementing Tasks and Containers

Utilizing basic SSIS objects
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

Operating system-level tasks

Copying, moving and deleting files
Transferring files with the FTP task
Communicating with external sources
Sending messages through the mail

Processing XML

Iterating XML nodes
Writing XML files from databases

Extending Capabilities with Scripting

Writing expressions
Making properties dynamic with variables
Utilizing expressions in loop iterations

Script Task

Extending functionality with the Script Task
Debugging, breakpoints, and watches
Transforming with the Data Flow Task

Performing transforms on columns

Converting and calculating columns
Transforming with Character Map

Profiling, combining and splitting data

Merge, Union and Conditional Split
Multicasting and converting data

Manipulating row sets and BLOB data

Aggregate, sort, audit and look up data
Importing and exporting BLOB data
Redirecting error rows

Performing database operations

Executing a SQL task
Bulk inserting data from text files
Error Handling, Logging, and Transactions

Organizing package workflow

Defining success, failure, completion and expression precedence constraints
Handling events and event bubbling

Designing robust packages

Choosing log providers
Adapting solutions with package configurations
Auditing package execution results
Accessing package data with ADO.NET

We have made a tailored curriculum covering the latest industry-ready concepts to serve every individual’s learning desires.

Project Details

We bring you the best learning experience by delivering all our training sessions practical. Following are the few use cases we shall discuss during the training.

SSIS Training Objectives

1. What are the SSIS training course objectives?

By the end of the SSIS training, you will be able to:

Understand the MSBI application development life cycle.
Understand the basic Data Warehousing concepts.
Understand the Concept of OLTP and OLAP.
Use SSDT (SQL Server Data Tools) in detail for development of SSIS packages.
Learn SSIS architecture, components of SSIS.
Gain a complete understanding of different control flow tasks, containers, and precedence constraints.
Gain a complete understanding of a wide variety of data flow sources, transformations and destinations.
Learn to work with variables, data types, functions, expressions and parameters and providing dynamism in SSIS.
Develop packages using different tasks and different transformations based on real-time requirements.
Learn to work with an event handler, logging, configuration files.
Learn error handling and debugging in SSIS.
Learn package deployment and project deployment.
Gain an understanding of security and package management.

2. Why should you learn SSIS course?

There is a huge requirement for skilled SSIS professionals around the globe.
Top multinational companies are recruiting certified SSIS professionals worldwide
The average salary of a certified SSIS professional is around $63,500 USD per annum.

3. Who should attend SSIS training?

Business intelligence professionals
Database professionals
Data Warehousing professionals
Software developers
ETL developers
Aspirants who are willing to build their career in the administrative field.

4. What are the prerequisites for learning SSIS training?

There are no prerequisites for learning SSIS course. The following job roles will get benefited by taking up this course:

Database administrators.
Software developers
ETL developers

5. What projects are included in this SSIS training course?

The tutor will take care of handling the projects. We will provide two real-time projects with a highly-skilled guide who can assist you throughout the project.

+1 930 200 4823

( Toll Free )

Training Options

Different individuals. Different upgrade goals. Different modes of learning.

We got solutions for everyone looking for an AWS Architect course. Opt in for your convenient upgrade option, and we will guide you through.

Duration

One-on-one Session

Support

Resources

Time

Fee

Live Online.

10 Hours

Yes

24x7

Additional tips from the trainer

30 July 2024, 07:00 AM

03 August 2024, 08:00 AM

Self-Paced

10 Hours

Weekdays & Working Hours

Accessible through LMS

At your convenience

SSIS Training Upcoming Batches

Weekday

30 July 2024 to 30 August 2024

07:00 AM

Weekend

03 August 2024 to 03 September 2024

08:00 AM

Weekday

06 August 2024 to 06 September 2024

07:00 AM

Weekend

10 August 2024 to 10 September 2024

07:30 AM

Schedules Doesn't Suit You ?

Our Team can set up a batch at your convinient time.

Corporates Training

Experience and witness the express transformation of your workforce from the world-class tech upgrade platform.

Customized training options

Tailored curriculum to fit your project needs.

Practical exposure is assured.

We have got everything covered for any IT upgrade for your organization. We are one click away.

Success Stories from Future Digital Leaders

Excellent training institute. Each and every topic was explained clearly.

Hasini

Tekslate provides the best coaching for SSIS. I attended the course and was extremely happy with my training.

Rashmi

Overall it was a good experience. Good co-operation from the Institute and the support team...

Roshan

SSIS Training FAQ'S

Have questions? We’ve got the answers. Get the details on how you can grow in this course.

1. Who are the trainers?

We have a strong team of professions who are experts in their fields. Our trainers are highly supportive and render a friendly working environment to the students positively stimulating their growth.

2. What if I miss a class?

We will share you the missed session from our recordings. We at Tekslate maintains a recorded copy of each live course you undergo.

3. How will I execute the practical?

Our Trainers will provide the student with the Server Access ensuring practical real-time experience and training with all the utilities required for the in-depth understanding of the course.