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

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 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