SQL SERVER INTEGRATION SERVICES TRAINING COURSES PRESTWICH
About Enable Technology Prestwich 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 Professionals. We provide every candidate with SQL Server Integration Services training materials which they keep after the course. 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.
We provide instructor led training coupled with hands on training. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Integration Services onsite. Alternatively we could schedule a SQL Server Integration Services course at an alternative training site in Prestwich. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Integration Services course to some extent is bespoke and tailored to your needs.
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 had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Barclays Bank PLC, Birmingham City University, Carillion PLC, Lloyds TSB Bank PLC, West Bromwich Building Society, Vodafone Group Services, Cadbury PLC and Unipart Group.
Microsoft SQL Server Integration Services SSIS
- 2 day course
- Location: Prestwich
- 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 ... Utilizing Connection Managers SQL Server Integration Services Tasks
- See Training Course Details...
Utilizing Data Preparation Tasks
Utilizing the Import/Export Wizard
Performing Joins with the Merge Transformation
Moving Data with Data Flow
Understanding Variables
Optimizing Sources for Extraction
Choosing the Script Task or Script Component
Performing Joins with the Lookup Transformation
Using Expressions in Packages Containers
The SQL Server Integration Service
Using the Best Practices Debugging SQL Server Integration Services Packages
Designing to Troubleshoot: Using Precedence Constraints
Handling Errors Common SQL Server Integration Services Design Patterns
Examining the SSIS Engine
Understanding Deployment Strategies
Working with XML
Using the Workflow Tasks
Administration of SQL Using the SQL Management Objects Tasks Data Flow
Utilizing Container Loops Performing Joins
Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
Email us about this courses
Other Prestwich Enable Technology Training Courses
Power BI - Prestwich Microsoft Power BI Training Courses
VBA Prestwich Training Courses
Oracle SQL - Prestwich SQL Training Courses