Enable Technology

SQL SERVER INTEGRATION SERVICES DERBY TRAINING COURSES 

SQL SERVER INTEGRATION SERVICES TRAINING COURSES DERBY




About Enable Technology Derby SQL Server Integration Services Training Courses

We are company which specialises in short, two and three day intensive SQL Server Integration Services technology training courses. We guarantee the training will be delivered by a Microsoft certified expert. Every person attending a SQL Server Integration Services course will be provided with training materials and practice files to retain 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.

SQL Server Integration Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can set up a training lab at your premises and deliver SQL Server Integration Services courses onsite at your site. We also offer the option of scheduling of SQL Server Integration Services course at a venue near you in Derby. We are happy to modify the SQL Server Integration Services syllabus to match your teams 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.

We have operated primarily in the West Midlands for twenty years. Some of our clients are TalkTalk Direct Limited, Royal & Sun Alliance Group PLC, Vodafone Group Services, Dollond & Aitchison Limited, National Power PLC, Norfolk Police Constabulary, Barclays Bank PLC and DHL Express.




Microsoft SQL Server Integration Services SSIS

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

  • See Training Course Details...



Email us about this courses



Other Derby Enable Technology Training Courses

PL/SQL - Derby SQL Training Courses
Excel Power Pivot Derby Training Courses
Oracle SQL Derby Training Courses