Oracle 12c Non-Certification Data Base Administration


Course Description

In this course, you’ll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Hands-on exercises reinforce the material covered.

Audience Profile

  • Database administrators
  • Support engineers
  • Technical consultants
  • Systems administrators
  • Network managers
  • Technical support personnel


  • Knowledge of SQL
  • Oracle 12c SQL & SQLPLUS Express Introduction
  • Oracle 12c PL/SQL Introduction

Learning Objectives

  • Install and configure the Oracle 12c database
  • Create and administer user accounts in the Oracle 12c database
  • Backup and recover the database
  • Monitor, troubleshoot, and maintain the database
  • Configure Oracle Net services

Course Outline

Course Outline

Module 1: Introduction
• Describe the Basic Concepts of a Relational Database
• Discuss Core Database Administrator Tasks

Module 2: Installing Oracle Database Software
• Identify System Requirements
• Use Optimal Flexible Architecture
• Install Software with the Oracle Universal Installer

Module 3: Create an Oracle Database
• Describe Oracle Database Architecture
• Understand the Instance Architecture
• Use the Management Framework and the Database Creation Assistant
Lab: Architecture / Advanced Memory Mgt.

Module 4: Controlling the Database
• Start and Stop the Listener
• Startup and Shutdown the Database
Lab: Starting and Stopping the Database
Lab: Using the Database Console (EM)

Module 5: Storage Structures
• Define the Purpose of Tablespaces and Data Files
• Create and Manage Tablespaces
• Obtain Tablespace Information
Lab: Managing Tablespaces / Datafiles
Lab: Oracle Database Files
Lab: Tables, Indexes, and Constraints

Module 6: Administering Users
• Create and Manage Database User Accounts
• Manage Roles
• Grant and Revoke Privileges
• Control Resource Usage by Users
• Control Password History
Lab: Creating Other Database Objects
Lab: Users and Security

Module 7: Managing Schema Objects
• Create and Modify Tables, Indexes, and Views
• Define Constraints
• View the Attributes and the Contents of a Table

Module 8: Managing Data
• Manipulating Data through SQL
• Use Import, Export, Data Pump, and SQL Loader
Lab: Import, Export, Data Pump, and SQLDR

Module 9: Oracle Database Security
• Manage Default User Accounts
• Implement Standard Password Security Features
• Audit Database Activity
Lab: Performance Metrics and Monitoring

Module 10: Oracle Net Services
• Understand Oracle Net Concepts
• Use Oracle Net Manager to Create and Configure Listeners
• Configure Client and Middle-Tier Connection
• Use the Listener Control Utility to Control the Oracle Net Listener
• Secure the Listener
• Use TNSPING to Test Oracle Net Connectivity
Lab: Archivelog Setup

Module 11: Proactive Maintenance: Objectives
• Set Warning and Critical Alert Thresholds
• Collect and Use Baseline Metrics
• Use Tuning/Diagnostic Advisors/ADDM/ADR
Lab: Automation Tools

Module 12: Undo Management
• Monitor and Administer Undo
• Configure and Guarantee Retention

Module 13: Recovery Manager Configuration
• Parameters Affecting RMAN
• Use of a Flashback Recovery Area
• The CONFIGURE Command
• Persistent Settings
• Channel Allocation
• Controlfile Autobackup
• Retention Policies
Lab: Recovery Manager Configuration

Module 14: Recovery Manager Operations
• Using the BACKUP Command
• Creating Backup Sets / Image Copies
• Compressed Backups
• Incremental Backups
• Block Change Tracking
• RMAN Backup Monitoring
• REPORT and LIST Commands
Lab: Recovery Manager Backups

Module 15: Non-Critical Loss Recovery
• Password and Network Files
• Read-Only Tablespaces
• Temporary Tablespaces
• Index Tablespaces
• Redo Log Members / Control Files

Module 16: Database Recovery
• Complete Recovery
• Incomplete Recovery

Module 17: Flashback Database
• Configuration
• Monitoring Flashback Database
Lab: Flashback Database

Module 18: User Error Recovery
• Flashback Table
• Flashback Versions Query
• Flashback Transaction Query
Lab: Flashback for User Errors

Module 19: Automatic Database Management
• Management and Advisory Framework
• Automatic Statistics Collection
• The Automated Workload Repository
• Database Advisors
• Automatic Statistics Collection
Lab: Automated Management Tools

Module 20: Scheduler
• Creating Jobs and Job Classes
• Creating Schedules and Windows
• Create Scheduler Programs
• Prioritizing Jobs
• Query Scheduler Information
• Working with Calendaring tools
Lab: Using the Scheduler
Lab: Diagnostic Sources

Register for Course

Available Registrations: Unlimited
The Tuition ticket is sold out. You can try another ticket or another date.



Course Code


Course Duration


Instructions Method

Instructor Led