Quick enquiry


Is this a business enquiry?

Enquire Now

Oracle 11g OCA

Learn how to perform complex, hands-on activities through labs, study and practice


This certification created by Oracle is extremely widely recognized in the industry, 97% of Global Fortune 500 companies use Oracle software.

You’ll be exposed to a wide range of important database features, functions and tasks in this certification. It teaches you how to perform complex, hands-on activities through labs, study and practice.

OverviewWhat you'll learnWhat's included

Your quick course guide

Certification: Oracle 11g OCA

Study time: 40-50 hours

Vendor: Oracle

Provider: Skillsoft

Student support: StudentCare™ and expert mentors

Prerequisites: None

Assessment: 1 x 90 minute exam, 70 questions (1Z0-052), 1 x 120 minute exam, 75 questions (1Z0-061)

Resources: Internet access and email

Ideal for: Database administrators, database designers, developer support engineers or technical administrators

Included in your modules

Exploring Oracle Database Architecture
Creating an Oracle Database
Configuring the Oracle Network Environment
Administering User Security
Managing Undo Data
Database Maintenance
Performing Database Backups
Moving Data
Preparing the Database Environment
Managing the Oracle Instance
Managing Database Storage Structures
Managing Data and Concurrency
Implementing Oracle Database Security
Performance Management
Backup and Recovery Concepts
Performing Database Recovery
Restricting and Sorting Data
Using Conversion Functions and Conditional Expressions
Displaying Data from Multiple Tables using Joins
Managing Tables using DML statements
Retrieving Data using the SQL SELECT Statement
Using Single-Row Functions to Customize Output
Reporting Aggregated Data Using the Group Functions
Using Subqueries to Solve Queries
Introduction to Data Definition Language

Get certified the Learning People way

Professional development that works around you

World's #1 eLearning portal
Global community of peers
12 months unlimited access
Test prep mock exams
Hands-on interactive Practice Labs
Training mapped to Oracle exam curriculum
Award winning training used globally by leading corporate clients

Salary Indicator

Salary Projection

Average salary after completing

Average Salary
Database Developer
Average Salary
You can earn
Average Salary
Source: Adzuna


You can earn an average of $105,000.00 a year

Australia will need an extra 81,000 IT specialists in coming years, with project managers and analysts in particularly short supply

Are you ready to future proof your career?

Get in touch

Enhance your skillset

Learn a wide range of important database features, functions and tasks in this certification

Great earnings

Earn an average salary of $90,000 and enjoy the opportunities meeting demand as an Oracle professional provides

A stepping stone in your career

This entry level certification is your first step towards more advanced Oracle certifications

Why learn with us?

We'll get you career ready and help place you into the industry
Learn from home 24/7
Award winning digital education
Industry leading tuition with 1:1 personal tutor access
Global community of over 40,000 students
Unrivalled 360 Career Services and StudentCare™
Access virtual seminars and live classrooms
We only partner with biggest accreditors in the world
Gain invaluable industry experience
Change career, start fresh or simply advance in your current role

Our training is trusted by

Accredited by and partnered with