Get in touch

contact_icon_white

Oracle 11g OCA

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

1

Enhance your skillset

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

Great earnings

Earn an average salary of £50,000 and enjoy the opportunities meeting demand as an Oracle professional provides.
3

A stepping stone in your career

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

Salary Indicator

Salary Projection

Average salary after completing

Average Salary
Database Administrators
£28k
Average Salary
You can earn
£76k
Average Salary
Database Programmer
£125k
High
Source: Adzuna

£76k

You can earn an average of £76,300.00 a year

90% of hiring managers value IT certification, giving you a competitive edge to land the job

Are you ready to future proof your career?

Find out more

COURSE OVERVIEW

This certification created by Oracle is extremely widely recognised 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.

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

Why learn with us?

We're tech career experts
50,000+ students worldwide
Alternative to traditional university education
Start a new career or advance your current one & land your dream job
Most in-demand skills for today's job market
Award winning StudentCareTM
Partnered with biggest accreditors in the world
Exclusive student benefits; CV detox, NUS, industry events & loads more

Our training is trusted by

Accredited by and partnered with