Data integration using SQL Server Integration Services (SSIS)

Data integration using SQL Server Integration Services (SSIS)

SQL Server Integration Services is a platform for building enterprise-level data integration and data transformation solutions. You will learn to use Integration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data.

Total Lessons

20 Lessons

Program Duration

6 Weeks Only

Learning Format

Data integration using SSIS

Course Overview

Sale!

Data integration using SQL Server Integration Services (SSIS)

1,499.007,999.00

This course will help you work with Integration Services packages in the context of a data warehouse development project to perform extract, transform, and load operations.

This 6 -week duration course will teach you how to apply Integration Services features to build packages that support the extract, transform, and load operations of a data warehouse.

It covers design patterns for staging data and for loading data into fact and dimension tables. In addition, this course describes how to enhance ETL packages with data cleansing techniques and offers insight into the buffer architecture of the data flow engine to help package developers get the best performance from packages.

Offline Course
(Self-Paced)

  • 35 hrs of self-learning
  • 4-months of LMS Access
  • 35 hrs of self-driven exercises/quiz

Online Course
(Trainer Driven Virtual Sessions)

  • Live sessions of 35 hrs
  • 35 hrs of guided exercises/quiz
  • Guided Project and Viva presentation
  • 4-months of LMS Access
Clear

Description

Learn to use Integration Services to solve complex business problems, loading data warehouses, cleansing and mining data, and managing SQL Server objects.

Additional information

Classes

Offline Course, Online Course

Reviews

There are no reviews yet.

Be the first to review “Data integration using SQL Server Integration Services (SSIS)”

Your email address will not be published.

Key Highlights


Online Courses


  • Access to Question Bank/Exams
  • LMS Access for 4 months post enrolment
  • Access to Lagozon Technology Team
  • Training/Internship Certificates
Read more

Offline Courses


  • Access to Question Bank/Exams
  • LMS Access for 4 months post enrolment
  • Course completion certificate

Course Curriculum

  • Introduction to SSIS
  • Creating a Project and Package
  • Developing the Flow Task
  • Managing SSIS Projects
  • Connections and Variables in a Package
  • Sharing Connections between Packages
  • Usage of Projects Parameters in Expressions
  • Creating the Catalog
  • Deploying the Catalog
  • Extract and Transform Data
  • Executing Packages with an Environment
  • Implementing and Transforming a Data Flow
  • Lookup, Conditional Split and OLEDB Command
  • Using Data Viewer
  • Loading Data and Implementing Control Flow
  • Executing T-SQL or Stored Procedures
  • Configure and Deploy SSIS Packages
  • Deploying SSIS Solutions
  • Environments and Mapping
  • Industry Relevant Project

Skills Covered

Microsoft SQL

ETL

Microsoft Business Intelligence

Integration Services

Data Warehouse

Who can apply?

  • Anyone who is passionate to learn and enhance skills in data analytics
  • IT/ Non-IT Professionals
  • College Graduates
  • BI Professionals
  • Project Managers
  • Engineers from all Non-IT branches – including Civil. Mechanical, Electrical
  • MBA and BBA Students from all specializations
  • BCA/MCA