Enable Technology

SQL SERVER INTEGRATION SERVICES SOUTHPORT TRAINING COURSES 

SQL SERVER INTEGRATION SERVICES TRAINING COURSES SOUTHPORT




About Enable Technology Southport SQL Server Integration Services Training Courses

Enable Technology SQL Server Integration Services courses are short, skill focused and hands on. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each person attending a course takes away SQL Server Integration Services courseware which can be used as reference materials after the training. Course participants are welcome contact the Tutor after the course with specific SQL Server Integration Services queries. This support is open ended.

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. Alternatively we could schedule a course at a local venue in Southport. We are happy to modify the SQL Server Integration Services syllabus to match your teams training requirements.

Taught SQL Server Integration Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Vodafone Group Services, Fujistu PLC, Barclays Bank PLC, Queen's Medical Centre Nottingham, Birmingham Heartlands Hospital, Shell UK Oil Products Ltd, Canadian High Commission and Yell Group PLC.




Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Southport
  • 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 ...
  • Handling Errors Common SQL Server Integration Services Design Patterns
    Understanding Parameters SQL Server Integration Services Tools
    Utilizing Data Preparation Tasks
    Creating Dynamic Packages
    Utilizing Container Loops Performing Joins
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Using Expressions in Packages Containers
    Performing Joins with the Merge Transformation
    Understanding Deployment Strategies 
    Utilizing SQL Server Integration Services Data Typing
    Data Loading with the Analysis Services Tasks
    Choosing the Script Task or Script Component
    Designing to Troubleshoot: Using Precedence Constraints
    Working with Advanced Logging and Reporting
    Working with XML
    Understanding Variables
    Define and Use Variables and Parameters
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Utilizing Sequences in a Container
    Creating SQL Server Integration Services Packages
    Coding the Script Task

  • See Training Course Details...



Email us about this courses



Other Southport Enable Technology Training Courses

JQuery Mobile Southport Training Courses
SQL - Southport SQL Training Courses
Excel 365 Intermediate - Southport Excel Training Courses