2015-2016 University Catalog 
  
2015-2016 University Catalog

IT 314 - Database Programming

Credits: 3
Limited to 2 Attempts
The course introduces students to the Oracle Developer application development utilities and tools and describes how to create and manipulate databases in Oracle database management system. The course provides an extensive overview of SQL and introduction to PL/SQL. Topics include data definition and manipulation languages, stored procedures, triggers, indexing techniques, and elementary query optimization.

Prerequisite(s): (IT 106 or IT 196 or CS 112) and (IT 214 or IT 194). Prerequisite enforced by registration system.

Hours of Lecture or Seminar per week: 3
Hours of Lab or Studio per week: 0