Information Technology - IT Courses

You are here:

Home Information Technology - IT CoursesOracle OCA 10g

Oracle Certified Associate 10g (OCA 10g)

Certification Training

Gain internationally recognised database administration (DBA) skills and enhance your credibility with the Oracle Certified Associate 10g (OCA 10g) certification.

SEEK Learning will provide you with all the training you need to pass the OCA 10g exams and get certified - guaranteed.

Who is this course for?

Database administrators
Support engineers
Project managers
Database designers
Technical consultants

View all Oracle courses

Quick Course Guide

Qualification: OCA 10g
Student support: Weekday email support by expert mentors

Study time: 8 weeks
Pre-requisites: None

Enrolment dates: Enrol anytime - start now!
Assessment: OCA 10g exams 1Z0-042 and 1Z0-047 or 1Z1-051 (by external provider)

Delivered by: SkillSoft
Resources required: Internet, email

Your First Step Towards Becoming an Oracle DBA

Oracle certifications are industry-recognised, sought-after credentials that can help you succeed in your IT career.

The OCA 10g credential is your first step toward success as an Oracle professional, and gives you a firm foundation in basic database administration. Oracle DBAs manage the industry's most advanced information systems and command some of the highest salaries.

Find out if the OCA 10g is right for you - contact a SEEK Learning consultant for free expert advice.

Skills You'll Gain

Installing the Oracle database software
Creating an Oracle database
Managing database storage structures
Managing schema objects
Implementing Oracle database security
Configuring the Oracle network environment
Performing database backup and recovery
Moving data

What's Included

Weekday email support by expert mentors
Access to online library Books 24x7
Hands-on interactive exercises
Practice exam questions
Self-paced study format
Certification guarantee - get certified or your money back

OCA 10g Course Details

Course Outline

1Z0-042 Oracle Database 10g: Administration I

Oracle Database 10g: Installing Oracle Database 10g Release 2
Oracle Database 10g: Creating Databases Release 2
Oracle Database 10g: Database Interfaces Release 2
Oracle Database 10g: Database Control and Storage Structures Release 2
Oracle Database 10g: Users and Security Release 2

Oracle Database 10g: Managing Schema Objects and Data Release 2
Oracle Database 10g: The SQL*Loader and PL/SQL Release 2
Oracle Database 10g: Oracle Net Services and Shared Servers Release 2
Oracle Database 10g: Monitoring and Maintenance Release 2
Oracle Database 10g: Managing Undo Data and Lock Conflicts Release 2
Oracle Database 10g: Managing Backup and Recovery Release 2

And either

1Z0-047 Oracle Database SQL Expert

Oracle Database 11g: Using SQL to Query Your Database
Oracle Database 11g: Conversion Functions, Group Functions and Joins
Oracle Database 11g: Subqueries, Set Operators and Data Manipulation
Oracle Database 11g: Using DDL, Views, Sequences, Indexes and Synonyms

Oracle Database 11g: Controlling User Access and Managing Schema Objects
Oracle Database 11g: Data Dictionary Views and Large Data Sets
Oracle Database 11g: Managing Data in Different Time Zones
Oracle Database 11g: Using Subqueries and Regular Expressions

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

Oracle Database 11g: Using SQL to Query Your Database
Oracle Database 11g: Conversion Functions, Group Functions and Joins

Oracle Database 11g: Subqueries, Set Operators and Data Manipulation
Oracle Database 11g: Using DDL, Views, Sequences, Indexes and Synonyms

SEEK Learning's Oracle certification training will fully prepare you for the OCA 10g exams.

Please note that the OCA 10g exams are held by an external provider. For your convenience, SEEK Learning will help you find your nearest exam centre. Contact a SEEK Learning consultant for further information or assistance.

Training Exclusively Through SEEK Learning

SEEK Learning provides training from SkillSoft, an Oracle approved content provider.

SkillSoft does not generally offer courses directly to individuals, but our partnership enables us to exclusively offer Oracle training directly to you.

SkillSoft courses are developed according to the certification specifications of Oracle.