Oracle Database 12c: Installation and Administration

Course Outline

Course Syllabus

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