Get in touch

contact_icon_white

OCA Database 12c Administrator

Oracle has updated its cornerstone database software with multitenant, enabling database professionals to tap into the benefits of the cloud, such as resource sharing and management flexibility. If you want to stay top of the industry, then the Oracle Database 12c OCA is for you

1

New technologies

Automatic data optimisation is changing the information lifecycle, monitoring the age and usage of data, then automatically moving it to the most suitable storage and compression tiers
2

Great earnings

With the average wage for an OCA 12c certified individual being £55,000, this is a current and lucrative skillset to have
3

Prove you have what it takes

Training designed to enhance a candidate's knowledge on cloud computing, big data, security and availability

Salary Indicator

Salary Projection

Average salary after completing

Average Salary
Junior Database Engineer
£22k
Average Salary
You can earn
£73k
Average Salary
Database Programmer
£125k
High
Source: Adzuna

£73k

You can earn an average of £73,400.00 a year

There’s an average of 2 million tech jobs available, with 1.2 million IT job adverts live online

Become an in demand professional

Get in touch

COURSE OVERVIEW

Learn all you need to know about the installation and maintenance of the world’s first database designed for the cloud.

Your quick course guide

Certification: Oracle Database 12c OCA

Study time: 40-50 hours

Vendor: Oracle

Provider: Skillsoft

Student support: StudentCare™

Prerequisites: None

Assessment:  1 x 120 minutes, 75 questions (1Z0-061), 1 x 120 minutes, 67 questions (1Z0-062)

Resources: Internet access and email

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

Included in your modules

Essential skills for your career

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
Exploring the Oracle Database Architecture
Oracle Database Instance
Administering User Security
Create and manage tablespaces
Managing Data Concurrency
Performing Database Backups
Moving Data
Creating an Oracle Database Using DBCA
Introduction to DBAAS
Configuring the Oracle Network Environment
Managing Database Storage Structures
Managing Undo Data
Implementing Oracle Database Auditing
Backup and Recovery Configuration
Performing Database Recovery
Automating Tasks by Using Oracle Scheduler
Upgrading Oracle Database Software

Get certified the Learning People way

Professional development that works around you

World's #1 eLearning portal
Global community of peers
Hands on interactive Practice Labs
12 months unlimited access
Test prep
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