2011-2012 Catalog 
    
    Mar 28, 2024  
2011-2012 Catalog [ARCHIVED CATALOG]

Add to Personal Catalog (opens a new window)

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 a minimum grade of 3.0.

Course Objectives
Upon successful completion of this course, students will be able to:

  1. Explain the concept of a scalable relational database management system RDBMS. [COMMUNICATE]
  2. Explain the difference between client/server RDBMS and client RDBMS. [REASON]
  3. Explain the uses of networked RDBMS. [COMMUNICATE]
  4. Explain and use data manipulation language (DML) within procedures and functions. [REASON]
  5. Make use of save points and roll back within procedural programming. [REASON]
  6. Use of conditional control within procedures and functions (if statements). [REASON]
  7. Create exceptions and errors within DML and handle them within procedural programming. [REASON]
  8. Understand the use of and create iterative control structures within procedural programming (loops). [REASON]
  9. Create record sets through the use of SQL and procedural programming. [REASON]
  10. Develop and use stored procedures and functions. [REASON]
  11. Use the advanced features of stored procedural programming. [REASON]



Add to Personal Catalog (opens a new window)