OCP Database 10g Administrator


This course has been replaced by Oracle Database 12c Administrator

  • 1

    Highly demanded field of expertise

    With 97% of Global Fortune 500 companies using Oracle software, Oracle certifications are industry recognised sought after credentials that can help you succeed in your IT career.

  • 2

    Prove you have what it takes

    This advanced certification proves your skills in configuring an Oracle database for multilingual applications, using various methods of recovering and tuning the database, and using database technologies such as Resource Manager Scheduler and Automatic Storage Management - ASM.

  • 3

    Great earnings

    An OCP certified professional earns an average wage of £48,250 per year which only increases with experience, making it a lucrative career path to follow.

Your quick course guide

Oracle 10g exam retires 1 March 2015

Certification: OCP 10g Administrator Certified Professional

Study time: Full time - 12 days | Part time - one month 

Vendor: Oracle

Provider: Skillsoft

Student support: StudentCare™ and expert mentors

Prerequisites: OCA 10g certification 

Assessment: Exam based - 1Z0-043 - please note, the Oracle 10g exam retires 1 March 2015, training will still be available but students will no longer be able to sit the exam after this date

Resources: Internet access and email

Ideal for: Database administrators, database designers, developer, support engineers or technical administrators

Included in your modules

1Z0-042 Oracle Database 10g release 2: Administration 1

  • Installing Oracle database 10g
  • Creating databases
  • Database interfaces
  • Database control and storage structures
  • Users and security
  • Managing schema objects and data
  • The SQL loader and Pl/SQL
  • Oracle net services and shared servers
  • Managing undo data and lock conflicts
  • Monitoring and maintenance
  • Managing backup and recovery

1Z0-043 Oracle Database 10g: Administration 2    

  • Using flashback technology
  • Performing and managing backups
  • Advanced database recovery and repair
  • Controlling the Oracle listener and enabling distributed transactions
  • Using globalisation support

1Z0-047 Oracle Database 11g SQL Expert

  • Using SQL to query your database
  • Conversion functions, group functions and joins
  • Subqueries, set operators and data manipulation
  • Using Ddl, views, sequences, indexes and synonyms
  • Controlling user access and managing schema objects
  • Data dictionary views and large data sets
  • Managing data in different time zones
  • Using subqueries and regular expressions

1Z0-051 Oracle Database 11g: SQL Fundamentals I

  • Optimising database performance in Oracle 10g
  • Managing storage and system resources in Oracle 10g
  • Using the sheduler to automate tasks in Oracle 10g 
  • Using advanced features in Oracle 10g

Get certified the Learning People way

Professional development that works around you

  • World's #1 eLearning portal
  • Global community of peers
  • Expert mentors
  • 12 months unlimited access
  • Test prep
  • Training mapped to Java exam curriculum
  • Award winning training used globally by leading corporate clients

Average salary

2013 JAN
2014 JAN
2015 JAN
2016 JAN
Read more

Why join us?

  • Award winning customer support
  • We know the job market inside out
  • Trusted by the giants
  • Value for money
  • CV detox - exclusive to our students
  • We're with you from start to finish
  • Expert career advice
  • Progress reports
  • Exam booking support
  • All UK students receive an NUS student discount card
  • Your success is our success

CV detox

It's not just about your CV...