Oxford Applied Training

Keeping your exams current is important to any IT professional. This training program is in preparation for the Oracle 1Z0-062 certification exam.

Course Content

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 Back-Up And Recovery
12.1 Back-Up­ Part 1
12.2 Back-Up ­Part 2
12.3 Back-Up ­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