Advanced Oracle – CSIS 328

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

Course Description

This course introduces the advanced topics of database administration in Oracle. Multi-dimensional databases for Business Intelligence applications will be examined as well. (Formerly BMIS 327)

Prerequisite

BMIS 326 or CSIS 327

Rationale

Businesses rely upon database management systems to operate successfully in competitive markets. Oracle Corporation is a global leader and provider of database systems. Students should gain a basic knowledge of creating and administering Oracle database systems.

Measurable Learning Outcomes

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

  1. Discuss the relevance of course material and integration of technology to a Biblical worldview.
  2. Describe Oracle database architecture.
  3. Build an Oracle database.
  4. Administer an Oracle database.
  5. Configure an Oracle database for an application.
  6. Control Oracle database access.
  7. Construct Oracle database backups and recoveries.

Course Assignment

Resource 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)

There will be 4 Discussion Board Forums throughout this course. The student is required to provide a thread in response to the provided topic for each forum.

Oracle Database Assignment (9)

The student will be required to complete applicable assignments to database administration. The student will install, create, administer, and configure an Oracle database for applications. Assignments will require complete programming code, server scripts, and applicable screenshots of the database server running on the student’s machine.

Midterm Exam

The Midterm Exam will be open-book/open-notes, contain 50 multiple-choice questions.

Final Exam

The Final Exam will be open-book/open-notes, contain 50 multiple-choice questions, and have a 60-minute time limit. The final exam will assess students on lessons 9–18 in the Oracle eKit curriculum. The exam will be due in Module/Week 8.