Skip To Content
NICF – Oracle Database: Administration Workshop (SF) is a Program

NICF – Oracle Database: Administration Workshop (SF)

Time limit: 49 days

$7,230 Enroll

Full program description

NICF - Oracle Database Administration Workshop (SF)

What's In It For Me

Download E-Brochure
  • Be certified in managing Oracle Databases.
  • Develop the full skill set needed to perform day to day administration.
  • Learn how to design and implement backup and recovery strategies, while consolidating operations with pluggable and multitenant container databases.

Course Overview

NTUC LearningHub Course Code: NICF010

SSG Skillsconnect Code: CRS-Q-0032079-ICT

This official Oracle Database 12c Administrator Certified Associate course was designed cover Oracle Database 12c: Install and Upgrade Workshop and the Oracle Database 12c: Administration Workshop contents over seven days. This course will teach students about the Oracle Database architecture and how to install Oracle Database 12c software, create a container database, provision pluggable databases, manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance.

Oracle Database 12c introduces a new multitenant architecture that makes it easy to consolidate many databases quickly and manage them as a cloud service. Oracle Database 12c also includes in-memory data processing capabilities delivering breakthrough analytical performance. Becoming an Oracle Certified Database Expert can expand students database knowledge and give students an edge in a competitive IT marketplace. Oracle Database 12c Associate and Professional Certifications help DBAs develop the full skill set needed to perform day to day administration; get certified to design and implement backup and recovery strategies, while consolidating operations with pluggable and multitenant container databases.

Who Should Attend

  • Database Designers
  • Support Engineer
  • Technical Administrator
  • Database Administrators
  • Data Warehouse Administrator

Course Duration

7 Days / 49.5 Hours

Course Outline


  • Course Objectives/ Course Schedule/ Overview of Oracle Database 12c
  • Overview of Oracle Cloud/ Overview of the HR Schema


Oracle Database 12c Overview

  • Oracle Database 12c Introduction
  • Oracle Database Architecture Overview
  • Oracle Database Instance Configurations
  • Oracle Database Memory Structures
  • Process Structures/ Database Storage Architecture
  • Logical and Physical Database Structures
  • Container and Pluggable Database Overview


Installing Oracle Grid Infrastructure for a Standalone Server

  • Overview of Oracle Grid Infrastructure for a Standalone Server
  • System Requirements for Oracle Grid Infrastructure
  • Configuring Storage for Oracle Automatic Storage Management (ASM)
  • Installing Oracle Grid Infrastructure for a Standalone Server
  • Upgrading Oracle Grid Infrastructure for a Standalone Server


Installing Oracle Database Software

  • Planning Your Installation/ System Requirements for Oracle Database
  • Preparing the Operating System/ Using 4 KB Sector Disks
  • Setting Environment Variables/ Checking the System Requirements
  • Using the Oracle Universal Installer (OUI)
  • Performing a Silent Mode Installation


Creating an Oracle Database by Using DBCA

  • Planning the Database Storage Structure/ Choosing non-CDB or CDB
  • Types of Databases (based on workload)/ Choosing the Appropriate Character Set
  • Understanding How Character Sets are Used
  • Setting the NLS_LANG Initialization Parameter
  • Using the Database Configuration Assistant (DBCA)/ Using Oracle Restart


Oracle Restart Overview

  • Oracle Restart Process startup/ Controlling Oracle Restart
  • Choosing the Correct SRVCTL Utility/ Oracle Restart Configuration
  • Using the SRVCTL Utility/ Obtaining Help for the SRVCTL Utility
  • Starting Components by Using the SRVCTL Utility


Introduction to Upgrading to Oracle Database 12c

  • Upgrade Methods/ Data Migration Methods
  • Supported Releases for Direct Upgrade/ Overview of Upgrade Process
  • Performing a Rolling Upgrade/ Upgrading a CBD


Preparing to Upgrade to Oracle Database 12c

  • Developing a Test Plan/ Performance Testing
  • Requirements for Databases Using Oracle Label Security or Oracle Database Vault
  • Requirement for Databases Using Oracle Warehouse Builder
  • Using the Pre-Upgrade Information Tool/ Backing Up the Database
  • Installing the Oracle Database 12c Software/ Preparing the New Oracle Home


