| Instructor: |
Peter Ping Liu, Professor, Ph D,
PE, OCP, CQE and CSIT
|
| Office: |
4032 Klehm Hall
11:00 AM - 11:50 PM, Monday through Friday
|
| Phone: |
(217)581-6267 (with voice mail)
|
| Email: |
Please use the email within WebCT to communicate to the instructor, regarding any issues for this course. The email within WebCT is simple, but clean.
|
| Course
Description: |
Study of advanced database technology (Oracle) for
applications in contemporary industry including architecture,
operations, system maintenance and management. |
| Credit: |
2-2-3
|
| Prerequisite: |
Experience with and access to high performance computer
which allows students to install their own Oracle software (Oracle Database Enterprise Edition). System
requirements: RAM >526 MB (minimum) and enough hard drive capacity, Windows
2000/XP/VISTA or newer.
|
|
Course Objectives:
|
Students will:
- Demonstrate
principles of design, development, and administration relevant
to Oracle database technology.
- Formulate
a working definition of database development and administration.
- Identify
the contemporary architecture of database systems.
- Survey the
characteristics of widely used hardware, operating systems
, and software for the database technology applications.
- Apply advanced
database technology to manage operations in industry.
- Gain a working
knowledge of developing and maintaining a small-scale database
project.
- Develop skills
of leadership, problem solving, and communication.
- Participate
in local (e.g., EIU list server) and external (e.g., Oracle
Technology Network) electronic discussion groups on Oracle
database technology.
- Discuss issues related to Internet-centered revolution
in computer technology.
|
| |
| Readings: |
- Textbook: All required readings were posted
on the course web site. Please refer to the Schedule
for reading assignment for this course. Those course materials were
based upon a book by S. Bobrowski, Oracle 8i for Windows NT:
Starter Kit, Berkeley: Osborne/McGraw-Hill (c2000). Changes have been made through the years due to software version upgrades.
Please note that students are required
to read all chapters posted on the course web site.
As a part of continuous improvement, students are encouraged
to find errors in the posted chapters. If you find an error
in any code presented in the text, you will receive 5 bonus
points for this course. Please email the instructor about
your findings to redeem your bonus.
- Reference Book: The book you received from Textbook Rental
Services will serve as a major reference book for this course.
It in entitled "Oracle Database 10g: PL/SQL 101 " by Christopher Allen, Oracle Press, McGraw-Hill/Osborne (c2004).
- Internet: http://www.oracle.com
and other web sites.
- Assigned Readings in Database Technology.
Please refer to the Schedule
for each chapters for this course.
|
| |
| Course Outline: |
-
Principles and applications of database
technology
-
Installing Oracle
Project I
-
Configuration and architecture of Oracle
Project II
-
Database access with SQL
Projects III, IV
-
Programming with PL/SQL
Project V
-
Building a database
Project VI
-
Security and resource management
Project VII
-
Database space management
Project VIII
-
System backup and recovery
Project IX
-
System performance tuning
-
Final Project
|
|
|
| Evaluation: |
A total score will be calculated using the
following weighted percentage:
|
Discussion
|
20%
|
|
Projects
|
45%
|
|
Mid-term test
|
10%
|
|
Final project
|
25%
|
Individual grade is based on the total score using the following
scale:
|
Total >= 90
|
A
|
|
80 <= Total <90
|
B
|
|
70 <= Total < 80
|
C
|
|
60 <=Total < 70
|
D
|
|
Total< 60
|
F
|
|
| |
ADA Statement: |
If you have a documented disability and wish
to receive academic accommodations, please contact the Coordinator
of the Office of Disability Services (581-6583) as soon as possible.
|
| Unofficial Definition of Professor: |
Those who go to college and never get out of college. |
