pexels-photo-461077.jpeg 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

 

Modules

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
Collections
Queries (Basic and Advanced including subqueries and operators)
Handling Large Dataset
Handing Dates and Date Functions
Data Dictionary

 

FEES

GHC 950.00

Registration fee: GHC 80.00