Oracle Database 12c: Installation and Administration 1Z0-062

Learn how to work with Oracle database tools and concepts.



Save 25%
£149 inc VAT (was £199)
Or £49.67/mo. for 3 months... Read more
Offer ends 31 August 2020
Study method
Online, self-paced
1 Month
Oracle Database 12c Administrator Certified Associate
Professional certification What's this?
Additional info
  • Exam(s) / assessment(s) not included in price, and must be purchased separately

2 students purchased this course

Add to basket or enquire


This course will teach students about Oracle database concepts and tools, internal memory structures and critical storage files. It also aims to inform students about constraints and triggers, background processes and internal memory structures.


Oracle Database 12c Administrator Certified Associate
Awarded by Oracle


What you will learn:

  • Memory structure
  • Tables
  • Indexes
  • Constraints and triggers
  • Privileges
  • Flashback recovery

Why study online?

Technological improvements and advances in educational design mean that studying online is no longer just a low cost alternative to traditional training methods. In many respects our online courses offer training which is superior to the majority of available “classroom” options.

Not only is the effectiveness of the training process enhanced, but also the convenience and overall cost efficiency of studying online makes it a compelling option for training. You can learn at your own pace and can repeat each section as many times as required unlike in a classroom environment.

Studying at your own pace, rewinding and going over the material as often as you need improves your long-term memory retention and makes studying more rewarding.

Curriculum for the Oracle 12c OCP 1Z0-062: Installation and Administration course:

Module 1 Database Concepts And Tools

Instructor And Course Introduction
Database Concepts And Tools Part 1
Database Concepts And Tools Part 2

Module 2 Memory Structure

Memory Structure Part 1
Memory Structure Part 2

Module 3 Tables

Tables Part 1
Tables Part 2

Module 4 Indexes

Indexes Part 1
Indexes Part 2

Module 5 Constraints And Triggers

Constraints And Triggers Part 1
Constraints And Triggers Part 2

Module 6 Users


Module 7 Internal Structures

Storage Structures Part 1
Storage Structures Part 2
Internal Memory Structures Part 1
Internal Memory Structures Part 2
Background Processes Part 1
Background Processes Part 2

Module 8 Starting Up and Shutting Down Database

Starting And Stopping Data Base Part 1
Starting And Stopping Data Base Part 2

Module 9 Critical Storage Files

Critical Storage Files Part 1
Critical Storage Files Part 2

Module 10 Data Manipulation Language

DML Atomicity Part 1
DML Atomicity Part 2
DML Insert
DML Update Part 1
DML Update Part 2
DML Delete And Review Of DML Statements Part 1
DML Delete And Review Of DML Statements Part 2

Module 11 Data Concurrency

Data Concurrency Part 1
Data Concurrency Part 2

Module 12 Back-Up And Recovery

Back-Up Part 1
Back-Up Part 2
Back-Up Part 3
RMAN Catalog
RMAN Backups Part 1
RMAN Backups Part 2
Disaster Preparedness
Flashback Recovery

Module 13 Installation

Installation Part 1
Installation Part 2

Module 14 Course Review

Course Review Part 1
Course Review Part 2
Course Review Part 3
Course Review Part 4
Course Review Part 5
Course Outro

Please note that the official exam is not included, however for those who complete the course, they will receive a completion certificate upon request.

Who is this course for?

Anyone that wishes to familiarise themselves with the installation and administration of an Oracle database.


There are no formal prerequisites to undertaking this course.

Career path

Database Administrator
Oracle Database Engineer
Database Specialist
Database Analyst

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.


Currently there are no reviews for this course. Be the first to leave a review.


What does study method mean?

Study method describes the format in which the course will be delivered. At courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

What are CPD hours/points?

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on, many of which can be completed online.

What is a ‘regulated qualification’?

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

What is an ‘endorsed’ course?

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body’s logo if they wish. Certain awarding bodies - such as ABC Awards and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.


Mobile Navigation