|
|
|
Apr 24, 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.
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. [COMMUNICATE]
- Explain the difference between client/server RDBMS and client RDBMS. [REASON]
- Explain the uses of networked RDBMS. [COMMUNICATE]
- Explain and use data manipulation language (DML) within procedures and functions. [REASON]
- Make use of save points and roll back within procedural programming. [REASON]
- Use of conditional control within procedures and functions (if statements). [REASON]
- Create exceptions and errors within DML and handle them within procedural programming. [REASON]
- Understand the use of and create iterative control structures within procedural programming (loops). [REASON]
- Create record sets through the use of SQL and procedural programming. [REASON]
- Develop and use stored procedures and functions. [REASON]
- Use the advanced features of stored procedural programming. [REASON]
Add to Personal Catalog (opens a new window)
|
|
|
