Online SSIS Videos

SSIS Training Videos with Online Lab

On demand Training Videos accessible at your comfortable timings. Our SSIS Video Training Service (Course Code: VC04) offers complete realtime practical knowledge transfer services for aspiring and working SQL BI / ETL Developers. Study and Practice Material with Realtime Case Study, Free LIVE Server Access for online Lab are included in this course. Register for SSIS & ETL/DW Video Training


SSIS (ETL & DWH) Video Training - How it works?

Real-time, Practical Training Videos, accessible 24x7. Study, Practice Material and Lab Work for every video. Trainer available for doubts clarifications and support. Theory Material to be provided in Advance.

Type: 100% Practical & Example Based, Real-time
No. of Videos: 14 Videos (Duration: 80 minutes per video)
Course Fee: INR 7000/- (USD 120) payable in 2 installments

This Video Course includes one Real-time Project. Download Brochure
Program Highlights & Trainer Profile

  • Completely Real-time and Practical
  • Video wise Lab Work and Tasks
  • One Real-time Case Study
  • Certifications & Interview Guidance
  • Interview FAQs & Resume Guidance
  • 24x7 LIVE Server with Lab, Support

Trainer: Mr Sai Phanindra T     Register Today
 

This New Curriculum applicable for registrations from Feb 20th, 2017 (New content being updated!)
Basic SSIS Development & ETL - DWH Advanced SSIS Development (DWH) & Deployments

VIDEO 1: SSIS INTRODUCTION, INSTALLATION & TOOLS

  • Need for SQL Server Integration Services (SSIS)
  • Advantages of SSIS for Data Loads, Operations, ETL
  • SSIS Tools : SSDT (SQL Server Data Tools), Wizards
  • SSIS Design and LIVE (Deployment) Environment
  • Understanding Datawarehouse Design and ETL Process
  • DWH and ETL Structures, Implementations in SSIS
  • Installing SSIS with SQL Server 2016 and 2014
  • Understanding SSIS Catalog DB Encryptions and CLR
  • SSIS Folders, SSIS DB Usage and Program Flow
  • SSIS Configuration Options and SSIS Catalog Database
  • SSDT Tool: SQL Server Data Tools (Visual Studio)
  • SSDT 2015 Installation, Verification of SSIS Templates
  • SSDT 2013 Installation, Verification of SSIS Templates
  • Understanding SSIS Developer Environment (SSDT)
  • Basic Vocabulary - SSIS, ETL, DWH, Data Flow
  • SSIS Package Environment, SSDT Project Creation
  • SSIS Video Training - Lab Plan, Resources
Register

VIDEO 2: SSIS PACKAGES: EXTRACT - TRANSFORM - LOAD (ETL)

  • Control Flow Tasks - Architecture, Purpose and Usage
  • Data Flow Tasks - Architecture, Purpose and Usage
  • Creating SSIS Packages For Basic Data Flow Operations
  • SSIS Solutions, Projects and Package Creation. Tasks
  • Need For Data Pipelines & Connections in Data Flow Tasks
  • Understanding SSIS Package (Program) Execution Process
  • Working with Data Flow Objects / Tasks in SSIS
  • Basic Data Extraction Drivers / Proviers with Data Flow
  • Using OLE DB and SQL Server Connections - Usage
  • SSIS Package Creation Process - Using Constrol Flow Items
  • SSPI Interface Connections, Data Source, Initial Catalog
  • Using DTSX Files for SSIS Package Execution. Audits
  • SSIS Execution Context, SSIS Package Errors and Logs
  • Data Flow Transformation: Conditional Split, Expressions
  • Excel Connections, Sheets, & Memory References - Usage
  • Using Source Assistants, Destination Assistants @ SSIS
  • DAT File Imports, Data Flow Options, Adding Annotations
  • Common SSIS Package Errors & Solutions in Real-time
  • SSIS Project Configuration Options - Debugging, Bit Config
  • SSIS 64 Bit and 32 Bit Configuration Settings and Options
  • Error Outputs and Error Row Redirections in Data Flow Tasks

