Skip Navigation
 
 

Schedule of Classes

View Academic Calendar

INFO371 - Relational Databases With Oracle: PL/SQL

 

This course is a study and application of the procedural language overlay on the ANSI standard Structured Query Language (SQL) to enable students to access tuples, one at a time. Knowledge of this complex procedural component will enable students to develop Programming Units that are characterized by block structure, control structures, variables, constants, operators, implicit and explicit cursors, and exception handling (both system- and user-defined). This course examines study and application of procedures, functions, packages, and triggers. Knowledge of procedures, functions, packages, triggers, events, restrictions on triggers, the trigger firing sequence, and the use of triggers to perform auditing functions. This course also covers Object-Relational database concepts and Object Oriented Programming Structures (OOPS) and explores dependencies in Procedures and Functions. Students must have access to Oracle software. This software is not provided by the course material grant and must be purchased/provided by the student. Course software requirements with the appropriate versions are listed under the course materials site. (Prerequisite: INFO171 or equivalent)

 

Prerequisites

Corequisites

N/A

Schedule of Classes

Registration Dates Course Dates Session
07/30/18 - 01/04/19 01/07/19 - 03/03/19 Winter 2019 Session B - 8 Week session
10/29/18 - 03/29/19 04/01/19 - 05/26/19 Spring 2019 Session B - 8 Week session

Course Materials

Previous Syllabi

Book Title: Oracle9i PL/SQL Programming - the VitalSource e-book is provided inside the classroom
ISBN: 9781308237220
Publication Info: McGraw-Hill
Author: Scott Urman
Unit Cost: $112.56
Electronic ISBN: 9781259582974
Electronic Unit Cost: $35.00

Book Title: Oracle Database 12c - Download Oracle from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
ISBN: Software Note
Publication Info: N/A
Author: N/A
Unit Cost: N/A
Electronic ISBN: N/A
Electronic Unit Cost: N/A