WCC    Westminster College 020 8261 4684  
 Home  About us  Courses  Online Payment  Contact Pioneers in IT Training & Development   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 11g OCA

    What included?
    Oracle Curriculum
    Oracle WDP Materials
    Oracle Certified Trainer
    Oracle Certification
    Hand-on Training

    Course Fee: £790

    Course Start Dates

    Select Start Date Time Days Duration London
    22/05/2012 6.30-9.30pm Tue / Thu 5 weeks London
    26/05/2012 10.00-6.00pm Sat 5 weeks London
    11/06/2012 6.00-9.00pm Mon to Thu 3 weeks London
    23/07/2012 10.00-6.00pm Mon/Wed 3 weeks London
    10/07/2012 6.30-9.30pm Tue / Thu 5 weeks London
    16/07/2012 10.00-5.00pm Mon/Wed 3 weeks London
    20/08/2012 10.00-5.00pm Mon/Wed 3 weeks London
    24/09/2012 10.00-5.00pm Mon/Wed 3 weeks 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.

    Course Content

    Oracle Database/ SQL Expert: Exam 1Z0-147

    Introduction to Oracle SQL
  • Relational Database Systems
  • Testing SQL
  • SQL Developer and SQL Plus
  • Testing the Database and Schema
    Select Statements
  • Basic Select Statements
  • Selecting Columns and Using Arithmetic Operators
  • Operator Precedence
  • Concatenation Operator
  • Displaying the Table Structure
    Where and Order By Clauses
  • Implementing the Where Clause
  • Comparison Operators
  • Logical Operators
  • Rules of Precedence
  • Substitution Variables
    Functions
  • Types of Single Row Functions
  • Working with Dates
  • Types of Group Functions
  • Creating Groups of Data
  • Multi Column Grouping
    Joins
  • Natural Joins
  • Nonequijoins and Outer Joins
  • Cartesian Joins
    Sub-Queries
  • Single Row Subqueries
  • Multiple Row Subqueries
  • Null Values
    Set Operators
  • Union and Union All Operators
  • Intersect and Minus Operators
  • Select Statements and the Order By Clause

    Oracle OCA Exam 1Z0-152

    Database Architecture
  • Architectural Components of the Oracle Database
  • Memory Structures
  • Server and Background Processes
  • Logical and Physical Storage Structures
    Installing the Oracle Software
  • Database Administrator Tasks and Tools
  • Planning a Oracle Database Installation
  • Using Optimal Flexible Architecture
  • Installing the Oracle Software using OUI
    Creating an Oracle Database & Instance
  • Planning for Database Creation
  • Configuring the Listener
  • Creating a Database
  • Starting and Stopping the Oracle Database
  • Using the Oracle Enterprise Manager
  • Access a Database with SQL*Plus
  • Modify Database Initialization Parameters
  • Database Startup
  • Database Shutdown
  • Viewing the Alert Log and Dynamic Performance Views
    Oracle Network Environment
  • Creating and Configuring Additional Listeners
  • Creating Oracle Net Service Aliases
  • When to Use Shared and Dedicated Servers
    Database Storage Structures
  • Describe Table Row Data and Define Tablespaces
  • Creating and Managing Tablespaces
  • Automatic Storage Management
    User Security
  • Create and Manage User Accounts
  • Grant and Revoke Privileges
  • Create and Manage Roles
  • Create and Manage Profiles
    Schema ObjectsM
  • Defining Schema Objects and Data Types
  • Creating and Modifying Tables
  • Defining Constraints
  • Viewing Columns and Contents of a Table
  • Creating Indexes
  • Creating Views
  • Creating Sequences
  • Using Temporary Tables
    Data and Concurrency
  • Managing data Using SQL
  • Identifying and Administering PL/SQL Objects
  • Monitoring and Resolving Locking Conflicts
  • Implementing Undo Data
  • Working with Undo Data
    Security
  • DBA Security and Privileges
  • Enabling Auditing
  • Audit Options and Information
  • Fine Grained Auditing
  • Auditing the DBA and Maintaining the Audit Trail
    Maintenance & Oracle Performance
  • Managing Optimizer Statistics
  • Managing Automatic Workload Repository
  • Using the Automatic Database Diagnostic Monitor
  • Setting Alerts and Thresholds
  • Performance Monitoring with the Enterprise Manager
  • Using Automatic Memory Management
  • Viewing Performance Related Dynamic Views
  • Troubleshooting invalid and Unusable Objects
    Backup and Recovery
  • Types of Database Failure
  • Checkpoints| Redo Log Files| and Archive Log Files
  • Instance Recovery
  • Configuring for Recoverability
  • Configuring Archive Log Mode
  • Database Backups
  • Backup Solutions Overview
  • Configuring Backup Settings
  • Scheduling Backups
  • Backing up Control Files to a Trace File
  • Managing Backups and the Flash Recovery Area
  • Using the RMAN Command Line
  • Recovering From a Lost Control File
  • Recovering Redo Log Files
  • Recovering Non Critical and Critical Data Files
  • Using the Data Recovery Advisor
    Moving Data
  • Moving Data and Creating Directory Objects
  • Loading Data with the SQL Loader
  • Creating and Reading External Tables
  • Using Oracle Data Pump Export and Import
  • Data Pump Performance and Monitoring
    Database Maintenance
  • Using the Enterprise Manager Support Workbench
  • Metalink Integration and Managing Patches
  • Monitoring index partition usage
  • Rebuilding unusable indexes


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




Click Here to download enrolment form
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