Training For SSRS

SSIS Training Course Content

SSRS Training Course Contents

SSIS Training In Pune & SSIS Training In Vishrantwadi

SSIS provides Data Extraction, Consolidation and Loading Options (ETL), SQL Server Coding enhancements, Data Warehousing and Customizations for SQL Server Developers, Administrators, BI Engineers and Data Analysts. In our LIVE Online Training, we deal with complete SSIS Design and Development including SCD, Profiling, Tuning and Customizations. All sessions are completely practical and realtime.

Program Objectives

  • Leverage SQL Server Integration Services to produce BI solutions
  • Create OLAP cubes and automate maintenance with XMLA scripts
  • Extend hierarchies and exploit advanced dimension relationships
  • Build custom solutions with MDX
  • Implement key performance indicators to monitor business objectives
  • Make smarter business decisions with data-mining techniques

Enosis Learning Advantage

  • More than 6 Years of experience in SSIS Training
  • Trained 1000+ Students so far.
  • Strong Theoretical & Practical Knowledge
  • SSIS certified Professionals
  • Certified Trainers from the IT industry with rigorous understanding of specialized domain.
  • Lecture contents prepared by Industry expert
  • Live Projects to work on with IT industry standards.
  • Focus on cross cultural and various onshore and offshore client oriented trainings
  • Weekly workshop from industry experts
  • An innovative teaching methodology delivers in- depth knowledge with quality tailored programs that maximize a return on your investment.
  • Strategic Association for global certification

Eligibility

  • SQL Server T-SQL Queries

Program Structure

The course will have regular classroom Lectures, Practical Sessions, Seminars, Tutorials, Case Studies, Assignments and Exams.

Duration

3 Months

Syllabus

INTRODUCTION TO INTEGRATED SERVICES

  • Defining SQL Server Integration Services
  • Exploring the need for migrating diverse data
  • The role of business intelligence(BI)

SSIS ARCHITECTURE AND TOOLS

  • Leveraging the Extract, Transform and Load (ET L) Capabilities of SSIS
  • Running Wizards for Basic Migrations
  • Creating Packages for Complex Tasks
  • Distinguishing Between Data Flow Pipeline and Package Runtime
  • Executing Packages On The Client Side Or Hosted in The SSIS Service

UTILIZING SSIS OBJECTS

  • Configuring connection managers
  • Adding data flow tasks to packages
  • Reviewing progress with data viewers
  • Assembling tasks to perform complex data migration
  • Migrating multiple files with FOREACH container
-

EXTENDING CAPABILITIES WITH SCRIPTING

  • Extending functionality with the Script Task
  • Debugging, breakspoints, watches

ERROR HANDLING

LOGGING AND TRANSACTIONS DEPLOYMENT

OPERATING SYSTEMS AND LEVEL TASKS

  • Copying, Moving And Deleting Files
  • Transfering Files With The Ftp Task
  • Communicating WSources
  • Sending Messages Through Mail

PERFORMING TRANSFORMS ON COLUMNS

  • Converting and calculating columns
  • Transforming with Charecter Map

COMBINING AND SPLITTING DATA

  • Profiling data
  • Merge, Union, Conditional Split
  • Multicasting and converting data
  • The string Data Type

PERFORMING DATABASE OPERATIONS

  • Executing a SQL task
  • Bulk inserting data from text files

ORGANIZING PACKAGE OVERFLOW

  • Defining success, failure, completion and expression precedence constraints
  • Handling events and event bubbling

DESIGNING ROBUST PACKAGES

  • Choosing log providers
  • Adapting solutions with package Configurations
  • Auditing package execution results