SQL SERVER INTEGRATION SERVICES TRAINING COURSES LANCASHIRE
About Enable Technology Lancashire SQL Server Integration Services Training Courses
We offer intensive two and three days SQL Server Integration Services courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each course participant will be issued with training SQL Server Integration Services resources which they can continue to use after the training. Our policy is to provide open ended SQL Server Integration Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Enable Technology SQL Server Integration Services courses are instructor led and taught by an experienced Microsoft expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Integration Services onsite. Another way we could deliver the SQL Server Integration Services course is at a local training site. We are happy to modify the SQL Server Integration Services syllabus to match your teams training requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Birmingham City University, Royal Air Force, DHL Express, Aston University, GKN PLC, Fujistu PLC, Dollond & Aitchison Limited and Total Telecommunications Limited.
Microsoft SQL Server Integration Services SSIS
- 2 day course
- Location: Lancashire
- 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 ... Understanding Deployment Strategies
- See Training Course Details...
Managing with Control Flow
Utilizing Sequences in a Container
Performing Joins with the Merge Transformation
Creating SQL Server Integration Services Packages
Optimizing Sources for Extraction
Utilizing the Import/Export Wizard
Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
Handling Errors Common SQL Server Integration Services Design Patterns
Using Expressions in Packages Containers
Coding the Script Task
Define and Use Variables and Parameters
Designing to Troubleshoot: Using Precedence Constraints
Examining the Transformation and Other Tasks Variables, Parameters and Expressions
Performing Joins with the Lookup Transformation
Overview of Containers
Understanding Packages
Choosing the Script Task or Script Component
Utilizing Container Loops Performing Joins
Managing SQL with the SQL Tasks
Working with XML
Email us about this courses
Other Lancashire Enable Technology Training Courses
Oracle SQL Lancashire Training Courses
PL/SQL - Lancashire SQL Training Courses
SSAS Tabular Lancashire Training Courses