OCA Database 10g Administrator

COURSE OVERVIEW

OCA 10g is the first step towards success as an Oracle professional

Become the master of your organization’s database and enjoy a gainful career as a database manager with the OCA 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 *

1

GREAT OPPORTUNITY

Abundant opportunities are available for those who validate their database expertise with a certification from an industry leader like Oracle.

2

LEARN IN-DEMAND SKILLS

Storing and protecting data is a highly valued skill in any organization. Achieve an Oracle certification and watch your demand grow.

3

GLOBALLY RECOGNIZED

Abundant opportunities are available for those who validate their database expertise with a certification from an industry leader like Oracle.

Course guide

Qualification: OCA 10g Administrator Certified Associate

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

Vendor: Oracle

Student support: Success Advisors

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

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