WCC    Westminster College 020 8261 4684  
 Home  About us  Courses  Online Payment 19/05/2012
ARCHITECT BUSINESS INTELLIGENCE DATABASE PROGRAMMING NETWORKING E-COMMERCE

    Training Locations

    Brentford

    1000 Great West Road
    Brentford TW8 9HH
    Tel: +44 (0)208 261 4684
    email: info@wcc.co.uk

    Brighton

    Boot camp style training only

    Mercure Brighton Seafront Hotel
    149 Kings Road
    BN1 2PP - BRIGHTON

    Bristol

    Boot camp style training only

    Mercure Bristol Brigstow Hotel
    Welsh Back 5-7
    BRISTOL BS1 4SP

    Coventry

    Boot camp style training only

    Mercure Coventry Brandon Hall Hotel
    Main street
    Brandon
    COVENTRY CV8 3FW

    Heartfordshire

    Boot camp style training only

    Letchworth Lane
    Letchworth Garden City
    Hertfordshire SG6 3NP

    Isleworth

    Coomb House
    7 St Johns Road
    Isleworth TW7 6NB

    London

    45 Oxford Street
    London W1D 2DN

    Sri Lanka

    BMICH
    Colombo
    Sri Lanka

    Our Customers

    Some of our recent corporate customers in 2011 include;

    • Cranfield University
    • City Index
    • Umi Plc
    • Prosper Housing
    • NobleProg
    • Pantheon Advisory Ltd

    Westminster College of Computing has trained the following customers in the past
    • Middlesex University
    • Imperial College
    • UCL
    • Ministry of Defence
    • Passport Office
    • Barclays
    • Logica
    • KPMG
    • House of Commons
    • Legal & General
    • Specialist School trust
    • Barbican Centre

    Oracle Data Integrator (ODI) 11g Administration & Development

    The best course taught in the United Kingdom
    Course Start Dates
    Select Start Date Time Days Duration Site
    23/04/2012 6.00-9.00pm Mon /Wed 5 Weeks Brentford
    05/05/2012 12.00-6.00pm Saturday 5 Days Brentford
    09/07/2012 6.00-9.00pm Mon / Wed 5 Weeks Brentford
    21/07/2012 12.00-6.00pm Saturday 5 Days Brentford
    15/10/2012 6.00-9.00pm Mon / Wed 5 Weeks Brentford
    17/11/2012 12.00-6.00pm Saturday 5 Days Brentford

    In completing the enrolling process and paying for your course, you are confirming that you have received enough information to make an informed decision and that the course is suited to your needs and abilities.

    Cost: £1290

    Prerequisites

    Required Prerequisites: Basic knowledge of ELT data processing
    Suggested Prerequisites: Working knowledge of SQL

    Course Content


    Introduction
  • Identifying the Course Units
  • What is Oracle Data Integrator?
  • Why Oracle Data Integrator?
  • Overview of ODI 11g Architecture
  • Overview of ODI 11g Components
  • About Graphical Modules
  • Types of ODI Agents
  • Overview of Oracle Data Integrator Repositories
    Administering ODI Repositories and Agents
  • Administrating the ODI Repositories
  • Creating Repository Storage Spaces
  • Creating and Connecting to the Master Repository
  • Creating and Connecting to the Work Repository
  • Managing ODI Agents
  • Creating a Physical Agent
  • Launching a Listener, Scheduler and Web Agent
  • Example of Load Balancing
    ODI Topology Concepts
  • Overview of ODI Topology
  • About Data Servers and Physical Schemas
  • Defining the Physical Architecture
  • Defining the Logical Architecture
  • Mapping Logical and Physical Resources
  • Defining Agents
  • Defining a Topology
  • Planning the Topology
    Describing the Physical and Logical Architecture
  • Overview of Topology Navigator
  • Creating Physical Architecture
  • Creating a Data Server
  • Testing a Data Server Connection
  • Creating a Physical Schema
  • Creating Logical Architecture
  • Overview of Logical Architecture and Context Views
  • Linking the Logical and Physical Architecture
    Setting Up a New ODI Project
  • Overview of ODI Projects
  • Creating a New Project
  • Using Folders
  • Organizing Projects and Folders
  • Understanding Knowledge Modules
  • Exchanging ODI Objects
  • Exporting and Importing Objects
  • Using Markers
    Oracle Data Integrator Model Concepts
  • What is a Model?
  • Understanding Metadata in ODI
  • Understanding Reverse Engineering
  • Creating Models
  • Organizing Models
  • Creating Data stores
  • Using Constraints in ODI
  • Creating Keys and References
    Organizing ODI Models and Creating Data stores
  • What is an Interface?
  • Business Rules for Interfaces
  • What is a Mapping?
  • What is a Join?
  • What is a Filter?
  • What is a Constraint?
  • What is a Staging Area?
  • Creating a Basic Interface
    ODI Interface Concepts
  • What is an Interface?
  • Business Rules for Interfaces
  • What is a Mapping, Filter, Join?
  • Overview of Integration Process
  • What is a Staging Area?
  • About Execution Location
  • Using Knowledge Modules (KM) with ODI Interface
  • Creating a Basic Interface
    Designing Interfaces
  • Designing an Interface
  • Multiple Source Data stores
  • Creating Joins
  • Filtering data
  • Disabling Transformations
  • Overview of the Flow
  • Specifying the Staging Area
  • Selecting Knowledge Modules
    Interfaces: Monitoring and Debugging
  • Monitoring Interfaces
  • Using Operator
  • Viewing Sessions and Tasks
  • How to Monitor Execution of an Interface
  • How to Troubleshoot a Session
  • Keys to Reviewing the Generated Code
  • Working with Errors
  • Tips for Preventing Errors
    Designing Interfaces: Advanced Topics
  • Using Business Rules in Interfaces
  • Overview of Business Rule Elements
  • Using variables
  • Using User Functions
  • Using Substitution Methods
  • Modifying a KM
  • Developing Your Own KM
  • Using RKM for Customized Reverse Engineering
    Using ODI procedures
  • What is a Procedure?
  • Examples of Procedures
  • Creating Procedures
  • Adding Commands
  • Adding Options
  • Running a Procedure
  • Using Operator to View Results
    Using ODI Packages
  • What is a package?
  • Creating a package
  • Executing a package
  • Creating Advanced Packages
  • Error handling
  • Controlling an Execution Path
  • Creating a Loop
  • Using the Advanced tab
    Managing ODI Scenarios and Versions
  • What is a Scenario?
  • Managing Scenarios
  • Preparing Scenarios for Deployment
  • Automating Scenario Management
  • Scheduling the ODI Scenario
  • Overview of ODI version management
  • Using Version Browser and Version Comparison Tool
  • Handling concurrent changes
    Enforcing Data Quality and Auditing Data with ODI
  • Why Data Quality?
  • When to Enforce Data Quality?
  • Data Quality in Source Applications
  • Data Quality Control in the Integration Process
  • Data Quality in the Target Applications
  • Enforcing Data Quality
  • Exploring Your Data
  • Auditing Data Quality
    Working with Changed Data Capture
  • Overview of ODI version management
  • Techniques of Changed Data Capture
  • Changed Data Capture in ODI
  • CDC Strategies and Infrastructure
  • CDC Consistency
  • Using CDC
  • Viewing Data/Changed data
  • Using Journalizing
    Administering ODI Resources: Advanced Topics
  • Using Open Tools
  • Installing Open Tools
  • Using Open Tools in a Package
  • Using Open Tools in a Procedure or in a KM
  • Developing Your Own Open Tools
  • Setting Up ODI Security
  • Defining Security Policies
  • Defining Password Policies
    Using Web Services and Integration of Oracle Data Integrator with SOA
  • Web Services in Action
  • Using Data Services
  • Setting Up Data Services
  • Testing Data Services
  • Installing Public Web Services
  • Using Public Web Services
  • Invoking Web Services
  • Integrating ODI with SOA
    Extending ODI with the SDK
  • Using SDK Public Interfaces
  • Integrating through ODI SDK
  • Examining SDK examples

