Oracle Data warehouse Design 11g, Oracle Data Warehousing 11gCourse in London @ Westminster College , IT Training, Computer Training Courses in Central London,Cambridge, Bristol, Corporate, Training,Brighton & Coventry, London Isleworth, Hounslow, Twickenham, Denmark, Copenhagen, France, Paris, Germany, Berlin

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 Warehouse Design 11g

The best course taught in the United Kingdom

Course Start Dates

Start Date	Time	Days	Duration	Site
30/01/2012	10.00-5.00pm	Mon to Fri	5 Days	Brentford
06/02/2012	9.00-5.00pm	Monday to Fri	5 Days	London
05/03/2012	10.00-5.00pm	Mon to Fri	5 Days	Brentford
09/04/2012	9.00-5.00pm	Mon to Fri	5 Days	London
07/05/2012	10.00-5.00pm	Mon to Fri	5 Days	Brentford
11/06/2012	9.00-5.00pm	Mon to Fri	5 Days	London

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: £1790

Course Content

ORACLE ARCHITECTURAL OVERVIEW

Processes
Memory
Directory
Dictionary and catalog
Connectivity
Replication
Partitioning
Database
Real Application Cluster (RAC)
LOGICAL DESIGN CONCEPTS
Why data modelling
Requirements analysis
Normalization vs. denormalization
Entity relationship modelling
Dimensional modelling
OLAP vs. OLTP
Star vs. snowflake schemas
Metadata considerations
Data marts
Workshop
DIMENSIONAL MODELLING DESIGN - INITIAL STEPS
How to establish business requirements
How to choose a business process (e.g., sales)
How to determine the business process grain (i.e., level of detail for fact table)
How to choose dimensions (e.g., time)
How to identify measurement (numeric facts) to populate the fact table
DIMENSIONAL MODELLING DESIGN - FACT TABLE
Definition
Granularity selection
Measurements
Additive vs. non-additive measures
Foreign keys
Joins with dimension tables
Staging
Workshop, case study
DIMENSIONAL MODELLING DESIGN - HIERARCHIES
Definition
Types
Levels
Level relationships
Workshop, case study

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

Special Offers

Course 1	Course 2	Special Price
Oracle Data Warehouse Design 11g	Oracle OBIEE	£2790
Oracle Data Warehouse Design 11g	Oracle OCA	£2690
Oracle Data Warehouse Design 11g	SQL Server 2008 Business Intelligence	£4290
Oracle Data Warehouse Design 11g	Oracle ODI 11g Admin & Development	£3690

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