OCA Database 10g Administrator


This course has been replaced by OCA 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

    A stepping stone in your career

    The OCA 10g credential is your first step towards success as an Oracle professional, and enhances your expertise in the most advanced database management systems.

  • 3

    Great earnings

    Oracle DBAs manage the industry's most advanced information systems and command some of the highest salaries.

Your quick course guide

Oracle 10g exam retires 1 March 2015

Certification: OCA 10g Administrator Certified Associate

Study time: Full time - 21 days | Part time - two to four months

Vendor: Oracle

Provider: Skillsoft

Student support: StudentCare™ and expert mentors

Prerequisites: Familiarity with data processing techniques and ability to use a GUI 

Assessment: Exam based - 1Z0-042, 1Z0-047 + 1Z0-051 - 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: Administration I

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

1Z0-047 Oracle database SQL expert

  • Using SQL to query your database
  • Conversion functions, group functions and joins
  • Sub queries, set operators and data manipulation 
  • Using Ddl views, sequences, indexes and synonyms 
  • Controlling user access and managing schema objects
  • Managing data in different time zones
  • Using sub queries and regular expressions 

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

  • Using SQL to query your database
  • Conversion functions, group functions and joins
  • Sub queries, set operators and data manipulation
  • Using Ddl views sequences indexes and synonyms

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