Enable Technology

SQL SERVER INTEGRATION SERVICES NEWCASTLE UPON TYNE TRAINING COURSES 

SQL SERVER INTEGRATION SERVICES TRAINING COURSES NEWCASTLE UPON TYNE




About Enable Technology Newcastle Upon Tyne SQL Server Integration Services Training Courses

We are a company that offers short, practical, SQL Server Integration Services hands on technology courses. All Enable Technology tutors are Microsoft certified experts. We provide every candidate with SQL Server Integration Services training materials which they keep after the course. 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.

Courses are instructor led and groups sizes small. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Integration Services onsite. We can also deliver the SQL Server Integration Services course at a socially distanced local training venue in Newcastle Upon Tyne. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Integration Services training needs.

SQL Server Integration Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Nationwide Building Society Limited, Lloyds TSB Bank PLC, Birmingham City University, TalkTalk Direct Limited, Shell UK Oil Products Ltd, Unipart Group, West Bromwich Building Society and Nuclear Engineering Services.




Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Newcastle Upon Tyne
  • 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 ...
  • Overview of Containers
    Working in the Explore Window
    Define and Use Variables and Parameters
    Creating SQL Server Integration Services Packages
    Managing SQL with the SQL Tasks
    Performing Joins with the Lookup Transformation
    Examining the SSIS Engine
    SQL Server Integration Services Architecture
    Data Loading with the Analysis Services Tasks
    Optimizing Sources for Extraction
    Using the Workflow Tasks
    The SQL Server Integration Service
    Choosing the Script Task or Script Component
    Utilizing the Import/Export Wizard
    Utilizing SQL Server Integration Services Data Typing
    Handling Errors Common SQL Server Integration Services Design Patterns
    Utilizing Container Loops Performing Joins
    Coding the Script Task
    Understanding Deployment Strategies 
    Using Package Hierarchies: Parent Child
    Designing to Troubleshoot: Using Precedence Constraints

  • See Training Course Details...



Email us about this courses



Other Newcastle Upon Tyne Enable Technology Training Courses

Access VBA - Newcastle Upon Tyne Access Training Courses
DAX - Newcastle Upon Tyne Excel Training Courses
Excel 365 Advanced Newcastle Upon Tyne Training Courses