Certificate Programs: Database Administration

Oracle 12C Database Administration



Over 30 years, Oracle remains the gold standard for database technology and applications in enterprises throughout the world:

  • Oracle Database is the number one database in the world.
  • Over 305,000 top companies trust their critical systems to Oracle Database.
  • Oracle Database is the number one embedded database technology.

The company is the world's leading supplier of software for information management, and the world's second largest independent software company. Oracle technology can be found in nearly every industry, and in the data centers of 100 of the Fortune Global 100 companies.

With the 12c release, Oracle Database is re-engineered for Cloud computing. Multi-tenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c certifications emphasize the full set of skills that DBAs need in today's competitive marketplace



  • Recognize the main components of a PC and different data media such as floppy disks and CD-ROMs
  • Knowledge of basic functions of an operating system
  • Basic knowledge of Linux operating system
  • Working knowledge of SQL and use of PL/SQL packages
  • knowledge of Oracle Database 11g


This certificate program is meant for those who want to master Database administration on the leading Database technology in the world. It is also meant for those who wish to migrate from earlier version of Oracle Databases like 11g to the latest technology.


Oracle Database 12c Certified Associate
Oracle Database 12c: Introduction to SQL NEW
Oracle Database 12c: Admin, Install and Upgrade Accelerated
Oracle Database 12c Certified Professional
Oracle Database 12c: Backup and Recovery Workshop



Oracle 12c Database Administration

Course Objective:

Oracle Database: Introduction to SQL NEW:

  • Identify the major structural components of the Oracle Database 12c
  • Create reports of aggregated data
  • Write SELECT statements that include queries
  • Retrieve row and column data from tables
  • Run data manipulation statements (DML) in Oracle Database 12c
  • Create tables to store data
  • Utilize views to display data
  • Control database access to specific objects
  • Manage schema objects
  • Display data from multiple tables using the ANSI SQL 99 JOIN syntax
  • Manage objects with data dictionary views
  • Write multiple-column sub-queries
  • Employ SQL functions to retrieve customized data
  • Use scalar and correlated sub-queries
  • Create reports of sorted and restricted data

Oracle Database 12c: Admin, Install and Upgrade Accelerated NEW

  • Use Oracle Restart to manage components
  • Upgrade database to Oracle Database 12c
  • Install Oracle Grid Infrastructure for a Standalone Server
  • Create a container database
  • Create an Oracle Database
  • Install Oracle Database 12c software
  • 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
  • Manage Oracle Database Storage structures

Oracle Database 12c: Backup and Recovery Workshop NEW

Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure.
  • Describe the Oracle Database architecture components related to backup and recovery operations.
  • Plan effective backup and recovery procedures.
  • Configure the database for recoverability.
  • Use Recovery Manager (RMAN) to create backups and perform recovery operations.
  • Use the Data Recovery Advisor to diagnose and repair failures.
  • Use Oracle Flashback Technologies to recover from human error.
  • Perform an encrypted database backup and restore.
  • Perform tablespace point-in-time recovery.
  • Describe additional high availability features such as Oracle Data Guard


Try our extensive database of FAQs or submit your own question...

Connect with Us