Oracle 11g OCA

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

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.

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

More info about our OCA courses

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

More info about our OCA courses

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

More info about our OCA courses

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

More info about our OCA courses

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

Enhance your skillset

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

Great earnings

Earn an average salary of £50,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

More info about our OCA courses

Course

OCP with Oracle University

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

Global community of over 40,000 students

Industry leading tuition with 1:1 personal tutor access

Unrivalled 360 Career Services and StudentCare™

Access virtual seminars and live classrooms

We only partner with the biggest accreditors in the world

Gain invaluable industry experience

Exclusive student benefits; Alumni community, TOTUM, industry events and lots more

Change career, start fresh or simply advance in your current role

Why learn with us

Quick enquiry

Oracle 11g OCA

COURSE OVERVIEW

Your quick course guide

Included in your modules

Get certified the Learning People way

Professional development that works around you

Salary Indicator

Salary Projection

Average salary after completing

£76k

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

Are you ready to future proof your career?

Enhance your skillset

Great earnings

A stepping stone in your career

Related

OCP with Oracle University

Why learn with us?

Our training is trusted by

Accredited by and partnered with