Enable Technology

SQL SERVER INTEGRATION SERVICES CAERPHILLY TRAINING COURSES 

SQL SERVER INTEGRATION SERVICES TRAINING COURSES CAERPHILLY




About Enable Technology Caerphilly SQL Server Integration Services Training Courses

We are a company that provides short intensive SQL Server Integration Services training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each course participant will be issued with training SQL Server Integration Services resources which they can continue to use after the training. 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.

Delegates are taught by an experienced Microsoft professional. SQL Server Integration Services courses are delivered through a mix of practical hands on exercises and walk throughs. We can set up a training lab at your premises and deliver SQL Server Integration Services courses onsite at your site. Alternatively we could schedule a course at a local venue in Caerphilly. All SQL Server Integration Services courses can be customised to meet your particular requirements.

This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.

We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Birmingham City Council, Canadian High Commission, Dollond & Aitchison Limited, Total Telecommunications Limited, Loughborough University, TalkTalk Direct Limited, Birmingham Heartlands Hospital and Aston University.




Microsoft SQL Server Integration Services SSIS

  • 2 day course
  • Location: Caerphilly
  • 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 ...
  • Designing to Troubleshoot: Using Precedence Constraints
    Performing Joins with the Merge Transformation
    Handling Errors Common SQL Server Integration Services Design Patterns
    Using Destinations and Understanding choices
    Managing SQL with the SQL Tasks
    Coding the Script Task
    Utilizing Data Preparation Tasks
    Looping and Sequence Tasks
    Optimizing Sources for Extraction
    Managing with Control Flow
    Overview of Containers
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Creating SQL Server Integration Services Packages
    Understanding Variables
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Examining the SSIS Engine
    Performing Joins with the Lookup Transformation
    Utilizing Container Loops Performing Joins
    Working in the Explore Window
    Define and Use Variables and Parameters

  • See Training Course Details...



Email us about this courses



Other Caerphilly Enable Technology Training Courses

DAX Caerphilly Training Courses
JQuery Mobile - Caerphilly JavaScript Training Courses
Access - Caerphilly Access Training Courses