SQL SERVER INTEGRATION SERVICES TRAINING COURSES STAFFORDSHIRE
About Enable Technology Staffordshire SQL Server Integration Services Training Courses
We offer intensive two and three days SQL Server Integration Services courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All candidates receive comprehensive SQL Server Integration Services training materials and practice files which are theirs to refer to after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Enable Technology offers instructor led training taught by technology specialists. We can deliver at your premises. We can provide the equipment. If delivery onsite is an issue we will organise a venue near you in Staffordshire. We are happy to discuss customising the course content should you have particular SQL Server Integration Services training requirements.
We can also deliver SQL Server Integration Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Norwich Union PLC, Queen's Medical Centre Nottingham, Carillion PLC, Total Telecommunications Limited, Royal Air Force, Unipart Group, Yell Group PLC and Birmingham City Council.
Microsoft SQL Server Integration Services SSIS
- 2 day course
- Location: Staffordshire
- Telephone on 01952 938014
- Course Outline
-
This two day intensive course introduces SQL Server Integration Services. No prior knowledge of Integration Services is assumed.
- Some of the training topics covered include ... Working with XML
- See Training Course Details...
Moving Data with Data Flow
Choosing the Script Task or Script Component
Managing SQL with the SQL Tasks
Examining the Transformation and Other Tasks Variables, Parameters and Expressions
Designing to Troubleshoot: Using Precedence Constraints
Working in the Explore Window
Utilizing Data Preparation Tasks
Optimizing Sources for Extraction
The SQL Server Integration Service
Utilizing Connection Managers SQL Server Integration Services Tasks
Performing Joins with the Merge Transformation
Performing Joins with the Lookup Transformation
Creating SQL Server Integration Services Packages
Utilizing Sequences in a Container
Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
Managing with Control Flow
Define and Use Variables and Parameters
Understanding Deployment Strategies
Data Loading with the Analysis Services Tasks
Using Expressions in Packages Containers
Email us about this courses
Other Staffordshire Enable Technology Training Courses
Oracle SQL Staffordshire Training Courses
Excel Power Pivot - Staffordshire Excel Training Courses
DAX Staffordshire Training Courses