Course Outline:

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.

Reasoning:

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. Look over my recommended prerequisite courses at Liberty University if you need help deciding.

Measurable Learning Results:

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

1. 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 Homework Description:

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 for 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, containing 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.