|
|
|
Apr 19, 2024
|
|
CIS 254 - Database Procedures and Functions
5.0 Credits
Students learn to create functions using procedural programming languages, store functions, and call functions. Includes creating, using, modifying stored procedures and functions within a RDBMS. Students learn control structures of a database programming language. Prerequisite
CIS 251 with minimum grade of 2.5. Corequisite
Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:
- Explain the concept of a scalable relational database management system RDBMS.
- Explain the difference between client/server RDBMS and client RDBMS.
- Explain the uses of networked RDBMS.
- Explain and use data manipulation language (DML) within procedures and functions.
- Make use of save points and roll back within procedural programming.
- Use of conditional control within procedures and functions (if statements).
- Create exceptions and errors within DML and handle them within procedural programming.
- Understand the use of and create iterative control structures within procedural programming (loops).
- Create record sets through the use of SQL and procedural programming.
- Develop and use stored procedures and functions.
- Use the advanced features of stored procedural programming.
Add to Personal Catalog (opens a new window)
|
|
|
