2019-2020 San Joaquin Delta College Catalog 
    
    Nov 27, 2020  
2019-2020 San Joaquin Delta College Catalog [ARCHIVED CATALOG]

Add to Favorites (opens a new window)

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)



Add to Favorites (opens a new window)