0 or 3 credits
Fall 2025 Laboratory Lecture Distance Learning Upper Division
This course explores advanced database programming techniques for enterprise-wide databases and their implementation. It uses programmatic extensions to Structured Query Language (SQL) supported by today's enterprise-class Relational Database Management Systems (RDBMS). Topics include advanced data manipulation, storage considerations, data transformation techniques to enhance interoperability of data, stored procedure and trigger design and implementation, and query optimization.
Learning Outcomes1Deconstruct and explain database management system concepts and workable alternatives for contemporary database implementations.
2Translate how triggers, procedures, and functions form the basis of methods that can be used to implement object-oriented capabilities in a relational database environment.
3Analyze and improve declarative integrity constraints and security concerns in database implementation.
4Design and apply triggers, procedures, and constraints for a given database model.
Prerequisites
Restrictions
made by Purdue students.