CSB 3328 (LUOA), CSIS 328 (LUO): Advanced Oracle
11/08/2019 to 04/16/2020 • Modified 08/08/2024
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)
LUOA Equivalent Course*
- CSB 3328: Advanced Oracle, 3 LUO credits.
Program Restrictions*
- DPL: Dual Enrollment – Certificate in Database (DUCD-DPL-D)
Prerequisite Requirements*
CSB 3327 previously completed with a minimum grade of D.
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.
*Course specifics are tentative and subject to change each year. For the most current information, please refer to the Course Registration Tool.