VIDEO 3: SSIS FAST LOADS, MERGE, UNION ALL, CONVERSIONS

  • Understanding ETL and DWH Implementations
  • Kimball Method of BI Design and Keys Concepts
  • Bulk Load Operations and Data Import Options in SSIS
  • Bypass Prepare and Execution Options with SQL Task
  • Historical Data Loads and Incremental Updates
  • Debugging Controls in SSIS - Variants and Limitations
  • Data Flow Debugging Controls and Data Viewer Options
  • Synchronous & Asynchronous Transformations, Data Loads
  • Row and Partial Blocking Transformations. Buffer Reuse
  • Fully Blocking Transformations - Buffer Reuse Restrictions
  • Examples to Avoid Fully Blocking Transformation in SSIS
  • MERGE Transformation and UNION ALL Transformation
  • SORT Transformation, NOSORT Options, Advanced Sort
  • Data Conversion Transformation, SSIS Expressions
  • Data Flow Tuning with Query Locks and Performance
  • Tuning Data Flow Tasks with Fast Loads Options (OLE DB)
  • Fast Load Options for Data Flow in OLE DB Connections
  • Tabular Data Stream (TDS) Packet Sizing and Tuning
  • SSIS Package Tuning with Row Size Calculations,Batches
  • Rows Per Batch Calculations - Variants, Commit Size Options
  • Transactions and Batch Scoped Data Loads in SSIS
  • Identity_Insert, Table Locks and Constraints in ETL
  • Comparing Regular Loads and Fast loads in ETL / DW

VIDEO 4: PIVOT, FUZZY LOOKUP, DATA CLEANSING, LOOPS

  • Importing Legacy Data, Need for Data Cleansing, Formatting
  • Understanding Denormalization and Keys Concepts. Need for OLTP
  • PIVOT Transformation Usage, Data Reads, Connection Assistant
  • Pivot Usage Values - Purpose and Implementation. Key Values
  • Lineage ID in SSIS - Purpose, Usage and Options. Data Mappings
  • SSIS Input Columns, Mappings and Source Column Values
  • Data Exchange Operations with Pivot Keys and Pivot Values
  • Using Data Viewer (Debugging) for Data Transfer Verifications
  • Fuzzy Lookup Transformation, Reference Table Connections
  • Exact, Fuzzy and Nomatch Data Cleansing with Conditional Split
  • Index Creation, Maintainenance for Faster Lookup Transformation
  • Threshold Values Selection, Search Delimeters and Options
  • Data Pipeline with _Similarity and _Confidence Columns. Usage
  • Data Conversion Transformation. Using NVARHAR Data, Options
  • Explicit Data Type Conversions and Usage. Error Redirections
  • ForEach Loop Container Usage. File Level Connections, Variables
  • Defining Variables for Connections. DFT and Control Flow Links
  • Connection Iterations, Connection Fetch and Index Mapping
  • Connection String Expressions with Package Variables, Usage
  • SSIS Package Audits for Dynamic Connections.

VIDEO 5: SSIS with ETL & DWH. SCD TRANSFORMATION TYPE 1, TYPE 2

  • A Sales Scenario for OLTP Database to Historical Data Loads
  • Introduction to Datawarehouse (DWH) - Purpose, Usage, Access
  • Technical Terms: Dimensions, Attributes, Members and Types
  • Dimension Tables, Fact Tables and Relations, Inferred Members
  • TYPE1 and TYPE2 Changes. ETL Implementation Techniques
  • Implementing Type I Changes (SCD) for DWH in a Sales Scenario
  • Dimensional Table Design for DWH using SCD - Type 1
  • Dimensional Table Design for DWH using SCD - Type 2
  • Initial Data Loads with Legacy Files (DAT, TXT, CSV), Data Marts
  • Working with Business Keys & non Identity Key Based Columns
  • Surrogate Keys and Alternate Business Keys - Purpose, Usage
  • Cascading Source OLTP / Stage Changes to DWH Inactive Rows
  • Changes to Fixed Attributes, Changing Attributes. Observations
  • CHanges to Historical Attributes. Inferred Member Updated
  • ETL Date Fields, Row Status Values and Transformations
  • Naming Conventions For SSIS Entities, Options & Reusability
  • Designing Dimensions for DW - Incremental and Historical Loads
  • Understanding OLE DB Connections for Incremental Data Loads
  • Identity Property and Attribute Key Types in SCD, Limitations
  • Historical Attributes and Data Delta Operations, Identification
  • SSIS Connection Assistants - Advantages, Package Reuse
  • SSIS SCD Transformation Limitations and Real-time Issues
  • Other ETL Techniques for DWH Design. SCD, Lookup, Merge, etc

