Information Technology - IT Courses

You are here:

Home Information Technology - IT CoursesOracle Database 11g Administrator Certified Associate (OCA 11g)

Oracle Database 11g Administrator Certified Associate (OCA 11g)

Certification Training

Validate your skills in keeping an Oracle database environment running at maximum efficiency with the Oracle Database 11g Administrator Certified Associate (OCA 11g) certification.

SEEK Learning will provide you with all the training you need to pass the OCA 11g exams (1Z0-047 or 1Z0-051 and 1Z0-052) and get certified.

Who is this course for?

Database administrators (DBAs)
Database analysts
Database developers
Technical consultants

View all Oracle courses

Quick Course Guide

Qualification: OCA 11g
Student support: 24x7 access to a comprehensive reference library

Study time: 7 weeks
Pre-requisites: None

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

Delivered by: SkillSoft
Resources required: Internet, email

Build a Strong Foundation in Database Administration

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

The entry-level OCA 11g certification demonstrates your ability to install, maintain, troubleshoot and fine-tune all aspects of an Oracle database - and is your first step towards more advanced Oracle certifications.

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

Skills You'll Gain

Among other things, you'll learn how to:

retrieve data using the SQL SELECT statement
display data from multiple tables
use conversion functions and conditional expressions
create an Oracle database
manage database storage structures
manage schema objects
perform database backup and recovery
move data

What's Included

Access to online library Books 24x7
Hands-on interactive exercises
Practice exam questions
Self-paced study format

OCA 11g Course Details

Course Outline

1Z0-047

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

And

1Z0-052

Oracle Database 11g: Database Architecture and Installation
Oracle Database 11g: Database Creation, Instance Management and Connectivity
Oracle Database 11g: Storage Structures and User Security
Oracle Database 11g: Managing the Schema, Data and Concurrency
Oracle Database 11g: Managing Undo Data, Database Security and Maintenance
Oracle Database 11g: Performance Monitoring, Recovery Concepts and Backup
Oracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database
Oracle Database 11g Release 2: Database Architecture and Installation

Oracle Database 11g Release 2: Database Creation and Instance Management
Oracle Database 11g Release 2: The ASM Instance and Network Connectivity
Oracle Database 11g Release 2: Storage Structures and User Security
Oracle Database 11g Release 2: Managing Concurrency, Undo and Auditing
Oracle Database 11g Release 2: Managing Database Maintenance and Performance
Oracle Database 11g Release 2: Backup and Recovery
Oracle Database 11g Release 2: Moving Data and Oracle Support

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

Please note that the OCA 11g 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, the premier global provider of IT e-learning courseware.

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