Watch the 2019 Convocation Ceremonies

Advanced SQL and PL/SQL

Course Code COMP-204
Lecture hours per week
Lab hours per week
Course Availability: Open

This course includes SQL and SQL*Plus statements to query and display data from an Oracle database, SQL and SQL*Plus syntax and command structure, group and sort operations to the data and SQL*Plus commands to format reports to control the user’s environment. You will edit and execute script files to retrieve data and generate reports and modularize application development using database-level programming (PL/SQL), constructs such as stored procedures and functions as well as packages and database triggers. Prerequisite: COMP-121 or by permission of the department Corequisite: COMP-203