Data, Analytics & AI Category Banner Image

Oracle Database Administration (OCDA)

  • Length 5 days
  • Price  NZD 4500 exc GST
Course overview
View dates &
book now

Why study this course

Oracle Database Administration is a comprehensive, hands-on course providing concrete information on the design of an Oracle® Database instance and database, allowing you to manage your database investment.

In this course, you'll learn how to create database storage structures that align with your requirements and business models. You'll also learn how to create users and administer databases, as well as harden the databases to meet your business requirements.

This is the foundational course for learning about Oracle Database Administration, and it does not assume prior knowledge of Oracle technologies.

Request Course Information

What you’ll learn

After completing this course, students should be able to:

  • Describe Oracle Database architecture

  • Create and manage an Oracle database

  • Configure the database to support your applications

  • Manage database security and implement auditing

  • Implement basic backup and recovery procedures

  • Move data between databases and files

  • Employ basic monitoring procedures and manage performance

Oracle corporate PNG logo

Oracle at Lumify Work

Oracle offers a complete enterprise cloud designed to modernise your business, including cloud applications and cloud infrastructure services. Lumify Work offers courses in Oracle Database and web app development so you can utilise the world's leading converged, multimodel database management system in the cloud.

Who is the course for?

Anyone seeking to learn the fundamentals of administering an Oracle Database, to meet their business requirements.

Course subjects

  1. Understanding Oracle Database Architecture

    • Overview of the Oracle Database Architecture

    • The Oracle Database Instance

    • Oracle Database Memory Structures

    • Process Architecture and Structures

    • Server and Client Processes

    • Oracle Database Storage Architecture

    • Connect to the Oracle Database Instance

  2. Managing Database Instances

    • Oracle Database Management tools

    • Use SQL*Plus in Oracle to Manage a Database Instance

    • Use SQL Developer to Manage a Database Instance

    • Enterprise Manager Database Express

    • Initialisation Parameter Files

    • Starting up and shutting down a database instance

  3. Managing Users, Roles, and Privileges

    • Predefined database user accounts

    • Administrative privileges

    • Authentication options

    • Manage User Sessions

    • Privileges and roles

    • Profiles and users

  4. Managing Tablespaces and Datafiles

    • Exploring the storage structure

    • Creating a new tablespace

    • Altering a tablespace

    • Dropping tablespaces

    • Oracle Managed Files

    • Moving or renaming an Online Data File

  5. Moving Data

    • Moving Data: General Architecture

    • Directory Objects

    • Oracle Data Pump

    • Data Pump import transformations

    • SQL*Loader

    • External Tables

  6. Configuring Oracle Net Services

    • Oracle Net Services overview

    • Oracle Net Listener

    • Name Resolution

    • User sessions and naming methods

    • Oracle Net Manager

    • Listener Control Utility

  7. Managing Space

    • Block Space Management

    • Row Chaining and Migration

    • Segments

    • Extents

    • Table Compression

    • Shrinking segments

    • Segment Advisor

    • Resumable space allocation

  8. Managing Undo

    • Transactions and Undo data

    • Storing undo information

    • Managing undo retention

    • Temporary undo

    • Viewing undo activity and using the Undo Advisor

  9. Creating CDBs and Regular PDBs

    • Multitenant overview

    • Creating CDBs

    • Creating PDBs

    • Moving PDBs

    • Migration from a non-CDB environment

  10. Backup and Duplicate

    • Configuration for Recoverability

    • Fast Recovery Area

    • Redo Log files

    • Archiver Process and ARCHIVELOG mode

    • Performing backups using Recovery Manager (RMAN)

  11. Recovery and Flashback

    • Opening a database

    • Keeping a database open

    • Data Recovery Advisor

    • Recovering from a loss of a System-Critical Data File

    • Recovering from a loss of a Noncritical Data File


  • Basic understanding of Oracle Database principles

  • Linux skills, including familiarity with command-line options such as ls, cd, cp, and su

  • Beginner to intermediate proficiency with SQL

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

Personalise your schedule with Lumify USchedule

Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.