CIS-270: Oracle Database Administration

Business, Entrepreneurship, & Professional Development
Computer Information Systems
Academic Level
Course Subject
Computer Information Systems
Course Number
Course Title
Oracle Database Administration
Credit Hours
Instructor Contact Hours Per Semester
62.00 (for 15-week classes)
Student Contact Hours Per Semester
62.00 (for 15-week classes)
Grading Method
CIS-111 or Instructor Permission
Catalog Course Description

An advanced-level course familiarizing the student with the Oracle Database Management System covering database terminology, data structure design, data retrieval, and manipulation. Includes database server installation, configuration, Oracle components and architecture, user administration and security, performance monitoring, client application access, and backup and recovery through laboratory exercises.

Goals, Topics, and Objectives

Core Course Topics

Upon successful completion of this course, students should be able to:

  1. Introduction to database management systems
  2. Planning and designing a database
  3. The Database Administrator (DBA)
  4. Oracle instance installation and upgrade
  5. Oracle architecture and components
  6. User/group administration
  7. Database security
  8. Database monitoring and tuning
  9. Oracle and third-party database administration software and tools
  10. Client/server connectivity
  11. Database backup and recovery
Core Course Learning Objectives (Separated)
  • Describe the difference between small-business database management systems and large-scale enterprise databases.
  • Describe the role of a Database Administrator (DBA).
  • Install and upgrade an Oracle instance.
  • Configure an Oracle instance.
  • Describe the various Oracle architecture and components.
  • Perform user/group administration and security based on organizational business rules.*
  • Monitor and tune database performance based on usage.*
  • Perform database administration tasks using Oracle and third-party software and tools.
  • Configure client access to the server, e.g. windows, web, application.
  • Implement the appropriate database backup and recovery strategies based on organizational needs.*

Assessment and Requirements

Assessment of Academic Achievement

Exams, quizzes, homework and laboratory assignments

Approval Dates

Effective Term
Winter 2017
ILT Approval Date
AALC Approval Date
Curriculum Committee Approval Date