Skip Navigation
 

INFO271 - Relational Databases with Oracle: SQL Intermediate

Course Details

Course Code: INFO271 Course ID: 2629 Credit Hours: 3 Level: Undergraduate

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

Course Schedule

Registration Dates Course Dates Session Weeks
06/24/19 - 11/29/19 12/02/19 - 01/26/20 Fall 2019 Session D 8 Week session
09/30/19 - 02/28/20 03/02/20 - 04/26/20 Winter 2020 Session D 8 Week session

Current Syllabi

At the conclusion of the course, participants should be able to:

  1. Describe the role of databases and database applications by using SQL
  2. Apply SQL JOIN, Relational Set operators, triggers and store procedures
  3. Analyze the database optimization techniques and locking database in transaction control environment
  4. Interpret the knowledge of the database sequences, views and update views
  5. Identify the benefits of distributed database management systems by applying SQL-code
  1. Detailed instructions for weekly assignments are found in Appendix A.
  2. Refer to the e-classroom instructions (Appendix B) to find out how to upload assignments, participate in online Discussion Board discussions, and take exams.
  3. Evaluation Criteria:

Submit all assignments & Labs (except Discussion Board answers and Quizzes) in Assignments section

Assignment Requirements

Discussion Board Introduction

You are required to introduce yourself to your classmates in an online discussion. Additional discussion board topics may be added to clarify issues.

Competency

You will be required to complete assigned work and upload them in Assignments.

NameGrade %
Assignments[Week 1- 5] 60.00 %
Week 1: Assignment 1 and Lab Project 1 12.00 %
Week 2: Assignment 2 and Lab Project 2 12.00 %
Week 3: Assignment 3 and Lab Project 3 12.00 %
Week 4: Assignment 4 and Lab Project 4 12.00 %
Week 5: Assignment 5 and Lab Project 5 12.00 %
Weekly Forums 8.00 %
Week 1 Forum 2.00 %
Week 3 Forum 2.00 %
Week 5 Forum 2.00 %
Week 7 Forum 2.00 %
Assignments[Week 6 & 7] 16.00 %
Week 6: Assignment 6 and Lab Project 6 8.00 %
Week 7: Assignment 7 and Lab Project 7 8.00 %
Assignment[Week 8] 16.00 %
Week 8: Assignment 8 and Lab Project 8 16.00 %

Book Title: Database Systems: Design, Implementation, and Management, 10th Edition

Author: Carlos Coronel, Steven Morris, Peter Rob

Publication Info: Course Technology @ 2013

ISBN-10: 1111969604,

ISBN-13: 9781111969608

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

Previous Syllabi

Not current for future courses.