IST483 Sp: Advanced Database Programming

Syllabus
  1. Sequences in Oracle.
  2. PL/SQL Basics.
  3. Control statements.
  4. Composite types: Records and Arrays.
  5. Using SQL in PL/SQL.
  6. Transaction control.
  7. Creating procedures and functions.
  8. Error handling.
  9. Cursor.
  10. Dynamic SQL.
  11. Triggers.
  12. Collections.
  13. Collections in the database.
  14. Packages.
  15. Subprogram dependencies and privileges.

Projects:

  1. Project 1: Create tables, comment tables, create sequences for IDs.
  2. Project 2: Create stored procedures.
  3. Project 3: Triggers to implement additional features.

Homework assignments:

  1. SQL functions.