Module 1: Database Concepts And Tools

1. Instructor And Course Introduction
2. Database Concepts And Tools – Part 1
3. Database Concepts And Tools – Part 2

Module 2: Memory Structure

1. Memory Structure – Part 1
2. Memory Structure – Part 2

Module 3: Tables

1. Tables – Part 1
2. Tables – Part 2

Module 4: Indexes

1. Indexes – Part 1
2. Indexes – Part 2

Module 5: Constraints And Triggers

1. Constraints And Triggers – Part 1
2. Constraints And Triggers – Part 2

Module 6: Users

1. Users
2. Profiles
3. Privileges
4. Roles

Module 7: Internal Structures

1. Storage Structures – Part 1
2. Storage Structures – Part 2
3. Internal Memory Structures – Part 1
4. Internal Memory Structures – Part 2
5. Background Processes – Part 1
6. Background Processes – Part 2

Module 8: Starting Up and Shutting Down Database

1. Starting And Stopping DataBase – Part 1
2. Starting And Stopping DataBase – Part 2

Module 9: Critical Storage Files

1. Critical Storage Files – Part 1
2. Critical Storage Files – Part 2

Module 10: Data Manipulation Language

1. DML Atomicity – Part 1
2. DML Atomicity – Part 2
3. DML Insert
4. DML Update – Part 1
5. DML Update – Part 2
6. DML Delete And Review Of DML Statements – Part 1
7. DML Delete And Review Of DML Statements – Part 2

Module 11: Data Concurrency

1. Data Concurrency – Part 1
2. Data Concurrency – Part 2

Module 12: BackUp And Recovery

1. Back Up – Part 1
2. Back Up – Part 2
3. Back Up – Part 3
4. RMAN Catalog
5. RMAN BackUps – Part 1
6. RMAN BackUps – Part 2
7. Disaster Preparedness
8. Recovery
9. Flashback Recovery

Module 13: Installation

1. Installation – Part 1
2. Installation – Part 2

Module 14: Course Review

1. Course Review – Part 1
2. Course Review – Part 2
3. Course Review – Part 3
4. Course Review – Part 4
5. Course Review – Part 5
6. Course Outro

WHAT WILL I LEARN?

1. Ability to understand the database concepts and tools, memory structure, tables, and indexes.
2. Ability to understand the database concepts and tools., memory structure, tables, and indexes.
3. Learn how to undertake installation, backup, and recovery in the workplace.
4. Gain a full understanding of the benefits of an oracle database that is re-engineered for cloud computing.
5. Learn the oracle database architecture and discover how to effectively manage an oracle database instance.
6. Learn skills that database administrators need in today’s competitive marketplace.

The Oracle 1Z0-062 certification exam will prepare you for your Oracle Database 12c Installation and Administrator Professional certification.

With Global Edulink’s Oracle 12c: Installation and Administration (OCP 1Z0-062) course, learners will gain a full understanding of the benefits of an Oracle Database that is re-engineered for Cloud Computing. Multitenant architecture brings businesses exceptional performance, manageability benefits, hardware and software efficiencies, and fast and efficient Cloud provisioning. This certification emphasises the full set of skills that Database Administrators need in today’s competitive marketplace.

This course will teach you about the Oracle database architecture and you will discover how to effectively manage an Oracle database instance. Candidates will also be provided with key information on how to install and administer an Oracle database 12c.