Skip to content
SSIS (SQL Server Integration Services): Complete Guide to Data Integration and ETL cover image
Play overlay
Preview this course

SSIS (SQL Server Integration Services): Complete Guide to Data Integration and ETL
Uplatz

Self-paced videos, Lifetime access, Study material, Certification prep, Technical support, Course Completion Certificate

Summary

Price
£100 inc VAT
Or £33.33/mo. for 3 months...
Study method
Online, On Demand
Duration
29.7 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Reed Courses Certificate of Completion - Free
  • Uplatz Certificate of Completion - Free

Overview

Uplatz provides this end-to-end course on SSIS (SQL Server Integration Services): Complete Guide to Data Integration and ETL. It is a self-paced course with video lectures. You will be awarded Course Completion Certificate at the end of the course.

SQL Server Integration Services (SSIS) is a powerful platform created by Microsoft for building enterprise-level data integration and workflow solutions. It's a core part of the Microsoft SQL Server database software suite. Although primarily used for extract, transform, and load (ETL) processes, it's also capable of automating a wide variety of data management tasks.

How SSIS Works

SSIS lets you create packages containing a series of tasks and data flows. These packages define how data is extracted from various sources, modified to meet specific requirements, and loaded into target destinations.

  • Extraction: SSIS can extract data from many sources, including databases, flat files, XML files, and web services.
  • Transformation: SSIS provides a rich set of transformations for cleaning, aggregating, merging, and converting data. You can perform tasks like data type conversions, string manipulations, calculations, and lookups.
  • Loading: SSIS can load data into various destinations, such as databases, data warehouses, and cloud platforms.

Key Features of SSIS

  • Graphical Development Environment: SSIS provides a drag-and-drop interface for designing workflows, making it easy to create and manage complex data integration processes visually.
  • Built-in Transformations: SSIS offers a wide range of pre-built transformations, reducing the need for manual coding and speeding up development time.
  • Data Flow Engine: The data flow engine in SSIS is optimized for high-performance data movement and transformation, enabling efficient processing of large data volumes.
  • Extensibility: SSIS allows you to create custom components and tasks, extending its functionality to meet specific needs.
  • Connectivity: SSIS provides connectors to various data sources, including SQL Server, Oracle, Excel, and more.
  • Control Flow and Data Flow: SSIS separates control flow (the order of task execution) from data flow (the transformation of data), providing flexibility and organization.
  • Logging and Error Handling: SSIS includes robust logging and error handling capabilities, helping you monitor package execution and troubleshoot issues effectively.

Benefits of Learning SSIS

  • High Demand: SSIS is a widely used ETL tool, and skilled SSIS developers are in high demand across various industries.
  • Career Advancement: Learning SSIS can enhance your career prospects and open up opportunities in data engineering, data warehousing, and business intelligence.
  • Increased Efficiency: SSIS automates data integration tasks, saving time and reducing manual effort.
  • Improved Data Quality: SSIS helps ensure data quality by providing tools for data cleansing and transformation.
  • Better Decision Making: By integrating data from various sources, SSIS enables better decision-making based on comprehensive and accurate data.

If you're interested in a career in data management or business intelligence, learning SSIS is a valuable investment. It's a powerful tool that can help you efficiently handle and integrate data from various sources, leading to more informed business decisions.

Certificates

Reed Courses Certificate of Completion

Digital certificate - Included

Will be downloadable when all lectures have been completed.

Uplatz Certificate of Completion

Digital certificate - Included

Course Completion Certificate by Uplatz

Curriculum

