Skip Navigation
 
 

Schedule of Classes

View Academic Calendar

INFO171 - Relational Databases with Oracle: SQL Introduction

 

This course is a study of data modeling and database design. It applies the relational database model to construct Entity Relationship (ER) diagrams using ER Modeling. Through a study and application of the American National Standards Institute (ANSI) Standard Structured Query Language (SQL) constructs the course introduces data definition (create, alter, drop), data manipulation (insert, update, delete), and transaction control (commit, savepoint, and rollback), and defining, altering, and deleting primary keys, foreign keys, and constraints. 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.

 

Prerequisites

N/A

Corequisites

N/A

Schedule of Classes

Registration Dates Course Dates Session
05/28/18 - 11/02/18 11/05/18 - 12/30/18 Fall 2018 Session I - 8 Week session
08/27/18 - 02/01/19 02/04/19 - 03/31/19 Winter 2019 Session I - 8 Week session

Course Materials

Previous Syllabi

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

Book Title: Database Systems: Design, Implementation, & Management, 11th Ed - the VitalSource e-book is provided inside the classroom
ISBN: 9781285196145
Publication Info: Cengage
Author: Coronel/Morris
Unit Cost: $219.71
Electronic ISBN: 9781305217164
Electronic Unit Cost: $35.00