Oracle Data Base

GI-KACE > Courses > Professional courses > Oracle Data Base
Categories:

COURSE DESCRIPTION

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.

COURSE OBJECTIVE

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

COURSE 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

 

TARGET GROUP

  • SHS Graduates
  • Database Administrators
  • Data Analysts
  • Persons with passion or interest in data administration

CAREER PROSPECTS

  • Data Warehouse Administrator
  • Database Administrator
  • Database Designer
  • Support Engineer
  • Technical Administrator

COURSE PRE-REQUISITE

  • Minimum of SHS certificate

 

 

Related Courses

Certificate in Data Analytics Using PowerBI and MS SQL Server

COURSE DESCRIPTION  This is a hands-on training designed to provide participants with an in-depth knowledge in data analytics with database, spreadsheet and power Bi. The certificate in data analytics course is aimed at individuals who wish to develop their understanding of data, and the skills and techniques available for data…

Certified Information System Auditor (CISA)

COURSE DESCRIPTION CISA is an internationally recognised certification that serves as the benchmark of achievement for working professionals who audit, control, monitor and assess the organisation’s IT and business systems. The skills and practices that CISA programme promotes and evaluates are the building blocks of success in the field. Earning…

Cisco Certified Network Association(CCNA)

COURSE DESCRIPTION  As networking capabilities continue to grow and expand, corporations, nonprofits, schools, hospitals, governments, and NGOs around the world are experiencing a shortage of qualified information and communication technology (ICT) specialists to design, install, secure, and manage their networks. Every year, hundreds of thousands of Networking Academy students worldwide…

Certificate in Cyber Attacks and preventive Techniques

COURSE DESCRIPTION This course will provide a participant with a specialized real-time skills and competences in safeguarding IT infrastructures against the threat of cybercrime to meet the expectations of an organization. The increased internet penetration has given exponential rise in sophisticated attacks on Information Technology (IT) infrastructure and attackers are…
slot gacor slot gacor