Lead Instructor:
Dr. Frank
Chao
Office:
PLM,
361D
Phone:
(919)
662-3398
Posted In Blackboard
Textbook(s):
Title: Oracle9i Database
Administrator: Implementation and Administration
Author:
McCullough-Deiter
ISBN: 0-619-15900-6
Publisher: Thomson Course Technology
Software
used to complete coursework: Oracle 9i
Other required
equipment:
Credit Hours: Three (3) Semester
Hours
Pre-requisites: CIS110 or CIS111 or
OST137
Co-requisites: none
Course
Description:
This
course covers database administration issues and distributed database
concepts. Topics include database administrator (DBA) goals and functions,
backup and recovery, standards and procedures, training, and database
security and performance evaluation. Upon completion, students should be
able to produce DBA functions' documentation.
Course Goals:
- To obtain the education and hands-on skill to Administer an RDBMS,
Relational Database Management System, help students well prepare and
familiar with Oracle and Oracle certification SQL (1Z0-031)
exam.
Course
Objectives:
Upon
successful completion, students will be able to demonstrate (through
completion of classwork and assignments):
- An understanding of the Oracle Architecture
- An understanding of Oracle Database Structures
- An understanding of Managing Tablespace and Datafiles
- An understanding of Oracle Storage Structures
- An understanding of Managing Oracle Database Objects, Users, Roles
- The education and hands-on skill to pass Oracle Certification Exam
1Z0-031
| 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 |
Attendance is required |
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 |
|---|
| 1 |
Introduction |
|
| 2 |
Oracle Architecture Overview |
|
| 3 |
Overview of Database Administrator (DBA) Tools |
|
| 4 |
Data Dictionary Views and Control Files |
|
| 5 |
The Redo Log Files and Diagnostic Files |
|
| 6 |
Basic Storage Concepts and Settings |
|
| 7 |
Basic Table Management |
|
| 8 |
Midterm |
|
| 9 |
Advanced Table Management |
|
| 10 |
Index Management |
|
| 11 |
Data Integrity Constraints |
|
| 12 |
Users and Resource Control |
|
| 13 |
System and Object Privileges
|
|
| 14 |
Database Roles |
|
| 15 |
Globalization Support in the Database |
|
| 16 |
Final |
|
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 |
