SQL Server Integration Services


  • 4.5/5.0
  • 1000+ Enrolled
  • All levels
  • Last updated 1/2025
  • English

Course description

SSIS course is designed to provide participants with a comprehensive understanding of SQL Server Integration Services (SSIS) for data integration, ETL (Extract, Transform, Load), and data warehousing solutions. SSIS is a powerful tool that allows you to automate the process of data migration, data transformation, and data synchronization between various data sources.

The course will cover both the basic and advanced features of SSIS, including data flow tasks, control flow tasks, transformations, sources, destinations, and debugging techniques. By the end of this course, participants will be able to design, deploy, and maintain complex ETL solutions using SSIS.

Prerequisites :
  • Basic knowledge of SQL
  • Experience with Microsoft SQL Server
  • Familiarity with Data Warehousing Concepts
  • Knowledge of Basic Programming Concepts
  • Experience with File Systems and Data Sources
What you’ll learn

  • SSIS Over Flow

  • Data Conversion Transformation
  • Multicast Transformation
  • Conditional Split Transformation
  • Sort Transformation
  • Merge Transformation
  • Merge Join Transformation
  • Union All Transformation
  • Aggregate Transformation
  • Derived Column Transformation
  • OLEDB Command
  • Row Count
  • Copy Column
  • Character Map
  • Slowly Changing Dimension
  • Script Component
  • Cache Transformation
  • Lookup Transformation
  • Fuzzy Lookup File

  • Flat File
  • Excel File
  • OLEDB Source

  • Excel
  • Flat File
  • OLEDB Destination
  • Record Set
  • SQL Server

  • Bulk Insert Task
  • Execute Package Task
  • Execute Process Task
  • File System Task
  • FTP Task
  • Split Task
  • Send Mail Task

  • For Loop
  • For Each Loop
  • Sequence Container

  • Precedence Constraint
  • Data Enable Viewer
  • Dynamic Connection
  • Debugging
  • Check Points
  • Break Points

  • Configuration File
  • Logging File
  • Event Handling
  • Deployment
  • Changed Data Capture

Course Information


  • Course Name Looker BI
  • Lectures 30
  • Duration 4h 50m
  • Level Beginner to Expert
  • Course Type Online/Offline
  • Language English
  • Faculty / Exp Keshav / 5yrs
  • Certificate Yes