Enable Technology

SQL SERVER INTEGRATION SERVICES SCUNTHORPE TRAINING COURSES 

SQL SERVER INTEGRATION SERVICES TRAINING COURSES SCUNTHORPE




About Enable Technology Scunthorpe SQL Server Integration Services Training Courses

We offer intensive two and three days SQL Server Integration Services courses. The course will always be taught by a Microsoft Certified Professional (MCP). All course participants are issued SQL Server Integration Services training manuals they can refer to after the course. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Integration Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.

SQL Server Integration Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can supply all of the equipment necessary to deliver SQL Server Integration Services courses onsite at your offices. You simply need to provide a suitable room. Another way we could deliver the SQL Server Integration Services course is at a local training site. 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.

SQL Server Integration Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Barclays Bank PLC, Capita Group PLC, West Bromwich Building Society, Countrywide Homes Limited, Queen's Medical Centre Nottingham, South Staffordshire Water PLC, Fujistu PLC and Cadbury PLC.




Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Scunthorpe
  • 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 ...
  • Performing Joins with the Merge Transformation
    Creating Dynamic Packages
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Managing SQL with the SQL Tasks
    Utilizing the Import/Export Wizard
    Understanding Variables
    Performing Joins with the Lookup Transformation
    Understanding Deployment Strategies 
    Working with Advanced Logging and Reporting
    Using the Workflow Tasks
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Coding the Script Task
    Utilizing Data Preparation Tasks
    Choosing the Script Task or Script Component
    Working in the Explore Window
    Using Package Hierarchies: Parent Child
    Using Expressions in Packages Containers
    Optimizing Sources for Extraction
    Data Loading with the Analysis Services Tasks
    Using Destinations and Understanding choices
    Handling Errors Common SQL Server Integration Services Design Patterns

  • See Training Course Details...



Email us about this courses



Other Scunthorpe Enable Technology Training Courses

Excel Power Pivot - Scunthorpe Excel Training Courses
JavaScript Scunthorpe Training Courses
Access - Scunthorpe Access Training Courses