SSIS Introduction
£895.00 Plus VAT
Delivery Method
Face To Face Delivery Virtual Delivery One To One Coaching Closed Group Course Public Course
Business Benefit
As Data size grows and more terabyte sized data warehouses are becoming common place within organisations, data controllers need more efficient data handling techniques rather than the traditional T-SQL and stored procedures. SSIS fits this position and offers data controllers a range of tools to help them manage the flow of data.
Who Should Attend
The course is designed for anyone new to using SSIS and what to learn from the beginning best practice and understand the available tools.
Learning Outcomes
Understand the key concept of SSIS
Work with the main tools within the SSIS Architecture
Appreciate Data Flows
Understand ETL packages
Course Content
SSIS Introduction & Historical Overview
SSIS Architecture
Packages
Control Flow
Data Flow
Variables
Parameters
Error Handling & Logging
The SSIS Package Designer
SSIS Tasks
SSIS Task Objects
Looping & Sequence Tasks
Data Mining Query Tasks
Data Preparation Tasks
RDBMS Server Tasks
Workflow Tasks
SMO Administration Tasks
Understanding the Data Flow
Common Transformations
Typical Mainframe ETL with Data Scrubbing
Joining Data
Accessing Heterogeneous Data
How to Book
If you are interested in booking this course, then please select an available date and then click book now to complete the booking. Can’t see a suitable date contact us on [email protected] and we can discuss specific date requirements.
Embedding
These follow up coaching sessions help support your colleagues to embed their learning during their skills transfer period. Applying new skills and changing behaviour takes effort and practice. After attending a training course many colleagues will find they need support through this transition. EQV can provide that support with follow up coaching sessions to help embed the learning.
Embedding coaching sessions can be delivered in 90 minute and half day durations. The facilitator will work with the group to capture feedback about challenges and how to overcome them ensuring success going forward.
Having a formal embedding coaching session will not only increase the success of the skills transfer period but helps create a platform of motivation, inclusivity and commitment within the group.