SSIS Training

(3) 3 Ratings

Course Schedule

30

JUL

Mon - Sat

07:30 PM - 10:00 PM ( IST )

06

AUG

Mon - Fri

11:00 AM - 02:00 PM ( IST )

11

AUG

Sat - Sun

05:30 AM - 06:30 AM ( IST )


Total Learners

987 Learners


LMS Access

365 days

Course duration

30 days


Support

24/7 support

Can't find convenient schedule?

Our experts can help you find a batch that meets your needs

The Instructor for this course is from one of the Big5 Companies in the world.

Drop us a Query

I agree to the Training T&C

Modes of Training

Corporate Training

Live, Classroom Or Self Paced Training

Online Classroom

Attend our Instructor Led Online Virtual Classroom

Self Paced Training

Comprehensive Recorded Videos by Experts to learn at your own pace

Course Features

Live Instructor-led Classes

This isn't canned learning. Its dynamic, its interactive, its effective

Expert Educators

Only the best or they're out. We are constantly evaluating our trainers

24&7 Support

We never sleep. Need something answered at 3 am? No Problem

Flexible Schedule

You don't learn as per our calendar. We work according to yours

☰ Details

Course Curriculum

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 restartability 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.

Basic ETL Entities in SSIS

  • SSIS Data Types and Data Conversions
  • SSIS Local and Global Variables
  • Dynamic Precedence Constraints
  • Dynamic Connection Managers in DFT
  • Data Flow Transformations and Usage
  • Handling ETL Enumerations in SSIS
  • ETL with Loops & Indexed Connections.

SSIS Expressions & Package Debugging

  • Conditional Precedence Expressions
  • SSIS Parameters Usage and Variables
  • Control Flow Breakpoints - Usage
  • Data Flow Data Viewers and Audits
  • SSIS Expressions & Debugging Options
  • Debugging SSIS Packages & Limitations
  • Debugging Procedures in Realtime.

Data Flow Transformations and ETL

  • Row and Column Transformations
  • Combining and Splitting Data
  • Performing SQL Database Operations
  • MERGE Vs UNION ALL Transformations
  • Lookup, Fuzzy Lookup and Grouping
  • SORT Vs AGGREGATE Transformations
  • OLE-DB Command Usage & Parameters
  • Derived Columns & Data Conversions
  • SSIS Parameter Mappings & Options
  • Tabular Data Stream & Commit Size
  • Table Locks & Batch Calculations.

SCD Transformation - ETL / DW

  • Data Analytics and Column Profiling
  • Data Sampling and Data Delta
  • Type I and Type II SCD Examples
  • Dimension Table Design, Surrogate Keys
  • SCD - Business Keys and Attributes
  • SCD - Historical Attributes and Status
  • Event Notifications and Emails
  • ETL - Partial and Full Cache Options
  • Fact Table Loads and ETL Load IDs
  • PIVOT, UNPIVOT and WebService T/Fs
  • TDS Sizing and Memory Options. 

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.

Master - Child Packages & Fact Loads

  • Configuring Master Packages, Parameters
  • Configuring Child Packages, Parameters
  • Parameter Bindings, Execute Process
  • Fact Loads with SSIS CDC Controls
  • OLE DB Transformation and Parameters
  • ADO.Net Connection Limitations in SSIS
  • Solutions to Data Delta Options. 

Course Description

What you will learn in this SSIS training course?

  1. Connecting to particular data source with Connection Managers.
  2. Data cleansing and profiling for improving data quality.
  3. Importance of data integration process.
  4. Constraints and event handlers in SSIS.
  5. Build Reports for any Category of Data. 

Who should take this SSIS training course?

  • Business Intelligence, database and data warehousing professionals
  • Software and ETL developers.

Who is the target audience?

  • People who are having basic knowledge about SQL
  • Students who wish to enter a Business Intelligence career.

FAQ

Do you have self paced training?

Yes, we offer self paced training

How do you provide training?

We offer three different modes of training. Instructor Led Live Training, Self Paced Training and Corporate Training

Do you offer any discounts?

Yes we offer discounts for group of 3 plus people.

Can I choose timings that suits my schedule?

Yes we are the only company where we work with students and offer flexible timings which fits your schedule

Who are the Instructors?

All our instructors are from MNC companies who have real time experience of more than 10 years.

Can I attend a demo session before joining?

Yes we offer a free demo session with the instructors. The trainer will answer all your queries and share the course agenda.

Course Reviews

Sujith

It was a great experience to undergo and get certified in the SSIS Course from LTB. As a working professional, it has not only given me an exposure to the domain, but also helped me learn cross technologies and develop an inclination towards it. Thank you.

Chandra

I Strongly Recommend Live Trainings Bangalore is the best for SSIS Training. Team was very Supportive. Excellent Course Content. Thanks you.

Suraj

Well, I took SSIS online training course from Live Trainings Bangalore and now I am an expert in Course. Industry expert trainers, great format, clear explanations, extremely well presented and overall completely satisfactory. Trust me guys, you will love this training. Highly recommended!