VIDEO 6: CHECKPOINTS, TRANSACTION OPTIONS, EXECUTE SQL

  • Understanding Scripts for SSIS Control Flow. SQL Tasks
  • Execute SQL Task and OLE DB Queries - Connection Options
  • Transaction Options For SSIS Executables - Package Level
  • Precedence Constraints - Success / Failure / Completion Settings
  • Parallel and Sequential Task Executions. Options, Usability
  • SSIS Package Level Rollbacks and Restarts - Task Level
  • SSIS Checkpoints - Purpose and Usage with DFT Tasks
  • Checkpoint Files and SSIS Logging Options - Package, Tasks
  • Transactions with Checkpoint Files in SSIS Packages
  • Checkpoint Options - Advantages, Usage and Limitations
  • SSIS Variables - Creation and Usage in ETL DFT Scripts
  • Working with Static and Dynamic Variables. Usage Options
  • SSIS Package Level Parameters and Connnection Properties
  • SSIS Project Level Parameters - Connnection Options, Usage
  • SSIS Expressions, Default Values, and Data Types in Parameters
  • Linking Parameters and Variables with Expression Values
  • SSIS Parameters For Dynamic Control & Package Executions
  • Dynamic Connection Managers - Precedence Constraints
  • FailPackageOnFailure Options and Checkpoint Property Usage
  • Transaction Property : REQUIRED / SUPPORT, NOTSUPPORTED
  • Transaction Property Versus CHECKPOINT Files, Usage

VIDEO 7: CHECKSUM TRANSFORMATION @ DWH DESIGN

  • Need for Checksum Transformation in ETL Data Loads
  • Configuring Checksum Transformation : 2014, 2016 Versions
  • Checksum Transformation Logic and Parity Checks (CRC) Codes
  • Working with CHECKSUM Tranformation and Parity Bit Columns
  • Generating Checksum Values For Type I, Type II ETL Changes
  • Planning DWH Dimension Tables With Checksum Transformation
  • Working with Parity Bits & Conditional Lookup Transformation
  • Row Redirection Options & Lookup Match, NonMatch Row Output
  • OLE DB Command: SQL Statements and Input Parameters
  • Parameter Mapping Options and Dynamic SQL - Row Updates
  • Cache Transformation Usage - Memory Loads, CAW Files
  • Memory Connections and Reuse. Lookup with Cache Options
  • Tuning Lookup : Caching Options and Index Options
  • FULL CACHE : Usage Options. NO CACHE: Usage Options
  • Cache Connection Manager Issues and Performance
  • Pre-ETL Data Load Operations with Memory Connections
  • Lookup with NOCACHE Options. Advantages and Precautions
  • Understanding Dependent Data Flow Tasks and Usage
  • Post ETL, Derived Column and Fuzzy Transformations
  • SSIS Package Internal Parameters and Query Updates
  • OLEDB Command with Conditional Splits, Multi Row Updates
  • Using non-Microsoft Transformations : Precautions

