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.

Measurable Learning Results:

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

1. • Describe the structured query language (SQL) fundamentals of Oracle databases.
   • Manipulate data in an Oracle database using SQL expressions, clauses, operations, and functions.
   • Write advanced SQL subqueries, and set operators, sequences, and views to solve business problems.
   • Use the data manipulation language (DML) and data definition language (DDL) to control databases and tables.
   • Discuss the relevance of course material and the use of technology to a biblical worldview.

Course Assignment Detail:

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.

Total No.of 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 set up 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.

Total No.of 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.