Course Description 

This course is being offered through distance learning. The content and materials offered are the same as that of on-site sections of the course. The presentation of the materials and the specific requirements of the course may be slightly different for on-site and distance learning sections.

This course introduces the students to database technology and the role of databases within an organization.  The main concepts and functions from a Relational Database Management System (RDBMS) are studied.  Structured Query Language (SQL) and PL/SQL (Procedural Language/SQL) are also covered.

Prerequisites

No prerequisites.

Texts/Software 

“OCA/OCP Introduction to Oracle9i SQL Study Guide”, Chip Dawes and Biju Thomas, Sybex. ISBN 0-7821-4062-9.

OR

"Oracle 8i, The Complete Reference", George Koch and Kevin Loney, Osborne/McGraw-Hill. ISBN 0-07-88-2396.

(Note: contact the professor)

Course Outline 

• Theoretical and Physical Aspects of Relational Databases
• Writing simple Queries
• Limiting and Sorting Data
• Single-Row Functions in SQL
• Multiple Table Queries
• Group-Row Functions in SQL
• Single-Row and Multiple-Row Subqueries
• Producing More Readable Output
• Creating and Managing Tables
• Modifying Data
• Modifying Tables
• Creating and Managing Sequences
• Creating and Managing Views
• Creating and Managing Synonyms & Indexes
• Managing User Security