SSIS Training
Learn SSIS Training to Unleash a Modern Career
Average Rating 4.3 From 959 Students
About Course
SSIS Training at SM consultant will let you gain proficiency in all concepts of SQL Server Integration Services. This SSIS training equips you with the skills needed to work with SQL Server Integration Services for business intelligence. It involves working on data extraction, integration and transformation to align with business needs. This SSIS online training will make you proficient in gathering data from flat files, XML, and relational data sources. It will be the golden ticket to your success in this industry. You will learn the basics about the development tools and what they are capable of, clear instruction on how to handle various issues that you might face when designing your packages and how to overcome them. By the end of this course you will understand many basic concepts and how to perform data integration and transformation. This course also includes the process of cleansing data and how to get the end result after applying different transformations. It also gives some real world scenarios that you might face and what salary to expect from working as an SSIS/ETL developer.
Reasons to choose SM Consultant
MockInterviews
FocusedLearning
PracticalTraining
EasyPayments
LifetimeAccess
ExpertTrainers
ShareableCertificate
FlexibleTimings
Upcoming Batch Schedule for SSIS Training
No Timing Suitable for You ?
Tell Us Your Preferred Starting Date, we will schedule a batch for You!
Take SSIS Training at your own pace
Self Paced Online Learning
The Self Paced format allows you to stream the course content from anywhere across the globe with a good Internet connection. There is no defined schedule, you can watch them at your comfortable time. Get Started.
Watch Free SSIS Training videos before signing up.
Instructor Led Live Training
We deliver Instructor-led online course via your personal computer through an easy-to-use web conferencing tool that allows for real-time interaction between you and the trainer. Get Expert guidance tailored for you.
Join Free SSIS Training demo session before signing up.
SSIS Training Course Content
1. Introduction to SSIS & Data Warehouse
- 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
2. SSIS Expressions & Package Debugging
- 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
3. Basic ETL Entities in SSIS
- 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
4. Data Flow Transformations and ETL
- 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
5. SCD Transformation - ETL / DW
- 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
6. SSIS Customizations with .NET
- 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
7. Change Data Capture (CDC) for ETL/DW
- CDC Sources and Controls in SSIS
- CDC Tables and Change Tracking
- Dynamic CDC Connections & Logging
- Using CDC for Dimension Loads (ETL)
8. Checksum Operations for ETL/DW
- 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
9. Deployment Procedures
- 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
10. Events, Errors and Logging
- 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
11. SSIS Project Deployments
- 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
12. SSIS Package Security and 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
Need Customized Course Content?
We will customize the SSIS Training course content according to your job requirements.
Certification
Once you are successfully through the project, you will be awarded an SM Consultant’s SSIS Training Completion Certificate for the course.
SM Consultant’s certification has industry recognition, and we are the preferred training partner for many organizations.
SM Consultant’s Certificate Holders work at 100s of companies
Frequently Asked Questions About SSIS Training
1. When will I receive my joining instructions for SSIS Training?
Joining instructions for SSIS Training is sent two days prior to the course start date, or immediately if the booking is confirmed within this timeframe.
2. How are you better than the other classes? Past achievements?
As they say, “History speaks for itself”, the past achievements would give you a good picture of our reputation, and would also tell you what extra efforts we put in to achieve it.
3. Do you offer a SSIS Training Demo or Trial class before joining?
We offer 1 demo classes to students. Just make sure that you select the subject and time of the class so that you get an independent assessment of the quality of teaching and you can take an informed decision.
4. What’s the batch size? Will I get personal attention?
An average batch size could be min. 4-5 and max. 8-10 but irrespective of the batch size you will get personal attention and our trainers will help you understand the technology.
5. What if I am not able to attend or miss a session?
If you are unable to attend your session we will help you understand the session by sharing the recording of the live session and still if you need more assistance, we will arrange a backup session for you.
6. Can I access the SSIS Training course material after training?
Yes, you will get the material in pdf format and will have access to the SSIS Training recordings.
Have More Questions?
Do let us know if you need more information we will be happy to help you!
Trusted By Companies of All Size
