CIS-270: Oracle Database Administration

School
Business, Entrepreneurship, and Professional Development
Division
Computer Technology
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
  1. Introduction to database management systems
  2. The Database Administrator (DBA)
  3. Planning and designing a database
  4. Oracle installation and upgrade
  5. Oracle architecture and components
  6. Database security
  7. Database monitoring and tuning
  8. Oracle and third-party database administration software and tools
  9. Client/server connectivity
  10. Database backup and recovery
Core Course Learning Objectives (Separated)
  1. Differentiate a personal database from a large-scale enterprise database.
  2. Describe the role of a Database Administrator (DBA).
  3. Describe planning and design aspects to a database.
  4. Install and upgrade an Oracle instance.
  5. Configure an Oracle instance.
  6. Describe the Oracle architecture and its various components.
  7. Implement database security methods such as Perform user, roles, privileges, and profiles.
  8. Monitor and tune database performance based on usage.
  9. Perform database administration tasks using Oracle and third-party software and tools.
  10. Configure client access to the server, e.g. windows, web, application.
  11. Implement the appropriate database backup and recovery strategies based on organizational needs.

Assessment and Requirements

Assessment of Academic Achievement

Assessment of academic achievement may include (but is not limited to) exams, quizzes, homework, and laboratory assignments.

Credit for Prior College-Level Learning

Options for Credit for Prior College-Level Learning
Licensure/certifications
Licensure/Certification
Current Oracle Certified Associate (OCA) in Oracle Database Administration
Licensure/Certification Details

Student posses a recent (among the two most recent editions) Oracle Certified Associate (OCA) certifications in Oracle Database Administration. Credential will be reviewed by CIS Department.

Effective Term
Fall 2020