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.
What you will learn:
- Memory structure
- Constraints and triggers
- 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 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 Backups Part 1
RMAN Backups Part 2
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
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.
Oracle Database Engineer
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.