SSIS provides SQL Server Coding enhancements, Administration Options and Customizations for SQL Server Developers, Administrators, BI Engineers and Data Analysts.In our LIVE Online Training, we deal with complete SSIS features including SCD, Profiling, Tuning and Customizations. Each sessions will be completely practical. Daily tasks and a Case Study will also be provided.
My training benefits
- My batch sizes are generally very small size 5-7 members OR 1 to 1 also, so students receive direct, hands-on training from us.
- 100% practical training only. It is not a slide show training program / theory class program. At the end of this class, definitely you will refer your colleagues / friends / relatives for my training.
- Conducting regularly online- training for US peoples in all time zones (PST,CST,EST,HST,MST)
- Installation of Softwares in your desktop / laptop will be done.
- Will be provided self evaluation testing software, exam simulator, dumps & books with this training.
- Continuous support is provided for any of your on-site problems. Placement assistance will be provided and you will be recommended to some of IT development firms.
For Corporate Training
- I will be more comfortable, if you could restrict the group not to exceed 20 persons.
- Training hours will be 40 Hrs/paper in view of 20 participants.
- Hardware for the required training should be provided by you, like Hall, Projector, and Furniture.
- I will be bringing my laptop for training purpose, which should be allowed in to your premises.
My training benefits
- My batch sizes are generally very small size 5-7 members OR 1 to 1 also, so students receive direct, hands-on training from us.
- 100% practical training only. It is not a slide show training program / theory class program. At the end of this class, definitely you will refer your colleagues / friends / relatives for my training.
- Conducting regularly online- training for US peoples in all time zones (PST,CST,EST,HST,MST)
- Installation of Softwares in your desktop / laptop will be done.
- Will be provided self evaluation testing software, exam simulator, dumps & books with this training.
- Continuous support is provided for any of your on-site problems. Placement assistance will be provided and you will be recommended to some of IT development firms.
For Corporate Training
- I will be more comfortable, if you could restrict the group not to exceed 20 persons.
- Training hours will be 40 Hrs/paper in view of 20 participants.
- Hardware for the required training should be provided by you, like Hall, Projector, and Furniture.
- I will be bringing my laptop for training purpose, which should be allowed in to your premises.
About Our Trainer
- As a Trainer, Yuvraj has over 8+ Years Working experience on SQL Server 2005, 2008 R2 and SQL Server 2012 Database Management and Business Intelligence competencies specifically into Marketing, Sales and Infrastructure domains. Holds MCP, MCDBA, MCITP and MCSA Certifications from Microsoft.
Currently working for a Leading MNC in Chennai as BI Consultant and Datawarehouse Archtect. Also involved in Database Consulting services on SQL Server 2014 with Azure for an Infrastructure Client based at Chennai, India.
Being proficient on SQL Server and related technologies in Health, Medicare and Sales-Retail Sector, I love sharing knowledge via Instructor Led LIVE Online / Classroom Trainings and offering training videos. Personally I enjoy answering doubts from the attendees and get involved in brain-storming sessions.
All Trainings are completely practical and real-time, paired with 24 X 7 LIVE Server Access and Real-time databases.
Courses Offered:
- SQL Server Training
- SQL DBA Training
- MSBI Training
- SQL BI and DWH [SSIS/SSRS/SSAS] Training
- DAX and Power View
- DQS and MDS with Powershell
Want a free career Advice or any career related queries? Reach him by
+91- 8939915572
Course Curriculum
Curriculum
Please find the Course Contents for SSIS Module:
Basic SSIS Development
Advanced SSIS Development
SSIS Management and Security
Introduction to SSIS
- Need for SSIS
- SSIS Development Environment
- SSIS Tools and DTS Comparisions
SSIS Architecture
- Control Flow Tasks Architecture
- Data Flow Tasks Architecture
- Data Pipelines and Usage
- Conditional Precedence
Basic SSIS Entities
- SSIS Data Types and Conversions
- SSIS Local & Global Variables
- Dynamic Precedence Constraints
- Dynamic Connection Managers
- Data Flow Transformations usage
- Handling Enumerations in SSIS
SSIS Customizations
- SCRIPT Task (.NET) in SSIS
- Expressions and Iterations
SSIS Expressions & Debugging
- Expression Builder Usage
- SSIS Parameters Usage and Variable
- Control Flow Breakpoints
- Data Flow Data Viewers and Audits
- Limitations of SSIS Debugging
Data Flow Transformations
- Column Transformations
- Combining and splitting data
- Performing database operations
- MERGE Vs UNION ALL Transformations
- Lookup and Fuzzy Grouping
- SORT Vs AGGREGATE Transformations
- OLE-DB Command Tranformation
Custom Activities
- Data Analytics and Debugging
- Custom Code Handling
- Event Notifications and Emails
- Data Sampling Techniques
- Type I and Type II SCDs
- Performing PIVOT operations
- TDS Sizing and Tuning Options
Package Controls
- SSIS Transactions & Isolation Levels
- SSIS Checkpoints and Usage
- CACHE Transformation & Performance
- CHECKSUM Transformation
Package Configurations
- Configurations and benefits
- Applying Configuration Options
- Global Configurations in DENALI
- Choosing correct providers
Error Handling
- System Events and Audits
- Package Event Handling
- Limitations of Event Handling
- Event Bubbling Escalations
SSIS Logging Actions
- Benefit of SSIS Logging
- Environment Variables Usage
- Windows Event Logs and SSIS
- SQL Server Logging Limitations
- Choosing correct log providers
- Package Execution Audits
Processing XML Data
- Iterating XML nodes and Data
- Data Profiler & ADO Connections
Deployment Procedures
- Preparing for Deployment
- SSIS Deployment Phases
- Securing Manifest Files
- Deployment Options & ISPAC
- Validation & Verification Techniques
File System Deployment
- File System Deployment
- Package Execution Options
- File System Security
SQL Server Deployment
- SQL Server Deployment
- SSIS Catalog Files and Security
- SQL Server Security
- File System Versus MSDB
Deployment Management
- Package Migration Utilities
- Command-Line Deployments
- Package Backup Procedures
- Fine-tuning Deployment
Managing Security
- SSIS Package Security Options
- Encrypting SSIS packages
- Package Store and msdb
- Security Audits and Proxies
- MSDB and File System Comparisions
- Event Logging Activities
Upgrading Packages
- DTS packages to SSIS migration
- Upgrading 2005 Packages to 2008
- MSDB and SSIS Catalog Files
- Comparing SSIS 2008 R2 & 2012
- ISPAC (DENALI) & Package Migrations
Course Reviews
Related Courses
QUICK ENQUIRY
TOP COURSES
Our Reviews
Reviews 
5 out of 5 based on 52567 ratings.
Google
Facebook
UrbanPro
Sulekha
Yet5
Justdial