Upgrading to Oracle Database 12c

  • Upgrading by Using the Database Upgrade Assistant (DBUA)
  • Manually Upgrading to Oracle Database 12c/ Migrating a non-CDB to a CDB


Performing Post-Upgrade Tasks

  • Migrating to Unified Auditing
  • Performing Post-Upgrade Tasks Following a Manual Upgrade


Migrating Data by Using Oracle Data Pump

  • Data Pump Overview/ Migrating by Using Data Pump
  • Importing by Using a Network Link



  • Course Objectives/ Course Schedule
  • Overview of Oracle Database 12c
  • Overview of Oracle Cloud/ Overview of the HR Schema


Exploring the Oracle Database Architecture

  • Oracle Database Architecture: Overview
  • Oracle Database Instance Configurations
  • Connecting to the Oracle Database Instance
  • Oracle Database Memory Structures
  • Process Architecture/ Process Structures
  • Process Startup Sequence/ Database Storage Architecture


Managing the Database Instance

  • Introducing Oracle Database Management Tools
  • Understanding the Enterprise Manager Management Framework
  • Logging in to Oracle Enterprise Manager Database Express
  • Using the Enterprise Manager Database Express Home Page
  • Using Enterprise Manager Cloud Control/ Using SQL*Plus
  • Using SQL Developer/ Initialization Parameter Files


Configuring the Oracle Network Environment

  • Oracle Net Services Overview/ Oracle Net Listener Overview
  • Establishing Oracle Network Connections
  • Tools for Configuring and Managing the Oracle Network
  • Using the Listener Control Utility
  • Using Oracle Net Configuration Assistant/ Using Oracle Net Manager
  • Using Enterprise Manager Cloud Control


Managing Database Storage Structures

  • Understanding Storage of Data/ Database Block Contents
  • Exploring the Storage Structure/ Creating a New Tablespace
  • Overview of Tablespaces Created by Default
  • Managing Tablespaces/ Viewing Tablespace Information
  • Using Oracle Managed Files


Administering User Security

  • Database User Accounts/ Predefined Administrative Accounts
  • Creating a User/ Authentication
  • Unlocking a User Account and Resetting the Password
  • Privileges/ Roles/ Profiles


Managing Data Concurrency

  • Overview of Locks/ Locking Mechanism
  • Data Concurrency/ DML Locks
  • Enqueue Mechanism/ Lock Conflicts


Managing Undo Data

  • Undo Data Overview/ Transactions and Undo Data
  • Storing Undo Information
  • Comparing Undo Data and Redo Data/ Managing Undo
  • Configuring Undo Retention
  • Guaranteeing Undo Retention
  • Changing an Undo Tablespace to a Fixed Size


Implementing Oracle Database Auditing

  • Separation of Responsibilities/ Database Security
  • Monitoring for Compliance/ Standard Database Auditing
  • Unified Audit Data Trail
  • Separation for Duties for Audit Administration (AUDIT_ADMIN and AUDIT_VIEWER roles)
  • Configuring the Audit trail/ Specifying Audit Options


Performing Database Maintenance

  • Database Maintenance/ Viewing the Alert History
  • Terminology/ Automatic Workload Repository (AWR)
  • Statistic Levels/ Automatic Database Diagnostic Monitor (ADDM)
  • Advisory Framework/ Enterprise Manager and Advisors


Managing Performance

  • Performance Monitoring/ Tuning Activities
  • Performance Planning/ Instance Tuning
  • Performance Tuning Methodology/ Performance Tuning Data
  • Monitoring Performance/ Managing Memory


Managing Performance: SQL Tuning

  • SQL Tuning/ Oracle Optimizer/ SQL Plan Directives
  • Adaptive Execution Plans/ SQL Advisors/ Automatic SQL Tuning Results
  • Implement Automatic Tuning Recommendations/ SQL Tuning Advisor


Backup and Recovery Configuration

  • Configuring for Recoverability/ Configuring the Fast Recovery Area
  • Multiplexing the Control File/ Online Redo Log File
  • Multiplexing the Online Redo Log File/ Archived Redo Log Files/ Archiver Process
  • Archived Redo Log File Naming and Destinations


