Oracle Database


Course Overview

This course is a hands-on training designed to provide students with an in-depth knowledge of Oracle programming and knowledge of Oracle Server administration. The course assumes the students have little or no programming experience and therefore teaches how to program with the PL/SQL to automate and extend the capabilities of Oracle Database server.


Learning Objectives

At the end of the course, the participants will acquire the skills for:
Developing optimized SQL queries to access Oracle database
Analysis and fine tuning techniques to increase performance of SQL queries
Managing and handling large data sets and warehouse
Creating re-usable stored procedures, functions, packages and triggers with code maintenance
Invoking native dynamic SQL to develop high-level abstract code
Performing Oracle server administration tasks



SQL Fundamentals
Overview of database concepts including Entity Relation
Data Definition Languages / Creating and Maintaining Database Objects (i.e. synonym, views, tables, sequence, index, objects etc)
Data Manipulation Languages
Queries (Basic and Advanced including subqueries and operators)
Handling Large Dataset
Handing Dates and Date Functions
Data Dictionary


Registration Fees: GHC 80.00

Course Fees: GHC 950.00