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
Get Notified
- Learn about new schools and available funding offers.
- Stay informed on loans and grants as they are available.