Skip Navigation
 
 

Schedule of Classes

View Academic Calendar

INFO271 - Relational Databases with Oracle: SQL Intermediate

 

This course is a study and application of the American National Standards Institute (ANSI) Standard Structured Query Language (SQL) constructs for an advanced level of data definition (create, alter, drop), data manipulation (insert, update, delete), and transaction control (commit, savepoint, and rollback). The course builds on the techniques learned in the introductory course for database design and implementation. It explores the database life cycle through conceptual, logical, and physical design phases. The course examines the correlation between SQL and relational algebra; user access and control; transactional integrity; referential integrity; concurrency control; and database objects such as views, complex views, SQL functions, and sequences. Advanced topics discussed in the course include: database performance tuning, query optimization, distributed database systems, business intelligence, data analytics, data warehousing, cloud computing services, and the administration of database systems. 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
09/24/18 - 03/01/19 03/04/19 - 04/28/19 Winter 2019 Session D - 8 Week session

Course Materials

Previous Syllabi

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

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