Enable Technology

SQL SERVER INTEGRATION SERVICES ROTHERHAM TRAINING COURSES 

SQL SERVER INTEGRATION SERVICES TRAINING COURSES ROTHERHAM




About Enable Technology Rotherham SQL Server Integration Services Training Courses

Enable Technology offer short intensive skills based SQL Server Integration Services training courses. The training will be delivered by a Microsoft professional with development experience. Every course participant is given SQL Server Integration Services courseware which they can refer to after the training. Enable Technology offer post course help to all delegates. Participants on the SQL Server Integration Services course can contact the tutor for as long as they like if they encounter SQL Server Integration Services problems.

We provide instructor led training coupled with hands on training. Enable Technology can provide SQL Server Integration Services courses onsite at your location. We will bring the necessary laptops with the required software installed. The SQL Server Integration Services course could also be scheduled at a socially distanced site near you in Rotherham. Every SQL Server Integration Services course can be modified to meet your bespoke 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.

Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: National Power PLC, Barclays Bank PLC, TalkTalk Direct Limited, Carillion PLC, Capita Group PLC, Boots UK Limited, Queen's Medical Centre Nottingham and Fujistu PLC.




Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Rotherham
  • 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 ...
  • Moving Data with Data Flow
    Examining the SSIS Engine
    Working with XML
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Coding the Script Task
    Performing Joins with the Merge Transformation
    Choosing the Script Task or Script Component
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Overview of Containers
    Using Package Hierarchies: Parent Child
    Working with Advanced Logging and Reporting
    Working in the Explore Window
    Optimizing Sources for Extraction
    Understanding Packages
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Understanding Deployment Strategies 
    Using Destinations and Understanding choices
    Performing Joins with the Lookup Transformation
    Designing to Troubleshoot: Using Precedence Constraints
    Managing SQL with the SQL Tasks
    The SQL Server Integration Service

  • See Training Course Details...



Email us about this courses



Other Rotherham Enable Technology Training Courses

Excel 365 Intermediate Rotherham Training Courses
Excel Power Pivot - Rotherham Excel Training Courses
TSQL - Rotherham SQL Training Courses