CS 276 Database Systems: PL/SQL
Fundamentals of the programming procedural language extension to SQL. Areas of concentration include: PL/SQL structures, Boolean logic, stored procedures, functions and packages, blocks and nested blocks, triggers and error checking. Students will design and construct a database, then write programs in the procedural code (PL) to manipulate the data in an efficient, results oriented manner.
Prerequisite
Prerequisite: CS 275 Database Systems: SQL and Oracle with a grade of C or better.
Offered
Offered Spring only
Notes
Lower Division Transfer (LDT) Course
General Education Requirements
AGS Math/Science,
Outcomes
Upon successful completion of this course, students will be able to:
Manipulate database tables using PL/SQL program units. Identify and use appropriate programming constructs to fulfill application logic requirements. Write PL/SQL program units that include procedures, functions, triggers, packages, and error trapping facilities. Identify and use user-defined classes and objects.