2018-2019 San Joaquin Delta College Catalog 
    
    Mar 28, 2024  
2018-2019 San Joaquin Delta College Catalog [ARCHIVED CATALOG]

Add to Favorites (opens a new window)

CSP 043B Oracle: PL/SQL Programming


Units: 3
Prerequisites: CSP 043A Database Design and Implementation Using Oracle  with a minimum 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)