CSP 43B Oracle: PL/SQL Programming

Units: 3
Prerequisites: CSP 43A Database Design and Implementation Using Oracle with a grade of “C” or better.
This course is an introduction to Procedural Language (PL), which is an extension of Structured Query Language (SQL) studied in CSP 043A. Students will learn procedural logic constructs such as variables, constants, conditional statements and iterative controls, PL/SQL block structure, PL/SQL packages, dynamic SQL, and database triggers that are used to execute code automatically. Advanced data types, such as user-defined record types and multi-media file types, will also be addressed. In addition, students will learn how to manage object dependencies. The Oracle Application Express, which is a browser-based development environment, will be used for writing PL/SQL code. (CSU)