SQL SERVER INTEGRATION SERVICES TRAINING COURSES GWYNEDD
About Enable Technology Gwynedd SQL Server Integration Services Training Courses
Enable Technology offer short intensive skills based SQL Server Integration Services training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Everyone attending a SQL Server Integration Services course receives learning resources which also serves as a reference source after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Integration Services queries. This support is open ended.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can bring the equipment necessary to deliver SQL Server Integration Services courses at your site. Alternatively we could schedule a SQL Server Integration Services course at an alternative training site in Gwynedd. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Integration Services training needs.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Integration Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: TalkTalk Direct Limited, Norwich Union PLC, Yell Group PLC, Nationwide Building Society Limited, West Bromwich Building Society, Nuclear Engineering Services, Loughborough University and Canadian High Commission.
Microsoft SQL Server Integration Services SSIS
- 2 day course
- Location: Gwynedd
- 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 ... Define and Use Variables and Parameters
- See Training Course Details...
Understanding Variables
Creating SQL Server Integration Services Packages
Utilizing Data Preparation Tasks
Performing Joins with the Merge Transformation
Working with XML
Using Package Hierarchies: Parent Child
Creating Dynamic Packages
Utilizing Container Loops Performing Joins
Managing SQL with the SQL Tasks
Working in the Explore Window
SQL Server Integration Services Architecture
Data Loading with the Analysis Services Tasks
Choosing the Script Task or Script Component
Examining the Transformation and Other Tasks Variables, Parameters and Expressions
Administration of SQL Using the SQL Management Objects Tasks Data Flow
Examining the SSIS Engine
Coding the Script Task
Utilizing Sequences in a Container
Looping and Sequence Tasks
The SQL Server Integration Service
Email us about this courses
Other Gwynedd Enable Technology Training Courses
Data Warehouse Gwynedd Training Courses
Power BI - Gwynedd Microsoft Power BI Training Courses
Excel 365 Basic - Gwynedd Excel Training Courses