Download Careers360 App

    SSIS Training

    BY
    Mindmajix Technologies

    Brochure Enquire
    Mode

    Online

    Fees

    ₹ 5600 7000

    Quick Facts

    particular details
    Medium of instructions English
    Mode of learning Self study, Virtual Classroom
    Mode of Delivery Video and Text Based
    Frequency of Classes Weekdays, Weekends

    Course and certificate fees

    Fees information
    ₹ 5,600  ₹7,000

    The fees for course SQL Server Integration Services Training is -

    HeadOriginal PriceDiscounted Price
    Self-Paced Videos
    		Rs. 7000Rs. 5600
    Live Instructor-Led
    		Rs. 18689Rs. 14951
    certificate availability

    Yes

    certificate providing authority

    Mindmajix Technologies

    The syllabus

    Module 1 - SSIS INTRO, INSTALLATION

    • Integration Services (SSIS) & ETL / DWH
    • SSIS for Data Loads, ETL, Warehouse
    • SSDT : SQL Server Data Tools
    • SSIS Development, LIVE (Deployment)
    • Data Warehouse Design & ETL Process
    • DWH and ETL Structures Implementation
    • SSIS ETL for Data Reads, Data Cleansing
    • Data Warehouse (DWH) Design Principles
    • SSIS 2019, 2017 : SSIS DB Installations
    • SSIS Database, Catalog Folders, Storage
    • SSIS Catalog Database (SSIS DB) Creation
    • SQL Server Data Tools – SSDT / Visual Studio
    • SSDT Installation and Catalog Verification
    • SSIS, ETL, DWH, Data Flow, Data Buffer
    • SSIS Package Environment, SSDT Projects
    • SSIS & ETL Training – Lab Plan, Resources

    Module 2 - SSIS ETL PACKAGES: BASICS

    • Control Flow Tasks Architecture, Purpose
    • Data Flow Tasks Architecture, Purpose
    • SSIS Packages @ Basic Data Flow, ETL
    • SSIS Projects and Package Creation
    • Data Pipelines in Data Flow Tasks
    • SSIS Packages Execution Process
    • Data Flow Objects, OLE DB Connections
    • SSIS Package Creation – Control Flow
    • DTSX Files for Package Execution
    • SSIS Execution, Package Errors & Logs
    • SSIS Transformation: Conditional Split
    • Excel Connection and Memory Reference
    • Source and Destination Assistants
    • DAT File Imports and Annotations
    • SSIS Project Configurations, Debugging
    • SSIS 64 Bit, 32 Bit Configurations

    Module 3 - MERGE & FUZZY LOOKUP

    • MERGE and UNION ALL Transformations
    • SORT, NOSORT and Advanced Sort
    • Synchronous, Asynchronous Tfns
    • Row, Partial Blocking Transformations
    • Fully Blocking Transformations – Buffers
    • Avoiding Fully Blocking Transformation
    • Bulk Load Operations, SSIS Data Imports
    • IsSorted & SortKey Position Options
    • SSIS Package Performance & Resources
    • Data Conversion Expressions
    • Fuzzy Lookup Transformation, References
    • Nomatch Cleansing @ Conditional Split
    • Index Creations, Lookup Transformation
    • Data Conversion, Derived Columns
    • Varchar, Nvarchar, Error Redirections
    • Threshold Values, Search Delimiters
    • _Similarity, _Confidence Columns

    Module 4 - SSIS CHECKPOINT & PIVOT

    • Execute SQL Task and OLE DB Queries
    • Transaction Options For SSIS Executables
    • Precedence – Success/Failure/Completion
    • SSIS Package Rollbacks Execution Options
    • Checkpoints Purpose with Data Flow Tasks
    • Checkpoint Files and SSIS Logging Tasks
    • Transactions with Checkpoint File in SSIS
    • Checkpoint Option Advantages, Limitations
    • FailPackageOnFailure, Checkpoint Property
    • REQUIRED/SUPPORT/ NOTSUPPORTED
    • Transaction Property, CHECKPOINT Files
    • Legacy Data, Data Cleansing, Formatting
    • Denormalization, Keys. Need for OLTP
    • PIVOT Transformation, Connection Assistant
    • Pivot Usage – Implementation. Key Values
    • Lineage ID – Purpose. Data Mappings
    • Lineage IDs for Column Mapping, Pivot Keys
    • SSIS Input Columns and Mappings
    • Data Viewer : Data Transfer Verification
    • Data Type Conversions, Error Redirection

    Module 5 - EVENTS, LOOPS, EXPRESSIONS

    • SSIS Package Events, Validation, Execution
    • PreExecution, Progress, Cleanup Events
    • SSIS Events, Errors/Warnings/Information
    • Configuring sysssislog System Tables
    • Debugging : Data Viewers and Breakpoints
    • ForEach Loop Container. File Connections
    • Variables For Linking DFT, Control Flow
    • Dynamic Connections with Variables
    • Iterations, Fetch, Index Mapping
    • SSIS Expressions for ETL and DWH
    • FOR LOOP Expressions in SSIS
    • Init/EvalExpression, AssignExpression
    • SSIS Expressions, Functions, Values
    • Data Insertions, Data Serializations
    • Counter Values, Variables & Parameters
    • SSIS for OS Level Operations, Loops
    • Execute SQL Task : Return Values

    Module 6 - SSIS with ETL, Warehouse (DWH)

    • OLTP Database : Historical Data Loads
    • Data Warehouse (DWH) Purpose, Usage
    • Dimensions, Attributes, Members Types
    • Dimension Tables, Fact Tables Design
    • TYPE1 and TYPE2 ETL Implementation
    • SCD Type1, Type 2 for DWH in Sales
    • Inferred Members and Legacy Loads
    • Initial Data Loads with Data Marts
    • Business Keys & non Identity Columns
    • Surrogate Keys, Alternate Business Keys
    • Cascading OLTP / Stage to DWH Rows
    • Fixed Attributes, Changing Attributes
    • Historical Attributes. Inferred Updates
    • ETL Date, Row Status Transformations
    • Attribute Key Types in SCD, Limitations
    • Historical Attributes and Data Delta
    • SSIS Connection Assistants – Reuse
    • SCD Transformations in Real-time

    Module 7 - Checksum & DWH Design

    • Checksum Transformation in ETL Loads
    • Configuring Checksum: SSIS 2019, 2017
    • Transformation Logic, Parity Checks CRC
    • Checksum For Type I, Type II ETL DWH
    • DWH Dimension Tables With Checksum
    • Lookup Transformation, Row Redirection
    • OLE DB Command and Input Parameters
    • Parameter Mapping, Dynamic Updates
    • Cache Transformation CAW Memory Files
    • Memory Connection Lookup with Cache
    • Tuning Lookup: Caching, Index Options
    • Pre-ETL Activities, DB Recovery Models
    • FULL/ PARTIAL CACHE & NOCACHE
    • Performance Tuning and Pre-ETL Loads
    • Dependent Data Flow Tasks, Post ETL
    • Internal Parameters and Query Updates
    • Cache Allocation Options with ETL DWH

    Module 8 - CDC Transformations for DWH

    • DML Audits with Change Data Capture
    • CDC Tables with SQL Server Connections
    • CDC Connections & ADO.NET Integration
    • CDC Control Flow and CDC State Values
    • INITIAL LOADS & PRCESSING RANGE
    • State Variables, Net Changes, Logging
    • Initial & Incremental Dimension Loads
    • Dynamic CDC Control, OLEDB Command
    • Internal Parameters and Usage Options
    • Parameter Mapping For ETL Type1, Type2
    • Integrating Control Flow for CDC @ ETL
    • CDC Splitter – Row Inserts, Updates
    • CDC Precautions, Input & Output Range
    • Derived Column Transformations with CDC
    • Limitations of ADO.NET Connections
    • Master Child Packages,Parameter Binding
    • Package Passwords, Project Parameters
    • Project Configuration Options(32,64 bit)

    Module 9 - Fact Table Design, DWH Loads

    • Fact Table – Design and ER Model
    • DWH : STAR & SNOWFLAKE Schemas
    • Time Dimensions and ETL Date / Time
    • Link Time Dimension to Facts, Lookups
    • Parent-Child Packages for Fact Loads
    • Inferred Members for NULL Dimensions
    • SCD Wizard for DWH Fact Table Design
    • Parameter Mapping for Incr Updates
    • ETL Load IDs – Dimension Attributes
    • Error Handling, Event Handling in SSIS
    • Text Qualifiers with Flat File Sources
    • Fact Load Design for Initial, Incr Loads
    • End-to-End DWH Design Implementation
    • Direct Data Loads and Staging Tables
    • Fact Table Staging and Incr Updates

    Module 10 - DWH MIGRATIONS, SCRIPT Task

    • DataWarehouse Migrations with SSIS
    • Using SSIS Containers, Db Integrity Task
    • Pre-Database Migration Task Precautions
    • Online and Offline DB Transfer Options
    • Copy / Move with DWH Migrations
    • SMTP : Simple Mail Transfer Protocol
    • SQL Server Agent and Package Events
    • Data Profiling with ADO.NET Connectors
    • XML Files & SSIS Data Profiler Tool
    • Script Task – Working in SSIS Control Flow
    • Script Task – VB.NET Program Compilations
    • Variables, Parameters with SSIS Script Task
    • Read Only, Read Write Variable Expressions
    • Expressions and Debugging, Break Points
    • Variables, Parameters Mapping Expressions
    • File System Tasks and Limitations
    • SQLDataAdapters & System.Data.SQLClient

    Module 11 - SSIS DEPLOYMENTS, UPGRADES

    • SSISDB Catalog Deployments, ISPAC Files
    • Package Builds, Verification, Scripts
    • Project Deployment Wizard Targets, Logs
    • DB Catalog Folders & Projects Creation
    • Package Executions – Scripts, Reports
    • Package Validations, 32/64 bit Options
    • Configurations & Parameter Management
    • Package Jobs @ SQL Agent. Job Steps
    • Job Schedules and Notifications Event Logs
    • Package Security – SSISDB Logins, Users
    • Folder Level and Project Level Security
    • Project Migration Utilities, Upgrades
    • Package Imports, Exports with ISPAC Files
    • Command-Line Deployment,Execution Utility
    • Package Execution & Validation Reports
    • Package Versions and Restores, Rollbacks

    Module 12 - Practice Test & Interview Questions

    Instructors

    Mr Venkat
    Instructor
    Mindmajix Technologies

    Trending Courses

    Digital Marketing Courses Fashion Design Courses Data Science Courses Interior Design Courses Graphic Designing Courses Cyber Security Courses Nursing Courses Tally Courses Data Analysis Courses Web Designing Courses Artificial Intelligence Courses Ethical Hacking Courses Free Digital Marketing Courses And certifications Free Artificial Intelligence Courses And Certifications Free Data Analysis Courses And Certifications Free Cyber Security Courses And Certifications Free Data Science Courses And Certifications Free Cloud Computing Courses And Certifications Free Python Courses And Certifications Free Fashion And Textiles Courses And Certifications Free Graphic Designing Courses And Certifications Free Web Designing Courses And Certifications

    Popular Courses

    General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Programming Courses Data Science Courses Cyber Security Courses Digital Marketing Courses Law Courses Mechanical Engineering Courses Explore all courses

    Popular Platforms

    upGrad Courses Udemy Courses Swayam Courses Edx Courses Coursera Courses NPTEL Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses IIT Kharagpur Courses IIT Kanpur Courses Emeritus Courses Explore all platforms

    Learn more about the Courses

    10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management
    Providers
    Close
    Download Careers360 App
    All this at the convenience of your phone

    • Regular Exam Updates

    • Best College Recommendations

    • College & Rank predictors

    • Detailed Books and Sample Papers

    • Question and Answers

    google play
    students
    400M+ Students
    Colleges
    36K+ Colleges
    Exams
    500+ Exams
    eBooks
    3K+ eBooks
    Certification
    16K+ Certifications
    mobile