Database Programming: Oracle PL/SQL

This course builds on skills learned in ICT 4405 Database Design and Programming. Students will transform a database schema design into a database application using Oracle's PL/SQL programming language. Topics include advanced SQL DDL, DML, and scripting, PL/SQL constructs, stored procedures, modular design and development (packages), software development processes, views, sequences, cursors, dynamic SQL, and error handling. Using weekly assignments, students will practice different aspects of design and development of database applications. Prerequisite: ICT 4405 or SQL experience.