INFO 2640 - Oracle SQL and Programming

4.5 Credits

Students gain skills to access and manipulate data in the Oracle database management system. Topics include basic through advanced level SQL commands and PL/SQL procedural commands. Students create blocks of code using scalar and composite variables and cursors; create procedures using control and loop structures; learn exception-handling techniques; and create functions, packages, and triggers.

Prerequisites: (1) INFO 1620

Recommended: INFO 2630

Lecture Hours: 4.5
Lab Hours: 0.0
Internship Hours: 0.0
Clinical or Practicum Hours: 0.0

Course Objectives

Define the relational database model.
Recognize database supporting software.
Use SQL statements for data definition and manipulation.
Test SQL functions to manipulate data.
Support database security with industry practices.
Develop code with a SQL procedural extension.

View Class Schedule