Enable Technology

SQL SERVER INTEGRATION SERVICES GWENT TRAINING COURSES 

SQL SERVER INTEGRATION SERVICES TRAINING COURSES GWENT




About Enable Technology Gwent SQL Server Integration Services Training Courses

Enable Technology provides practical SQL Server Integration Services skills based technology training. The course will always be taught by a Microsoft Certified Professional (MCP). Every person attending a SQL Server Integration Services course will be provided with training materials and practice files to retain after the course. Our policy is to provide open ended SQL Server Integration Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.

SQL Server Integration Services courses are taught by a Microsoft Certified Solutions Expert. 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. We can also deliver the SQL Server Integration Services course at a socially distanced local training venue in Gwent. We offer the option of working with you to develop a bespoke SQL Server Integration Services programme which precisely matches your organisations training 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.

The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Dollond & Aitchison Limited, GKN PLC, South Staffordshire Water PLC, Queen's Medical Centre Nottingham, Birmingham City Council, Norwich Union PLC, Capita Group PLC and TalkTalk Direct Limited.




Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Gwent
  • 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 ...
  • Looping and Sequence Tasks
    Handling Errors Common SQL Server Integration Services Design Patterns
    Utilizing Data Preparation Tasks
    Optimizing Sources for Extraction
    Designing to Troubleshoot: Using Precedence Constraints
    Data Loading with the Analysis Services Tasks
    Choosing the Script Task or Script Component
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Understanding Deployment Strategies 
    Utilizing Sequences in a Container
    Understanding Parameters SQL Server Integration Services Tools
    Working with XML
    Understanding Packages
    Using the Workflow Tasks
    Understanding Variables
    Define and Use Variables and Parameters
    Examining the SSIS Engine
    The SQL Server Integration Service
    Coding the Script Task
    Overview of Containers

  • See Training Course Details...



Email us about this courses



Other Gwent Enable Technology Training Courses

Data Warehouse - Gwent SQL Training Courses
Report Builder Gwent Training Courses
Excel 365 Advanced - Gwent Excel Training Courses