TEC 5323 Advanced Database Technology

Syllabus
Schedule
Assignments
Resources
Discussion
Tests
FAQ
Notes

Course Syllabus
(New and Improved
! Fat Free!)

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:

  1. Demonstrate principles of design, development, and administration relevant to Oracle database technology.
  2. Formulate a working definition of database development and administration.
  3. Identify the contemporary architecture of database systems.
  4. Survey the characteristics of widely used hardware, operating systems , and software for the database technology applications.
  5. Apply advanced database technology to manage operations in industry.
  6. Gain a working knowledge of developing and maintaining a small-scale database project.
  7. Develop skills of leadership, problem solving, and communication.
  8. Participate in local (e.g., EIU list server) and external (e.g., Oracle Technology Network) electronic discussion groups on Oracle database technology.
  9. 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:
  1. Principles and applications of database technology
  2. Installing Oracle
    Project I
  3. Configuration and architecture of Oracle
    Project II
  4. Database access with SQL
    Projects III, IV
  5. Programming with PL/SQL
    Project V
  6. Building a database
    Project VI
  7. Security and resource management
    Project VII
  8. Database space management
    Project VIII
  9. System backup and recovery
    Project IX
  10. System performance tuning 
  11. 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.

 

Go Back to Course Index

 

 

School of Technology
College of Business & Applied Sciences
Eastern Illinois University