You might be eligible for up to $90,000. for career training!
Find the School right for you, near you.
Start your search now!


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.



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


– 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)


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


– 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

Student Loans and Grants

Get Notified

  • Learn about new schools and available funding offers.
  • Stay informed on loans and grants as they are available.

Provincial Funding

Looking for student aid options offered by your local province? Choose your province of residence below to check out provincial funding options such as grants, loans, scholarships, and bursaries.