EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up

SSIS ETL Tools- SQL Server Integration Services

Home Courses 00 IT & CS SSIS ETL Tools- SQL Server Integration Services

Course Overview

eduCBA brings you this Awesome course on SSIS Training . This detailed course will help you understand all the important concepts and topics of SSIS Training.

356
6 - 12 hours 5h 34m | 44 Videos | 77394 Views | Intermediate  Intermediate
trigger text
hidden content

SSIS – SQL Server Integration Services:

MicrosoftSQL Server Integration Services (SSIS) is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing. SSIS includes graphical tools and wizards for building and debugging packages.

This training gives you a chance to learn about Microsoft SQL Server Integration Services (SSIS) that will give you the confidence and skills to use this Business Intelligence tool. This tutorial walks you through SSIS Designer to create a simple ETL package that includes looping, configurations, error flow logic and logging.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

The course has been divided into three sections viz;

    • Introduction- We shall introduce the tools to you and explain you the advantages and uses.
    • Use of Functions- We in detail look at the various functions such as use of Aggregate Data transformation support, how to use count and count distinct, going to learn database to database transformation, how to input a data from database to text, going to learn group by function, using maxmin and sum function, audit, how to use copy column, derived column, lower to upper etc.
    • Data Viewer- Here we will see How to use data viewer using column, data viewer using grid, data viewer using histogram and dataviewer using scatter.

There are various other great number of functions that you will learn through this training.

Target Customers:

      • Students who wish to have a career in Business Intelligence

Pre-Requisites:

      • Familiar with fundamental database operations
      • Basic Knowledge of SQL Server Integration Services although not compulsory

Back to top ▴

View Offline

View courses without internet connection with a Lifetime Membership
View courses without internet connection with a Lifetime Membership

View Offline - Internet-free viewing with your iOS or Android App

Watch offline with your iOS/Android app.

Start Your Free Trial Now

You can download courses from your iOS/Android App.

Primary Sidebar

Merger Modeling - Comcast Corp and Time Warner Inc.

Curriculum

1. Introduction

  • Introduction to SSIS
  • More Details On SSIS

2. Use of Functions

  • Use of Aggregate Data Transformantion Support
  • How To Use Count And Countdistinct
  • Going to Learn Database to Database Transformantion
  • How to Input a Data from Database to Text
  • Going to Learn Groupby Function
  • Using Maxmin and Sum Function
  • Audit
  • How to use Copy Column
  • How to use Data Conversion
  • How to use Derived Column
  • How to use Lowerto Upper
  • How to use Upper to Lower
  • Excel to Database Transfer
  • Oledb to Excel Transfer
  • Conditional Split
  • Merge
  • Merge Join
  • Merge Using Sort
  • Multicast
  • Sort
  • Sort- Remove Duplicate
  • Union All

3. Data Viewer

  • How to use Data Viewer Using Column
  • How to use Data Viewer Using Grid
  • How to use Data Viewer Using Histogram
  • How to use Dataviewer Using Scatter

4. More use of Functions

  • How to use Fuzzy Grouping
  • How to use Fuzzy Lookup
  • How to use Lookup Transformation
  • How to use Percentage Sampling
  • How to use Pivot Data Transformation
  • How to use Rowsampling
  • How to use Term Extraction
  • How to use Term Lookup
  • How to use Unpivot
  • How to use Create Delete Tableusing Execute SQLTask
  • How to use Execute SQLTask
  • Praticals on Execute SQL Task
  • How to use File System Task
  • How to use Foreachloop
  • More Details on Foreachloop
  • How to use For Loop Container
X

Loading the player...

Related Job Oriented Programs

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Company
  • About us
  • Alumni Speak
  • Contact Us
  • Log in
  • Sign up
Work with us
  • Careers
  • Become an Instructor
EDUCBA for Enterprise
  • Enterprise Solutions
  • Explore Programs
  • Free Courses
  • Free Tutorials
  • EDUCBA at Coursera
  • EDUCBA at Udemy
Resources
  • Blog
  • Self-Paced Training
  • ExamTurf
  • Verifiable Certificate
  • Popular Skills Catalogue
  • Exam Prep Catalogue
Popular Categories
  • Lifetime Membership
  • All in One Bundles
  • Featured Skills
  • New & Trending
  • Fresh Entries
  • Finance
  • Data Science
  • Programming and Dev
  • Excel
  • Marketing
  • HR
  • PDP
  • VFX and Design
  • Project Management
  • Exam Prep
  • Learning Paths @ $49
  • All Courses
  • Terms & Conditions
  • Disclaimer
  • Privacy Policy & Cookie Policy
  • Shipping Policy

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

🚀 Limited Time Offer! - 🎁 ENROLL NOW