SSIS Online Training

Interview Questions Online Exam MSBI Money Saver Pack

SQL Server Integration Services (SSIS) is a component of Microsoft SQL Server database software which can be used to perform a broad range of data migration, Data integration and Data Consolidation tasks. It features fast and flexible data warehousing tool used for data extraction, transformation and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates multidimensional cube data. SSIS is the new data transformation standard for SQL Server 2005 onwards and has replaced the old SQL Server Data Transformation Services.

This extensive SSIS training Course is provided for participant to have in depth knowledge of Developing packages using different tasks and providing ETL solutions based on different requirements.

SSIS Training Modules: 10
Total Video Duration: 17 Hours 20 Minutes
Mrs. Vandana Soni
A well known trainer at Deccansoft for more than 6 years, she is a specialist in SQL Server 2008 and has taught well over many students. Her uniqueness lies in conducting her classes with ease and clarity, making her students understand even the most complex queries with no difficulty at all.

Online SSIS Training Course Objectives

The course will allow learners to

  • Understand MSBI application development Life Cycle.
  • Understand basic Data Warehousing Concepts.
  • Understand the Concept of OLTP and OLAP.
  • Use SSDT (SQL Server Data Tools) in detail for development of SSIS packages.
  • Learn SSIS Architecture, Components of SSIS.
  • Gain complete understanding of different control flow tasks, containers and precedence constraints.
  • Gain complete understanding of wide variety of data flow Sources, Transformations and Destinations.
  • Learn to work with variables, data types, functions, expressions and parameters and providing Dynamism in SSIS.
  • Develop packages using different tasks and different Transformations based on real time requirements.
  • Learn working with event handler, Logging, Configuration Files.
  • Learn Error Handling and Debugging in SSIS.
  • Learn package deployment and project deployment.
  • Gain understanding of Security and Package management.

SSIS Training Prerequisites

Participants are need to be familiar with basic RDBMS concepts with skills to write queries. Working experience on any RDBMS would be an added advantage.

Star Image To watch Free Videos you have to Login and creating of account is absolutely free. It will help you to understand the Quality of our Training and the Simple Language with which our Trainers have explained the topic.
LiveZilla Live Chat Software