Advanced Oracle – CSIS 328

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

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)

For information regarding prerequisites for this course, please refer to the Academic Course Catalog.

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.

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.