TITLE: Database Systems in Corporate Environments
Lead Instructor: Frank Chao
Office: PLM, 361D
Phone: (919) 662-3398

Office Hours:
Posted In Blackboard

     Title: Oracle9i Database Administrator II: Backup/Recovery & Network Administration
     Author: Lannes L. Morris-Murphy
     ISBN: 0-619-15902-2
     Publisher: Thomson Course Technology

Software used to complete coursework: Oracle 9i, Refer http://otn.oracle.com/software/content.html
Other required equipment:

Credit Hours: Three (3) Semester Hours
Pre-requisites: CIS 115 or CIS 152
Co-requisites: none

Course Description:
This course covers database systems as they relate to the corporate environment. Topics include knowledge-based, decision-support, and expert systems; database choice issues; corporate structure; and a survey of types of firms whose business is the database. Upon completion, students should be able to identify the database systems needed by a corporation. The software used in the course is Oracle9i database.

Course Goals:

To obtain the education and hands-on skill to Administer an RDBMS, Relational Database Management System.

Course Objectives:
Upon successful completion, students will be able to demonstrate (through completion of classwork and assignments):
  • An understanding of the Oracle Architecture related to Networking and Backup and Recovery
  • An understanding of Oracle Database Structures related to Networking and Backup and Recovery
  • An understanding of Oracle Storage Structures related to Networking and Backup and Recovery The education and hands-on skill to pass Oracle Certification Exam 1Z0-032
The Core Values of Wake Technical Community College
Respect Instructor and students will foster an environment that is respectful of all.
Responsibility Instructor and students will foster an environment that promotes taking responsibility for one's actions and obligations.
Critical Thinking Instructor and students will strive to improve the critical thinking skills of analysis, synthesis, and evaluation.
Communication Instructor and students will strive to ensure that both written and oral communications are clearly understood.
Collaboration Instructor and students will strive to develop collaborative skills.

Grading Is As Follows:
Exams 60 30% of each
Labs/Projects 30 About 10 homework assignments
Attendance 10  

Classroom Policies:
  • Students are responsible for all of the information presented in the Wake Technical Community College Student Handbook.
  • Please note that computers are to be used at all times for official course purposes. Use of computers for general web surfing, email, chat rooms, etc. is not allowed. Violation of this rule will result in a grade deduction and possible loss of computer privileges.
  • The college forbids the use of audible electronic equipment (cell phones, pagers, etc.) during instructional time.
  • If you miss a lecture or arrive late, you are responsible for the material presented, handouts distributed, and any announcements made that day. The instructor will not provide notes for missed classes.
Tentative Schedule
Note: This schedule is subject to some changes/modifications per Instructor -- This offered as only a study guide. The pace of each class differs according to the instructional needs of the students in the class. Always consult with your instructor. Note** A Final Project may be assigned in leiu of a Final Exam.
Unit Coursework Textbook/Assignments
Backup and Recovery Overview
Chapter 1
Chapter 2 
User-Managed Backups
Chapter 3
User-Managed Complete Recovery
Chapter 4 
User-Managed Incomplete Recovery
Chapter 5 
Overview of Recovery Manager
Chapter 6
Performing Backup Operations with Recovery Manager
Chapter 7 
Complete Recovery with Recovery Manager  
Chapter 8
Incomplete Recovery with Recovery Manager  
Chapter 9
Recovery Manager Maintenance
Chapter 10
Recovery Catalog
Chapter 11
Loading and Transporting Data
Chapter 12
Network Administration and Server-Side Configuration
Chapter 13
Client-Side Configuration and Oracle Shared Server
Chapters 14 & 15

Disability Support Services is available for students who require academic accommodations due to any physical, psychological, or learning disability. To determine eligibility, contact the office at 108-S Holding Hall or call
662-3405 (TDD 779-0668)

Copyright 2005/2006 Wake Technical Community College All Rights Reserved