Managing Resources by Using Database Resource Manager

  • Database Resource Manager Overview/ Database Resource Manager Concepts
  • Using the Resource Manager/ Default Maintenance Resource Manager Plan
  • Default Plan Example/ Resource Manager Workflow
  • Specifying Resource Plan Directives
  • Resource Allocation Methods for Resource Plans


Automating Tasks by Using Oracle Scheduler

  • Simplifying Management Tasks/ Understanding a Simple Job
  • Core Components/ Basic Work Flow/ Persistent Lightweight Jobs
  • Using a Time-Based or Event-Based Schedule/ Creating a Time-Based Job
  • Creating an Event-Based Schedule


Managing Space

  • Space Management Overview/ Block Space Management
  • Row Chaining and Migration/ Free Space Management Within Segments
  • Types of Segments/ Allocating Extents/ Allocating Space
  • Creating Tables Without Segments


Backup and Recovery Concepts

  • Categories of Failures/ Flashback Technology
  • Understanding Instance Recovery/ Phases of Instance Recovery
  • Tuning Instance Recovery/ Using the MTTR Advisor/ Media Failure
  • Configuring for Recoverability


Moving Data

  • Moving Data: General Architecture
  • Oracle Data Pump/ SQL*Loader/ External Tables


Working with Oracle Support

  • Using the Support Workbench/ Using Enterprise Manager
  • Working with Oracle Support/ My Oracle Support Integration
  • Researching an Issue/ Logging Service Requests
  • Managing Patches/ Applying a Patch Release


Mode of Assessment

Instructor-led Classroom Training with Hands-on Labs Practice.

Students will be required to complete a paper-based NICF assessment during class.

Certification Obtained and Conferred by

Awarded NICF Statement of Attainments (SOAs)

Upon completion of the course, students will also be awarded with these NICF SOAs:

1) IT-DM-303S-1 Identify and resolve common database performance problems

2) IT-DM-409S-1 Install and optimise system software

Course Objectives

After completing this course, students will be able to:

  • Install Oracle Grid Infrastructure for a Standalone Server,
  • Use Oracle Restart to manage components,
  • Upgrade an existing Oracle Database to Oracle Database 12c,
  • Create a container database and provision pluggable databases,
  • 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, and
  • Use the Oracle Support Workbench and My Oracle Support to update your Oracle Database software.



It is required that students have completed the Oracle Database: Introduction to SQL course or possess the following:

  • Working knowledge of SQL and use of PL/SQL packages
  • Basic knowledge of Linux Operating System

Funding Information

  • SSG Funding

This course is aligned to the National Infocomm Competency Framework (NICF) and accredited by SSG with Cat-B Funding (PME Level).


  • Union Training Assistance Programme (UTAP)


NTUC members enjoy UTAP* benefit of up to $250 each year when you sign up for courses with NTUC LearningHub.


* UTAP supports 50% of the course fees paid cap at $250 per year. You must be a union member throughout the course duration and at the time of claim. You must achieve a minimum of 75% attendance for each application and have sat for all prescribed examinations. Other terms and conditions apply.



Course Fee with SSG Cat-B funding


  Individual Sponsored Company Sponsored
  w/o GST w GST Non-SME SME
w/o GST w GST w/o GST w GST
Original Course Fee $7,200.00 $7,704.00 $7,200.00 $7,704.00 $7,200.00 $7,704.00
Singapore Citizens & PRs aged 21 years and above $6,457.50 $6,961.50 $6,457.50 $6,961.50 $4,725.00 $5,229.00
Singapore Citizens aged 40 years and above $4,725.00 $5,229.00 $4,725.00 $5,229.00 $4,725.00 $5,229.00


Individual Sponsored

  • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.
  • NTUC Members can enjoy up to 50% funding (capped at $250 per year) under Union Training Assistance Programme (UTAP).
  • Eligible Singapore Citizens can use their PSEA funds to offset course fee payable after funding.

Company Sponsored

  • Absentee Payroll claimable by SMEs: Up to 80%of hourly basic salary capped at $7.50/hr
  • Absentee Payroll claimable by Non-SMEs: Up to 80% of hourly basic salary capped at $4.50/hr

Terms and conditions apply. NTUC LearningHub reserve the right to make changes or improvements to any of the products described in this document without prior notice.

Prices are subject to other LHUB miscellaneous fees