Introduction to Oracle – CSIS 327

CG • Section 8WK • 11/08/2019 to 04/16/2020 • Modified 07/28/2020

Course Description

This course introduces the fundamentals of database design using an Oracle platform. Database administration will be introduced as well as the basic concepts of data manipulation in an Oracle environment. (Formerly BMIS 326)

Prerequisite

BMIS 325 or CSIS 325 or ISYS 325 or CMIS 450

Rationale

Businesses rely upon database management systems to operate successfully in competitive markets. Oracle is an industry leader in the world’s most advanced database management systems. It is essential for students to learn how to use programming languages to access and manipulate data in the foremost database management systems.

Measurable Learning Outcomes

Upon successful completion of this course, the student will be able to:

  1. Describe the structured query language (SQL) fundamentals of Oracle databases.
  2. Manipulate data in an Oracle database using SQL expressions, clauses, operations and functions.
  3. Write advanced SQL sub queries, set operators, sequences, and views to solve business problems.
  4. Use the data manipulation language (DML) and data definition language (DDL) to control databases and tables.
  5. Discuss the relevance of course material and the use of technology to a biblical worldview.

Course Assignment

Textbook readings

Course Requirements Checklist

After reading the Syllabus and Student Expectations, the student will complete the related checklist found in Module/Week 1.

Discussion Board Forums (4)

In Modules/Weeks 1–3 and 6, the student will answer questions in Discussion Board Forums.

Assignments (11)

At the end of each lesson in Modules/Weeks 1–7, the student will be required to answer applicable questions. To answer the questions, the student will need to setup and configure his/her Oracle database and the tables associated with the exercises. Programming code will be written against his/her local database.

Database Project

Throughout each module/week of the course, the student will design and create an Oracle database system. The system must meet a current business need that is appropriate to the learned course content. Upon completion of design and creation, the student will write relevant business reports that allow the business to track key performance indicators. All components will be compiled into one final submission.

Exams (2)

The Midterm Exam will be administered in Module/Week 4 and will assess student comprehension of Oracle eKit material from Lessons 1–6. The Final Exam will be administered in Module/Week 8 and will assess student comprehension of Oracle eKit material from Lessons 7–11.