LATEST NEWS UPDATES

News Release : NIIT organizes workshop on Artificial Intelligence            News Release : Graduation Class 2017 - NIIT Accra            News Release : NIIT Tema offers scholarship to SHS students - 2017            News Release : NIIT Tema Digital Art Festival January 2017            News Release : NIIT Tamale holds ICT Drawing Competition            

Programmes

Certificate Programs: Database Administration

Oracle 12C Database Administration

DATABASE ADMINISTRATION / ORACLE 12C DATABASE ADMINISTRATION

INTRODUCTION

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

 

PREREQUISTES

  • 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

 

AUDIENCE PROFILE
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.

 

INTERNATIONAL CERTIFICATION EXAMS
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

 

COURSE CONTENTS/MODULES

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



CAN'T FIND WHAT YOU'RE LOOKING FOR?

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

Connect with Us