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
09/24/18 - 03/01/19 |
03/04/19 - 04/28/19 |
Winter 2019 Session D - 8 Week session |
12/31/18 - 05/31/19 |
06/03/19 - 07/28/19 |
Spring 2019 Session D - 8 Week session |
Course Materials
Previous Syllabi |
Download Archived Course Syllabi here Not current for future courses |
| |
Book Title: |
Database Systems: Design, Implementation, & Management, 11th Ed - the VitalSource e-book is provided inside the classroom
|
ISBN: |
9781285196145
|
Publication Info: |
VS-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
|
|