Mindmajix
For individuals


Recorded Video Learning

  • Access to high quality Videos
  • Self-paced learning content designed by Experts

Instructor Led Live Online Training

  • Live Interactive training
  • Certified & industry expert Trainers
  • On Demand Dedicated Cloud lab access
  • 24x7 Support & Assistance
  • Fast-track / Regular / Weekend


  • Start training at your convenient time
  • For business


    Corporate training

    • Self-paced e-learning and/or instructor-led options)
    • Course, category, and all-access pricing
    • Enterprise-class learning management system (LMS)
    • Enhanced reporting for individuals and teams
    • 24x7 assistance and support

    Course Details

    SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that is created to perform a broad range of data migration tasks, data integration and workflow applications. 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. The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data.

    SSIS Training Overview

    Learn to build and manage data integration solutions under expert guidance from our training team. Have an overview of the best practices in action and dive deep into the SSIS engine, SSISDB catalog, and security features. Using the developer enhancements in SQL Server 2012 and the flexible SSIS toolset, you’ll handle complex data integration scenarios more efficiently—and acquire the skills you need to build comprehensive solutions.

    In SSIS online training, you will learn how to:

     Use SSIS to extract, transform, and load data from multiple data sources

    Apply best practices to optimize package and project configuration and deployment

    Manage security settings in the SSISDB catalog and control package access

    Work with SSIS data quality features to profile, cleanse, and increase reliability

    Monitor, troubleshoot, and tune SSIS solutions with advanced features such as detailed views and data taps

    Load data incrementally to capture an easily consumable stream of insert, update, and delete activity

    SSIS Training Curriculum

    Need for SSIS and ETL / DWH Entities

    Data Warehouse Design and SSIS

    DW Components and SSIS Tools

    SSIS Configuration and Catalog DB

    Control Flow Tasks Architecture

    Data Flow Tasks and ETL Architecture

    Data Pipelines and Data Buffers

    SSIS Data Types and Data Conversions

    SSIS Local and Global Variables

    Dynamic Precedence Constraints

    Dynamic Connection Managers in DFT

    Data Flow Transformations and Usage

    Handling ETL Enumerations in SSIS

    ETL with Loops & Indexed Connections

    Conditional Precedence Expressions

    SSIS Parameters Usage and Variables

    Control Flow Breakpoints – Usage

    Data Flow Data Viewers and Audits

    SSIS Expressions & Debugging Options

    Debugging SSIS Packages & Limitations

    Debugging Procedures in Realtime

    Row and Column Transformations

    Combining and Splitting Data

    Performing SQL Database Operations

    MERGE Vs UNION ALL Transformations

    Lookup, Fuzzy Lookup and Grouping

    SORT Vs AGGREGATE Transformations

    OLE-DB Command Usage & Parameters

    Derived Columns & Data Conversions

    SSIS Parameter Mappings & Options

    Tabular Data Stream & Commit Size

    Table Locks & Batch Calculations

    SSIS SCRIPT Task (.NET) and Coding

    Scripts for Control Flow Limitations

    Scripts for Data Flow Limitations

    ADO Connections and DataAdapters

    Custom Code (.NET) Handling in SSIS

    Script Tasks & Notify Operators

    SSIS Expressions and Iterations

    Data Analytics and Column Profiling

    Data Sampling and Data Delta

    Type I and Type II SCD Examples

    Dimension Table Design, Surrogate Keys

    SCD – Business Keys and Attributes

    SCD – Historical Attributes and Status

    Event Notifications and Emails

    ETL – Partial and Full Cache Options

    Fact Table Loads and ETL Load IDs

    PIVOT, UNPIVOT and WebService T/Fs

    TDS Sizing and Memory Options

    CHECKSUM Transformation in DW

    CACHE Transformation & Usage

    Partial and Full Cache Options

    SSIS Transactions & Isolation Levels

    Checksum for Type 1 and Type 2

    SSIS Checkpoints and Limitations

    CDC Sources and Controls in SSIS

    CDC Tables and Change Tracking

    Dynamic CDC Connections & Logging

    Using CDC for Dimension Loads (ETL)

    Configuring Master Packages, Parameters

    Configuring Child Packages, Parameters

    Parameter Bindings, Execute Process

    Fact Loads with SSIS CDC Controls

    OLE DB Transformation and Parameters

    ADO.Net Connection Limitations in SSIS

    Solutions to Data Delta Options

    SSIS Package Events and Audits

    Package Level Event Handling Options

    SSIS Event Bubbling Escalations

    SSIS Logging & Project Connections

    Windows Event Logs and SSIS Jobs

    SQL Server Logging and Audit Tables

    Global Connections and Project Audits

    Logging Fuzzy Data Loads and ETL

    Need For XML Connections & ADO

    XML Connections & BLOB Data

    Using SSIS Data Profile Viewer Task

    Project Builds & Bit Level Options

    Creating ISPAC Files : SSIS 2014, 2012

    Securing SSIS Manifest Files (PROD)

    64 bit and 32 bit Configurations

    Validation & Verification Techniques

    Configuration Options and Connections

    Control Loops and Indexed Connections

    Migrating SSIS ISPAC Files & Options

    SSIS Package Backups and Passwords

    Project Level Passwords and Encryption

    SSIS Deployment and SSIS Catalog DB

    SSIS Catalog Project Files and Options

    Security – Logins, Users, SSIS Admin

    SSIS Catalog Folders in SSISDB

    Post Deployments & Connections

    Package Configurations, Parameters

    SSIS Package Validations, Reports

    SSIS Package Executions, Reports

    Checksum Management and Encryptions

    SSIS Package Scripts with T-SQL

    Tuning Deployment and Configurations

    SSIS Package Performance Reports

    SSIS Package Security Options

    Encrypting SSIS Catalog Packages

    SSIS Package Store and SSISDB

    Security Audits Reports and Limitations

    SSIS Folder Level Security Options

    Project Level Security and SSIS Roles

    Container and Package Logging

    SSIS Project Migration Utilities

    Importing ISPAC and Manifest Files

    SSIS Project Import Wizard – Usage

    Upgrading Packages & Configurations

    Command-Line Deployments & Options

    Package Backup Procedures & Options

    Scheduling Packages (Jobs), Operators

    Upgrading SSIS 2012 to SSIS 2014

    MSDB and SSIS Catalog DB Files

    Comparing SSIS 2012 and 2014

    SSIS ETL and DW – Comparisons

    Faqs

    Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.

    We record each LIVE class session you undergo through and we will share the recordings of each session/class.

    Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

    If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

    The Training itself is Real-time Project Oriented.

    Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

    There are some Group discounts available if the participants are more than 2.

    As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, India and other parts of the world. We are located in USA. Offering Online Training in Cities like

    Minneapolis, Melbourne, Jacksonville, Davidson, Murfreesboro, Auckland, Carlsbad,  San Marcos, Tacoma, Bellevue, Garland, Raleigh-Cary, Fort Lauderdale, Miami, Toronto, Wellington, Gilbert, Tempe, Alexandria, Chandler, Scottsdale, Peoria, Honolulu, Raleigh, Nashville, Plano, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Hyderabad, Bangalore, Pune, Mumbai, Delhi, Dubai, Doha, Brisbane, Perth etc…

    SEND A QUERY

    Course Reviews

    4.5

    1537 ratings
    • 51076
    • 4231
    • 3154
    • 261
    • 115

    Drop Us A Query


    Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
    Course Adviser

    Fill your details, course adviser will reach you.