Introduction to Oracle – CSIS 327

CG • Section 8WK • 11/08/2019 to 04/16/2020 • Modified 09/05/2023

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)

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 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.

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.