Skip Navigation
 

INFO171 - Relational Databases with Oracle: SQL Introduction

Course Details

Course Code: INFO171 Course ID: 4450 Credit Hours: 3 Level: Undergraduate

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.





Course Schedule

Registration Dates Course Dates Session Weeks
11/26/18 - 05/03/19 05/06/19 - 06/30/19 Spring 2019 Session I 8 Week session
02/25/19 - 08/02/19 08/05/19 - 09/29/19 Summer 2019 Session I 8 Week session

Current Syllabi

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

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

  1. Describe the role of databases and database applications
  2. Apply data modeling techniques using the entity-relationship model (ERM)
  3. Analyze the Extended ER Model and normalization in database designs
  4. Interpret the functions of Oracle Database
  5. Integrate SQL syntax in Database application
  6. Identify the difference between DML,DDL and TCL query statements
  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.

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.

There is a Final Exit Exam (non-proctored, open-notes) based on Final Assignment, Final Lab and Final Quiz. This Final Exit Exam will be based on Week 1 through Week 6 Activities

NameGrade %
Final Assignment & Lab 24.00 %
Week 8: Final Lab 12.00 %
Week 8: Final Assignment 12.00 %
Weekly Assignments[5-7] 18.00 %
Week 5: Assignment 5 6.00 %
Week 6: Assignment 6 6.00 %
Week 7: Assignment 7 6.00 %
Weekly Lab Work[5-7] 18.00 %
Week 5: Lab 5 6.00 %
Week 6: Lab 6 6.00 %
Week 7: Lab 7 6.00 %
Weekly Lab Work[1-4] 16.00 %
Week 2: Lab 2 4.00 %
Week 3: Lab 3 4.00 %
Week 4: Lab 4 4.00 %
Week 1: Lab 1 4.00 %
Weekly Assignments[1-4] 16.00 %
Week 2 : Assignment 2 4.00 %
Week 3: Assignment 3 4.00 %
Week 1 : Assignment 1 4.00 %
Week 4: Assignment 4 4.00 %
Weekly Forum 8.00 %
Week 1 Forum 2.00 %
Week 3 Forum 2.00 %
Week 5 Forum 2.00 %
Week 7 Forum 2.00 %
Book Title: Database Systems: Design, Implementation, & Management, 11th Ed - The VitalSource e-book is provided via the APUS Bookstore
Author: Coronel/Morris
Publication Info: Cengage
ISBN: 9781285196145
Book Title: Oracle Database 12c - Download Oracle from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
Author:
Publication Info:
ISBN: Software Note
Book Title: You must validate your cart to get access to your VitalSource e-book(s). If needed, instructions are available here - http://apus.libguides.com/bookstore/undergraduate
Author: N/A
Publication Info: N/A
ISBN: N/A

Book Title:Oracle Database 12c - Download Oracle from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
ISBN:Software Note
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

Previous Syllabi

Not current for future courses.