Oracle Database 12c: Admin, Install and Upgrade Accelerated (D79027)


Duration: 5 days

This Oracle Database 12c: Admin, Install and Upgrade Accelerated course covers 7 days worth of content in only 5 days. It consists of the Oracle Database 12c: Administration Workshop Ed 1 course (5 days) and the Oracle Database 12c: Install and Upgrade Workshop Ed 1 course (2 days). In this course, you will be introduced to Oracle Database Cloud Service.

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

Learn To:

  • Upgrade an existing Oracle Database to Oracle Database 12c.
  • Create and manage an Oracle Database Instance.
  • Create and manage Storage Structures.
  • Configure the Oracle Network Environment.
  • Create and manage users.
  • Monitor the database and manage performance.
  • Learn basic information on backup and recovery techniques.
  • Gain an understand of the Oracle Database Cloud Service.


Upon completing this course, the learner will be able to meet these overall objectives:
  • Manage Oracle Database Storage structures
  • Gain an understand of the Oracle Database Cloud Service
  • Install Oracle Database 12c software
  • Upgrade database to Oracle Database 12c
  • Create an Oracle Database
  • Create a container database
  • Monitor the Database
  • Manage Database Performance
  • Implement Database Auditing
  • Configure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and Tasks
  • Schedule Jobs to Run Inside or Outside of the Database
  • Configure Oracle Net Services
  • Configure your Database For Backup and Recovery Operations
  • Describe Oracle Database Architecture
  • Manage the Oracle Database Instance


Module 1: Introduction

Module 2: Exploring the Oracle Database Architecture

Module 3: Oracle Software Installation Basics

Module 4: Installing Oracle Database Software

Module 5: Creating an Oracle Database by Using DBCA

Module 6: Oracle Database Management Tools

Module 7: Managing the Database Instance

Module 8: Configuring the Oracle Network Environment

Module 9: Administering User Security

Module 10: Managing Database Storage Structures

Module 11: Managing Space

Module 12: Managing Undo Data

Module 13: Managing Data Concurrency

Module 14: Implementing Oracle Database Auditing

Module 15: Backup and Recovery Concepts

Module 16: Backup and Recovery Configuration

Module 17: Performing Database Backups

Module 18: Performing Database Recovery

Module 19: Moving Data

Module 20: Performing Database Maintenance

Module 21: Managing Performance

Module 22: Oracle Database Cloud Service: Overview


Who Should Attend
  • Database Administrators
  • Database Designers
  • Support Engineer
  • Technical Administrator


  • Working knowledge of SQL and use of PL/SQL packages

Suggested Prerequisites:

  • Basic knowledge of Linux Operating System




Course ID:

Show Schedule for: