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
- Introduction to database management systems
- The Database Administrator (DBA)
- Planning and designing a database
- Oracle installation and upgrade
- Oracle architecture and components
- Database security
- Database monitoring and tuning
- Oracle and third-party database administration software and tools
- Client/server connectivity
- Database backup and recovery
Core Course Learning Objectives (Separated)
- Differentiate a personal database from a large-scale enterprise database.
- Describe the role of a Database Administrator (DBA).
- Describe planning and design aspects to a database.
- Install and upgrade an Oracle instance.
- Configure an Oracle instance.
- Describe the Oracle architecture and its various components.
- Implement database security methods such as Perform user, roles, privileges, and profiles.
- 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
Assessment of academic achievement may include (but is not limited to) exams, quizzes, homework, and laboratory assignments.
Credit for Prior College-Level Learning
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.
Approval Dates
Effective Term
Fall 2020
Review Semester
Fall 2020