This course is designed for students who have the desire to work as a Database Administrators in any organization.

 

Candidates must possess JHS / SHS, Technical / Vocational, O’ level or its   equipment and any professional certificate.

 

COURSE CONTENTS/MODULES

 Database Administration

Course Objective:

 Database: Introduction to SQL NEW:

  • Identify the major structural components of the Oracle Database
  • 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
  • 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
     Database  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
  • 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 table space point-in-time recovery.
  • Describe additional high availability features such as Oracle Data Guard