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

About this course

Keeping your exams current is important to any IT professional. The Oracle 1Z0-062 certification exam will prepare you for your Oracle Database 12c Installation and Administrator Professional certification with ease.

Course Outline

Module 1 Database Concepts And Tools

•  1.1 Instructor And Course ntroduction
•  1.2 DatabaseConcepts And Tools Part1
•  1.3 Database Concepts And Tools Part2

Module 2 Memory Structure

•  2.1 Memory Structure Part1
•  2.2 Memory Structure Part2

Module 3 Tables

•  3.1 Tables Part1
•  3.2 Tables Part2

Module 4 Indexes

•  4.1 Indexes Part1
•  4.2 Indexes Part2

Module 5 Constraints And Triggers

•  5.1 Constraints And Triggers Part1
•  5.2 Constraints And Triggers Part2

Module 6 Users

•  6.1 Users
•  6.2 Profiles
•  6.3 Privileges
•  6.4 Roles

Module 7 Internal Structures

•  7.1 Storage Structures Part1
•  7.2 Storage Structures Part2
•  7.3 Internal Memory Structures Part1
•  7.4 Internal Memory Structures Part2
•  7.5 BackgroundProcessesPart1
•  7.6 BackgroundProcessesPart2

Module 8 Starting Up and Shutting Down Database

•  8.1 StartingAndStoppingDataBasePart1
•  8.2 StartingAndStoppingDataBasePart2

Module 9 Critical Storage Files

•  9.1 CriticalStorageFilesPart1
•  9.2 CriticalStorageFilesPart2

Module 10 Data Manipulation Language

•  10.1 DML Atomicity Part1
•  10.2 DML Atomicity Part2
•  10.3 DML Insert
•  10.4 DML Update Part1
•  10.5 DMLUpdatePart2
•  10.6 DMLDeleteAndReview OfDMLStatementsPart1
•  10.7 DMLDeleteAndReview OfDMLStatementsPart2

Module 11 Data Concurrency

•  11.1 Data Concurrency Part1
•  11.2 Data Concurrency Part2

Module 12 BackUp And Recovery

•  12.1 Back Up Part1
•  12.2 Back Up Part2
•  12.3 Back Up Part3
•  12.4 RMAN Catalog
•  12.5 RMAN Back Ups Part1
•  12.6 RMAN Back Ups Part2
•  12.7 Disaster Preparedness
•  12.8 Recovery
•  12.9 Flashback Recovery

Module 13 Installation

•  13.1 Installation Part1
•  13.2 Installation Part2

Module 14 Course Review

•  14.1 Course Review Part1
•  14.2 Course Review Part2
•  14.3 Course Review Part3
•  14.4 Course Review Part4
•  14.5 Course Review Part5
•  14.6 Course Outro

 

Reviews