Qualify for Special Funding

ORACLE DATABASE DEVELOPER

Graduates will have acquired extensive programming experience in such areas and environments as relational database management theory and Oracle on a Windows Platform. Students are immersed into the wide spectrum of data access and manipulation with respect to the relational model as databases are exploited internally and externally. The Oracle Developer course is designed to blend academic instruction and hands on practice with real work experience. Regular tests, based on the Oracle Certified Professional (O. C. P.) tests, prepare students who may wish to take the O.C.P. Application Developer exams later. Day timing: Monday to Friday - 9 a.m. to 1p.m. Duration is five (5) weeks. Evening timing: Monday, Wednesday, Friday - 6 p.m. to 9 p.m. Duration is twelve (12) weeks.

COURSE OUTLINE

DATABASE CONCEPTS

- Data processing basics - Dbms – database management system - Erm – entity-relationship model - Rdm - relational data model - Normalization - Manipulating tables

SQL

- SQL basic/’data dictionary’ - SQL statement coding rules… - Data control language – Commit, Rollback, Savepoint … - Data definition language (DDL) - Tables/create, drop, alter,…, constraints… - Views - creation and using - Sequences - creation and using - Data manipulation language (DML) /IUD – insert, update and delete - Retrieving data/ select statement, where, order by, group by, having clause, operators/ - Expressions, functions – single row and group functions - Subqueries, correlated subqueries, using by subqueries - Joins (self join, outer join, equijoin, non-equijoin) - Optimization /indexes and clusters - Advanced SQL (SET operators, EXISTS operator)

SQL*PLUS

- Reports with SQL*PLUS - Substitution variables - Scripts in SQL*Plus

PL/SQL

- Overview - Fundamentals /Blocks, Variables, Constants, Attributes, Datatype - Control Structures / If…, For… Loop, … - Cursors - Transaction Control /Commit, Rollback, Savepoint - Subprograms /Procedures, Functions (stored and client) - Procedures - Packages - Triggers - Error Handling - SQL Developer

Search Schools

Not Sure Where to Start?

Choosing a school or program can feel overwhelming, especially when funding details, eligibility, and timelines may depend on your personal situation.

A good first step is to identify the type of training you’re interested in, then connect with schools that can explain program options, admissions steps, and available support.

Use the search tool to begin narrowing your options based on your goals.

* All student funding, whether made available privately or through various government branches, is only approved to those who qualify, by the original source of funding. There are many criteria that each candidate must meet to be approved. Schools can only inform you of what may be available.