Enable Technology

SQL SERVER INTEGRATION SERVICES KENILWORTH TRAINING COURSES 

SQL SERVER INTEGRATION SERVICES TRAINING COURSES KENILWORTH




About Enable Technology Kenilworth SQL Server Integration Services Training Courses

Enable Technology provides practical SQL Server Integration Services skills based technology training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All candidates receive comprehensive SQL Server Integration Services training materials and practice files which are theirs to refer to after the course. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Integration Services for as long as they need.

We provide instructor led training coupled with hands on training. 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 Kenilworth. 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.

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.

Our teaching team have over twenty years continuous technical training experience. Our clients include: Royal Air Force, Shell UK Oil Products Ltd, Boots UK Limited, DHL Express, EDF Energy PLC, Halfords Group PLC, Birmingham City University and GKN PLC.




Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Kenilworth
  • 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 ...
  • Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Working with Advanced Logging and Reporting
    Handling Errors Common SQL Server Integration Services Design Patterns
    Data Loading with the Analysis Services Tasks
    Optimizing Sources for Extraction
    Utilizing the Import/Export Wizard
    Creating Dynamic Packages
    Utilizing SQL Server Integration Services Data Typing
    Performing Joins with the Merge Transformation
    Looping and Sequence Tasks
    Choosing the Script Task or Script Component
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Define and Use Variables and Parameters
    The SQL Server Integration Service
    SQL Server Integration Services Architecture
    Understanding Deployment Strategies 
    Understanding Parameters SQL Server Integration Services Tools
    Coding the Script Task
    Using Expressions in Packages Containers
    Creating SQL Server Integration Services Packages
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages

  • See Training Course Details...



Email us about this courses



Other Kenilworth Enable Technology Training Courses

VBA - Kenilworth Excel Training Courses
Power Query - Kenilworth Excel Training Courses
JavaScript Kenilworth Training Courses