CSC 530 Advanced Database

This class will expand on knowledge of SQL and teach students how to develop Oracle procedures and functions using PL/SQL. It will be appropriate for students seeking PL/SQL knowledge to solve simple business questions, or do maintenance on systems involving PL/SQL procedures. The course topics will include: basic syntax, variables and data types, cursors, creating procedures/functions, creating triggers, debugging, exception handling, dynamic SQL, intersession communication, external procedures, object types, and web application development. In addition, the class will discuss XML, including validation using schema and DTD, and constructing xslt files to convert XML files into HTML.

Credits

3