CP4411 - SQL Using Oracle

This course is intended to illustrate how to develop and query databases and how to develop database programs using Oracle. This course also illustrates how to create, populate, and modify database tables. It illustrates how to create triggers, procedures and functions using PL/SQL programming constructs. Database administration functions, such as the data dictionary querying, and creating users, roles and privileges, and granting, revoking and denying are also included.


Prerequisite(s): CP3410



This course is offered in the following programs:
Programmer Analyst (Business) Co-op