Enable Technology

SQL SERVER INTEGRATION SERVICES PRESTON TRAINING COURSES 

SQL SERVER INTEGRATION SERVICES TRAINING COURSES PRESTON




About Enable Technology Preston 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 will receives course practice files and SQL Server Integration Services course resources that can be referenced post training. If delegates have have questions about SQL Server Integration Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.

Enable Technology SQL Server Integration Services courses are instructor led and taught by an experienced Microsoft expert. We can set up a training lab at your premises and deliver SQL Server Integration Services courses onsite at your site. We can also deliver the SQL Server Integration Services course at a local training venue in Preston. 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.

In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Norfolk Police Constabulary, EDF Energy PLC, Halfords Group PLC, TalkTalk Direct Limited, Queen's Medical Centre Nottingham, National Power PLC, West Bromwich Building Society and DHL Express.




Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Preston
  • 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 Variables
    Data Loading with the Analysis Services Tasks
    Managing SQL with the SQL Tasks
    Utilizing Data Preparation Tasks
    Managing with Control Flow
    Working with XML
    SQL Server Integration Services Architecture
    Optimizing Sources for Extraction
    Working with Advanced Logging and Reporting
    Utilizing the Import/Export Wizard
    Performing Joins with the Merge Transformation
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Understanding Packages
    Choosing the Script Task or Script Component
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Using Expressions in Packages Containers
    Using Destinations and Understanding choices
    Creating SQL Server Integration Services Packages
    Utilizing Container Loops Performing Joins
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Working in the Explore Window

  • See Training Course Details...



Email us about this courses



Other Preston Enable Technology Training Courses

Excel Power Pivot - Preston Excel Training Courses
SQL Preston Training Courses
Data Warehouse - Preston SQL Training Courses