No of Delegates

The number of delegates in our classes is normally less than 6. In most cases, the Bootcamp classes will have only 2.

Facilities

The training session will be both theory and practical based. PCs will be available for all the delegates for hands-on training and will be provided with training materials. Lunch will be served for delegates attending bootcamp training. All the delegates will be allowed to have tea or coffee free of charge, during the break time of the training session.

Training Intercity

WCC will be able arrange one week bootcamp training in any part of the UK. The booking must be done at least two months in advance. the bootcamp training will take place in Mercure hotels. The maximum number of delegates will be 4.

Job Vacancies

The following job vancancies are available for freelance trainers to travel intercity to conduct training sessions on a part time rolling contract basis. Travelling and accommodation will be covered by us. The candidate must posses a degree in Information Technology with 2 Years experience in the related topic. Salary will be based on the experience and not less than £120 per day.

  • Android Development
  • Drupal Development
  • Linux Administrator
  • Ruby Development
  • Sun Solaris Admin
  • Oracle RAC
  • MS Lightswitch
  • MS Dynamix AX
  • MCTS SQL BI
  • Oracle OBIEE
  • EJB
  • Photoshop
  • Illustrator

  • Send me information

    Name
    email
    Telephone
    Course Interested
    Address (Street)
    Town/City
    Post Code
    Message


    Special Offers

    Course 1Course 2Special Price
    Oracle ODI 11g Oracle OBIEE £3690
    Oracle ODI 11g Oracle OCA £2690
    Oracle ODI 11gSQL Server 2008 £4290
    Oracle ODI 11g EJB (Web Logic) £3690


    Westminster College is the trading name of Westminster College of Computing (UK) Ltd. Registered in England & Wales, Company No. 07507288,
    © Copyright 2011 www.wcc.co.uk - All Rights Reserved
    We conduct Fast Track IT Training & Bootcamp courses in Oracle Data Integrator (ODI) 11g Administration & Development Apps in the cities London, Bristol, Coventry, Aberdeen, England, Scotland and Ireland locations: in Banbury Franklin Covey, Birmingham West Midlands, Bournemouth Dorset, Bristol South West, Camberley Surrey, Cheltenham Gloucestershire, Chesterfield Derbyshire, Dublin Fitzwilliam Place, , Exeter South West, Farnborough Red Hat, Guildford, Hinckley East Midlands, Leeds Yorkshire, Leeds Yorkshire (Ring Road), Leeds Yorkshire City Centre, London In Tuition , London King William Street, London Middlesex Street, London Old Broad Street Fast Lane, London, London Rosebery Avenue, London Tabernacle Street, London Victoria, Manchester Altrincham, Manchester City Centre , Manchester Stockport, Milton Keynes Buckinghamshire, , Reading Berkshire, Reading Oracle, Scotland Aberdeen, Scotland Edinburgh, Scotland Glasgow, Scotland Glasgow, Slough Berkshire, Swindon Wiltshire, Windsor Berkshire, Colombo, Sri Lanka, BMICH, Batticaloa