CIS-270: Oracle Database Administration

School
Business, Entrepreneurship, & Professional Development
Department
Computer Information Systems
Academic Level
Undergraduate
Course Subject
Computer Information Systems
Course Number
270
Course Title
Oracle Database Administration
Credit Hours
3.00
Instructor Contact Hours Per Semester
62.00 (for 15-week classes)
Student Contact Hours Per Semester
62.00 (for 15-week classes)
Grading Method
A-E
Pre-requisites
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
04/25/2016
AALC Approval Date
11/09/2016
Curriculum Committee Approval Date
12/05/2016