Enable Technology

SQL SERVER INTEGRATION SERVICES OXFORD TRAINING COURSES 

SQL SERVER INTEGRATION SERVICES TRAINING COURSES OXFORD




About Enable Technology Oxford SQL Server Integration Services Training Courses

Enable Technology specialise in succinct skills based SQL Server Integration Services training. The course will always be taught by a Microsoft Certified Professional (MCP). Every person attending a SQL Server Integration Services course will be provided with training materials and practice files to retain after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Integration Services queries.

Delegates are taught by an experienced Microsoft professional. SQL Server Integration Services courses are delivered through a mix of practical hands on exercises and walk throughs. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Integration Services onsite. If you prefer we can offer an offsite training location in Oxford. We offer the option of working with you to develop a bespoke SQL Server Integration Services programme which precisely matches your organisations training requirements.

This instructor led SQL Server Integration Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.

Our teaching team have over twenty years continuous technical training experience. Our clients include: Countrywide Homes Limited, Royal & Sun Alliance Group PLC, EDF Energy PLC, Cadbury PLC, TalkTalk Direct Limited, National Power PLC, Wolverhampton City Council and Shell UK Oil Products Ltd.




Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Oxford
  • 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 Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Utilizing the Import/Export Wizard
    Using Package Hierarchies: Parent Child
    Examining the SSIS Engine
    Utilizing Container Loops Performing Joins
    Performing Joins with the Merge Transformation
    Creating Dynamic Packages
    Utilizing Connection Managers SQL Server Integration Services Tasks
    SQL Server Integration Services Architecture
    Using Destinations and Understanding choices
    Using the Workflow Tasks
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Overview of Containers
    Choosing the Script Task or Script Component
    Using Expressions in Packages Containers
    Working in the Explore Window
    Managing SQL with the SQL Tasks
    Utilizing SQL Server Integration Services Data Typing
    Working with XML
    Optimizing Sources for Extraction
    Data Loading with the Analysis Services Tasks

  • See Training Course Details...



Email us about this courses



Other Oxford Enable Technology Training Courses

Excel 365 Intermediate - Oxford Excel Training Courses
Oracle SQL - Oxford SQL Training Courses
Excel Power Pivot Oxford Training Courses