1
section
54
lectures
29h 45m
total

    • 1: Part 1 - What is ETL Preview 50:37
    • 2: Part 2 - What is ETL 19:19
    • 3: Part 1 - Architecture of SSIS 58:01
    • 4: Part 2 - Architecture of SSIS 54:34
    • 5: Part 1 - Components of a Package - Data Flow 1:36:42
    • 6: Part 2 - Components of a Package - Data Flow 1:16:13
    • 7: Part 1 - Components of a Package - Control Flow 1:30:52
    • 8: Part 2 - Components of a Package - Control Flow 1:02:47
    • 9: Components of a Package - Connection Managers 1:10:15
    • 10: Part 1 - Transformations - OLEDB Source 24:38
    • 11: Part 2 - Transformations - OLEDB Source 30:49
    • 12: Part 3 - Transformations - OLEDB Source 1:01:54
    • 13: Part 1 - Transformations - Flat File Source 35:33
    • 14: Part 2 - Transformations - Flat File Source Preview 1:12:47
    • 15: Part 1 - Transformations - Excel Source 43:40
    • 16: Part 2 - Transformations - Excel Source 49:40
    • 17: Part 1 - Transformations - OLEDB Destination 44:57
    • 18: Part 2 - Transformations - OLEDB Destination 33:09
    • 19: Part 1 - Transformations - Flat File Destination 11:54
    • 20: Part 2 - Transformations - Flat File Destination 18:24
    • 21: Part 1 - Transformations - Excel Destination 15:13
    • 22: Part 2 - Transformations - Excel Destination 15:11
    • 23: Part 1 - Transformations - Data Conversion 12:50
    • 24: Part 2 - Transformations - Data Conversion 23:10
    • 25: Part 1 - Transformations - Derived Column 27:07
    • 26: Part 2 - Transformations - Derived Column Preview 33:03
    • 27: Part 1 - Transformations - Conditional Split 23:04
    • 28: Part 2 - Transformations - Conditional Split 30:31
    • 29: Part 1 - Transformations - Aggregate 46:21
    • 30: Part 2 - Transformations - Aggregate 38:35
    • 31: Part 1 - Transformations - Sort 13:46
    • 32: Part 2 - Transformations - Sort 19:00
    • 33: Part 1 - Transformations - Merge Join 16:10
    • 34: Part 2 - Transformations - Merge Join 22:08
    • 35: Part 1 - Transformations - Merge 13:14
    • 36: Part 2 - Transformations - Merge 26:47
    • 37: Part 1 - Transformations - Multicast 13:24
    • 38: Part 2 - Transformations - Multicast 19:46
    • 39: Part 3 - Transformations - Multicast 22:23
    • 40: Part 1 - Transformations - Union All 15:22
    • 41: Part 2 - Transformations - Union All 16:41
    • 42: Part 1 - Transformations - Lookup 42:27
    • 43: Part 2 - Transformations - Lookup 31:36
    • 44: Part 1 - Transformations - Row Sampling 16:39
    • 45: Part 2 - Transformations - Row Sampling 23:33
    • 46: Part 1 - Transformations - Percentage Sampling 18:09
    • 47: Part 2 - Transformations - Percentage Sampling 20:18
    • 48: Part 3 - Transformations - Percentage Sampling 07:31
    • 49: Part 1 - Transformations - Copy Column 16:05
    • 50: Part 2 - Transformations - Copy Column 13:46
    • 51: Part 1 - Transformations - OLEDB Command 20:40
    • 52: Part 2 - Transformations - OLEDB Command 20:48
    • 53: Part 1 - Variables 53:42
    • 54: Part 2 - Variables 29:13

Course media

Description

SSIS (SQL Server Integration Services) - Course Syllabus

1. Introduction to ETL and SSIS

  • Overview of ETL (Extract, Transform, Load) concepts

  • Role of SSIS in ETL processes

2. Architecture of SSIS

  • Understanding the SSIS runtime architecture

  • How SSIS integrates with SQL Server

3. Components of an SSIS Package

  • Data Flow: Managing data transformations and flow

  • Control Flow: Sequencing tasks and workflows

  • Connection Managers: Configuring source and destination connections

4. Data Sources in SSIS

  • OLEDB source

  • Flat file source

  • Excel source

5. Data Destinations in SSIS

  • OLEDB destination

  • Flat file destination

  • Excel destination

6. Key SSIS Transformations

  • Basic Transformations

    • Data conversion

    • Derived column

    • Copy column

  • Conditional Logic Transformations

    • Conditional split

  • Aggregation and Sorting Transformations

    • Aggregate

    • Sort

  • Join and Union Transformations

    • Merge join

    • Merge

    • Union all

  • Advanced Transformations

    • Lookup

    • Row sampling

    • Percentage sampling

    • OLE DB command

7. Multi-Cast Transformation

  • Understanding the multi-cast transformation and its applications

8. Variables and Parameters in SSIS

  • Using variables for dynamic configurations

  • Defining and managing package parameters

Who is this course for?

  1. Data Professionals:

    • Data Analysts

    • Data Engineers

    • ETL Developers

    • Database Administrators (DBAs)

  2. IT Professionals:

    • Software Developers

    • System Architects

    • IT Consultants

  3. Business Intelligence (BI) Professionals:

    • BI Developers

    • BI Analysts

    • Data Warehouse Specialists

  4. Students and Aspiring Data Professionals:

    • Individuals looking to build a career in data integration, ETL, or data warehousing.

  5. Professionals Transitioning to Data Roles:

    • Professionals from non-data backgrounds (e.g., finance, marketing, operations) who want to upskill in data integration and ETL processes.

  6. Organizations and Teams:

    • Teams looking to standardize their ETL processes using SSIS.

    • Organizations implementing or migrating to SQL Server-based data solutions.

Requirements

Passion and determination to achieve your goals!

Career path

  • ETL Developer
  • Data Integration Specialist
  • BI Developer
  • Data Engineer
  • SQL Developer
  • SSIS Developer
  • Database Administrator (DBA)
  • Data Analyst
  • Analytics Engineer
  • Data Architect
  • Business Intelligence Analyst
  • Systems Analyst
  • Reporting Analyst
  • Application Support Engineer
  • Solution Architect
  • Data Consultant
  • Cloud Engineer
  • Data Scientist
  • Machine Learning Engineer
  • DevOps Engineer
  • Enterprise Architect

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Ask a question

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: Big data, Database, SQL, IT, Coding
Related searches: Online courses

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2025. All rights reserved.