ICT 4451 - DB Programming: Oracle PL/SQL
This course builds on ICT 4405 Database Design and Programming, allowing students to transform a database schema design into a database application prototype using Oracle's PL/SQL. Topics include advanced SQL DDL, DML, and scripting, PL/SQL constructs, stored procedures, modular design and development, software development processes, views, sequences, cursors, dynamic SQL, error handling, locking, as well as performance and tuning, and database security. Using virtual E-Labs, students design and develop a database and related PL/SQL applications. Prerequisites: ICT 4300, ICT 4405.
NOTE: This course is not offered this term. Please refer to the annual schedule for Information And Communications Technology to see the next time this course is offered.