VIDEO 8: XML CONNECTIONS, ODBC & DYNAMIC LOOPS

  • XML Connections & Usage. Reading, Operating XML Data
  • ODBC Connections - Definition, Usage, Importance
  • ODS Connection Files, Reusability Options (Dynamic)
  • Advanced Connection Options - XML, DT_NTEXT Stream
  • XML Queries, Options @ Sub Queries. XML Data Imports
  • DataSource Names (DSN) and SQL Native Client (SNAC)
  • Connection Builds and SPN Options, SSPI Authentication
  • Data Source Connection Strings (Read, RW): Mirror Config
  • System.Data.SQLClient Managed Providers: Usage Options
  • Dynamic Connections and Loops with SSIS Expressions
  • SSIS Expressions with Variables For File Specifications
  • For Each Expressions - Dynamic File Types, Directories
  • Variable Mapping with Indexed Connections. Performance
  • SQL Data Profile Viewer Tool - Usage with XML Files
  • Nullability Checks and Fast Load Options @ Row Size
  • ADO.NET Connections for SQL Profiler Tool, Options
  • Time-Out Options for Quick Profile, Candidate Keys
  • Value and Lenght Distribution, Surrogate Key Detection
  • XML File Imports for SQL Profiler Viewer Tool, Options
  • Column Statistics and Values for DWH Design Planning
  • SSIS Package Execution: Native SSDT 2015, SSDT 2013
  • SSIS Execute Package Utility @ File System / Dev Env

VIDEO 9: SSIS CUSTOMIZATION WITH SCRIPT TASK, .NET

  • Script Task - Purpose and Working in SSIS Control Flow
  • Script Task - Usage with VB.NET Programs. Compilations
  • Script Task - Usage with C#.NET Programs. Compilations
  • Variables and Parameters with SSIS Script Task. Usage
  • Read Only and Read Write Variables. Expressions, Mapping
  • Namespace Options, Customizations : System.IO, DTS
  • Using VB.NET, C#.NET Scripting Programs with Parameters
  • Data Flow Limitations : Solutions with .NET Scripting
  • SSIS Expressions and Package Debugging, Break Points
  • SSIS Packages for Database Migrations - Online/Offline
  • Database Copy and Move Options. Pre, Post Migration Tasks
  • Performing SQL Server and Database Object Operations
  • SQL Server Maintenance Tasks @ SSIS, DB Health Checks
  • Understanding Control Flow - Sequence Containers, Usage
  • Using Control Flow File System Tasks and Limitations
  • Using .Net Scripting for SQL Server Data Reads/Writes
  • SQLDataAdapters & System.Data.SQLClient Connections
  • Adding DTS Packages to SSIS Projects (Data Tools)
  • Package Refresh Options, Package Upgrade Properties
  • SSIS Package/Project Conversions - Process and Options

SSIS Video 10: Change Data Capture (CDC) for ET/DW

  • Understanding CDC Tables with SQL Server
  • Need for CDC Source, CDC Control and CDC State
  • SSIS CDC Source Connections and Net Changes
  • SSIS CDC Controls and Caching, Variables
  • Understanding State Variables and Logging Tables
  • Initial Data Load Packages for Dimension Table
  • Incremental Data Load Packages for Dimension Table
  • Dynamic CDC Connections and Data Load Options
  • OLE DB Commands and Datawarehouse (DWH) Updates
  • Working with Internal Parameters and Options
  • Limitations of ADO.NET Connections and CDC Process
  • Conditional Precedence Constraints for ETL/DW
  • Custom Code Handling with .NET Script in DWH

SSIS Video 11: Master - Child Packages & Deployments

  • Understanding Parent - Child Package Options
  • Configuring Master Packages & Parameters
  • Configuring Child Packages & Parameters
  • Defining Local and Global Variables/Parameters
  • Understanding Parameter Bindings, Execute Process
  • Execute Out Of Process & Parameter Mappings
  • Conditional Data Loads (ETL) and Fact Data Design
  • Fact Loads From OLTP & Dimensions with CDC
  • Choosing Right Method for ETL Operations
  • Data Delta Operations with SSIS Expressions
  • SQL Server and ADO Connections with DataAdapters
  • Derived Columns and Data Conversions Transformations
  • Understanding Validation & Verification Techniques
  • SSIS Package Deployments & Package Executions

