Full program description

NICF - Oracle Database 12c Administrator Certified Associate

What's In It For Me

  • 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-0027856-IT

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 Hours

Course Outline

Introduction

  • 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

Introduction

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

Pre-requisites

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


  • UTAP Funding

NTUC Union Members can enjoy up to 50% funding (capped at $250 per year) with Union Training Assistance Programme (UTAP). 

Price

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

$7,736.10

$7,230.00

$7,736.10

$7,230.00

$7,736.10

Singapore Citizens & PRs aged 21 years and above

$6,630.00

$7,136.10

$6,630.00

$7,136.10

$5,230.00

$5,736.10

Singapore Citizens aged 40 years and above

$5,230.00

$5,736.10

$5,230.00

$5,736.10

$5,230.00

$5,736.10

Singapore Citizens aged 35 years and above who are not earning more than $2,000 per month (WTS Scheme)

$361.50

$867.60

$361.50

$867.60

$361.50

$867.60

Remarks:

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

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
  • Absentee payroll claimable by companies (SMEs and Non-SMEs) sponsoring candidates under WTS Scheme: Up to 95% of hourly basic salary (no dollar cap)

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

NICF010