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

Module 1: Database Concepts And Tools

• 1.1 Instructor And Course Introduction
• 1.2 Database Concepts And Tools­ Part 1
• 1.3 Database Concepts And Tools­ Part 2

Module 2: Memory Structure

• 2.1 Memory Structure­ Part 1
• 2.2 Memory Structure ­Part 2

Module 3: Tables

• 3.1 Tables ­Part 1
• 3.2 Tables ­Part 2

Module 4: Indexes

• 4.1 Indexes ­Part 1
• 4.2 Indexes­ Part 2

Module 5: Constraints And Triggers

• 5.1 Constraints And Triggers ­Part 1
• 5.2 Constraints And Triggers ­Part 2

Module 6: Users

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

Module 7: Internal Structures

• 7.1 Storage Structures­ Part 1
• 7.2 Storage Structures ­Part 2
• 7.3 Internal Memory Structures ­Part 1
• 7.4 Internal Memory Structures ­Part 2
• 7.5 Background Processes ­Part 1
• 7.6 Background Processes ­Part 2

Module 8: Starting Up and Shutting Down Database

• 8.1 Starting And Stopping Data Base ­Part 1
• 8.2 Starting And Stopping Data Base­ Part 2
• Module 9: Critical Storage Files
• 9.1 Critical Storage Files­ Part 1
• 9.2 Critical Storage Files­ Part 2

Module 10: Data Manipulation Language

• 10.1 DML Atomicity­ Part 1
• 10.2 DML Atomicity­ Part 2
• 10.3 DML Insert
• 10.4 DML Update ­Part 1
• 10.5 DML Update ­Part 2
• 10.6 DML Delete And Review Of DML Statements ­Part 1
• 10.7 DML Delete And Review Of DML Statements ­Part 2

Module 11: Data Concurrency

• 11.1 Data Concurrency ­Part 1
• 11.2 Data Concurrency­ Part 2

Module 12: BackUp And Recovery

• 12.1 BackUp­ Part 1
• 12.2 BackUp ­Part 2
• 12.3 BackUp ­Part 3
• 12.4 RMAN Catalog
• 12.5 RMAN BackUps ­Part 1
• 12.6 RMAN BackUps­ Part 2
• 12.7 Disaster Preparedness
• 12.8 Recovery
• 12.9 Flashback Recovery

Module 13: Installation

• 13.1 Installation ­Part 1
• 13.2 Installation­ Part 2

Module 14: Course Review

• 14.1 Course Review­ Part 1
• 14.2 Course Review­ Part 2
• 14.3 Course Review­ Part 3
• 14.4 Course Review­ Part 4
• 14.5 Course REview ­Part 5
• 14.6 Course Outro