SSIS Video 12: SSIS Project Deployment & Security

  • Package Builds, Verification and Backups
  • SSIS Package Store Deployment Options
  • Package Store and Execution/Validation Reports
  • SSIS Package Security Mechanism (SSISDB Catalog)
  • SSIS Logins and ssisadmin Role Membership
  • Understanding Folder and Project Security
  • Execute, Write, Content Management Roles
  • Project Migration Utilities - Limitations
  • Importing ISPAC Files and SSIS Projects
  • Command-Line Deployments and Utilities
  • Scheduling SSIS Packages (Jobs) and Operators
  • Upgrading SSIS 2012 Pakages to SSIS 2014
  • Handling Enumerations and Lists in SSIS
  • Control Loops and Indexed Connections
  • SSIS Data Profiler with ADO Connections
  • Advantages of SSIS ETL/DW Procedures & Conclusions

SSIS Video 13: Fact Loads in Data Warehouse (DWH)

  • Understanding Dimension Loads
  • Creating Scenarios for Fact Loads
  • Generate Time Dimensions for DWH
  • Use of Time Dimensions in Warehouse
  • Working with Text Qualifiers (.dat files)
  • Fact Table Loads - Techniques
  • Designing Master - Child Packages
  • Key Based Dimension LOOKUPs
  • SCD Implementations with Legacy Data
  • Fact Loads - Initial Updates
  • Fact Loads - Incremental Updates
  • Master - Child Packages for ETL/DWH
  • Designing End-to-End Warehouse Packages
  • Advantages of SSIS ETL/DW Procedures

 


SSIS Video 14: MISCELLANOUS TRANSFORMATIONS IN SSIS

    content coming up by Feb 21st, 2017

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Trainers available for doubts clarifications. One Realtime Project for this SSIS Video Training Course.

Why choose SQL School™ Training Institute:

  • Completely Practical and Realtime
  • Video Wise Tasks and Assignments
  • Labwork and Material for each video
  • On Job Support even after the course
  • 24x7 Server LIVE Online Lab
  • Mock Interviews and Certification Guidance

 


  • Microsoft Learning Partner Verify Link
  • ISO Certified Training Instittue

SSIS Video Training Course Highlights:

  • Data Warehouses (DWH) Design & Schemas, Keys
  • Decide to use SCD, CDC, Checksum Techniques
  • ETL & Data Delta - Caching Options
  • Handle Events and Errors with Tuning Options
  • Script .NET and Parameterized Fuzzy Operations
  • BIDS to SSIS Migrations, Configuration Options
  • Deploy and Implement SSIS Package Job Security
  • SSIS Catalog DB Tuning & Package Reporting
  • SSIS 2016 : New Features and Advantages
  • SSIS 2016 : 3rd Party AddsOns and In-Memory

 

 

Click Here for Free Demo Video and Video Training Registration

 

Please find the Guidelines for Video Based Training (VBT) - Online


1. How does Video Training Works

> Videos are accessible 24x7. You can opt to access any number of videos each day or same video for multiple days.
> Video Course to be completed within 3 months from the date of registration.
> A Technical Test / Mock Interview is conducted and a Course completion certificate to be issued upon completion of the course.

 

2. Access the videos

> Each video is for duration of 80 - 90 minutes, can be paused/replayed for writing running notes and understanding.
> Each video can be accessible multiple times before you proceed with the next video. Any time, any day.
> To ensure secured delivery of our services the participant shall connect to our video cloud in a secured environment.

 

3. Study Material, Practice and Doubts/clarifications

> Study Material and Practice examples used in every video to be provided on email.
> Software Installation Assistance and access to our 24x7 LIVE Server to be provided for duration of the course.
> Trainers are available for doubts clarifications. On Skype, Email as well as on Call.

 

Register today for SSIS Video Training

 

 

 

To download SSIS Practical Video Training Course Curriculum : Click here

 

Who can benefit from this SSIS Video Training Course?

This course is helpful for aspiring MSBI Developers, BI Architects, SQL Developers, Database Testers, BI Analysts, DB Architects and .NET Professionals. This course also helps in preparing for Microsoft 70-463 (MSBI Developer) Exam. All training videos are completely practical and realtime. Video wise Material and LIVE Server Access with Lab included in this SSIS Video Course.

Register Today For Free Demo