reed.co.uk Courses

Header

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

Learn how to work with Oracle database tools and concepts.


StudyOnline247

Summary

Price
£199 inc VAT
Study method
Online, self-paced
Duration
1 Month
Qualification
Oracle Database 12c Administrator Certified Associate
Professional What's this?
Additional info
  • Exam(s) / assessment(s) not included in price & must be purchased separately

2 students purchased this course

Add to basket or enquire

Overview

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.

Qualification

Oracle Database 12c Administrator Certified Associate
Awarded by Oracle

Description

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

Users
Profiles
Privileges
Roles

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
Recovery
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.

Requirements

There are no formal prerequisites to undertaking this course.

Career path

Database Administrator
Oracle Database Engineer
Database Specialist
Database Analyst

Questions and answers

No questions or answers have been posted about this course.

Rating and reviews

There haven't been any reviews for this course yet.

Leave a review

Modals