OCP Database 10g Administrator


Gain expertise relational databases designed for grid computing

Train to become the expert of your organization’s database and reap the rewards of a lucrative career as a database manager with the OCP Database 10g Administrator certification.

On-Demand, Bootcamp or Virtual Classroom options

Access online course content, videos, exercises, discussions and chats

Pre and post course assessments

Virtual labs for hands-on experience

Live lab add-ons available

Develop real-life skills you can apply in the workplace with Live Labs

Access to over 25,000 e-books and 30,000 downloadable video tutorials

Expert mentoring and coaching to answer questions and guide your learning

Course completion certificates

Request Information

Enter Question *



Outstanding opportunities are available for those who prove their database skills with an Oracle certification in database technology.



Database administration is a much needed skill set for many organizations around the world. Train and certify on the OCP Database 10g Administrator and watch your demand grow.



Oracle certifications are recognized globally and create a multitude of career opportunities for those who train.

Course guide

Qualification: OCP 10g Administrator Certified Professional

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

Vendor: Oracle

Student support: Success Advisors

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


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 KnowledgeNet 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