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.

Credits

4

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:
Write programs that will manipulate databases to create, modify, and retrieve data and information using PL SQL.