Serious Note: According to university policy, summer courses are supposed to have the same content and rigor as courses taught on regular (Fall and Spring) semester. In other words, this course will have the same work requirements as in regular semester which runs for 16 weeks. However, due to the fact that there are only six (6) weeks for the summer session, we will have to work more than twice as hard. For example, we normally require 10 push ups every week (in your own private room). Now, it seems to be logic that we have to do 27 pushups every week for the summer session.
|
| Instructor: |
Peter Ping Liu, Professor, Ph D,
PE, OCP, CQE and CSTM |
| Office: |
1016 Klehm Hall
11:00 AM - 12:00 PM, Monday through Friday
|
| Phone: |
(217)581-7426 (with voice mail)
|
| Email: |
Please use the email within D2Lto communicate to the instructor, regarding any issues for this course. The email within D2L 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
7 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.
- 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.
Please note that students are required
to read all course materials 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 is entitled "Oracle 12c: SQL" by Joan Casteel, Cengage Learning (c2016).
- 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
-
Database access with SQL
Projects II, III
-
Programming with PL/SQL
Project IV
-
Building a database
Project V
-
Security and resource management
Project VI
-
Database space management
-
System backup and recovery
-
System performance tuning
-
Final Project
|
|
|
| Evaluation: |
A total score will be calculated using the
following weighted percentage:
| Weekly Discussion (Instructor-Led Discussion) |
10% |
|
Problems and Solutions (Discussion)
|
10%
|
|
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
|
|
| |
Academic Integrity: |
Students are expected to maintain principles of academic integrity and conduct as de-fined in EIU’s Code of Conduct (http://www.eiu.edu/judicial/studentconductcode.php). Violations will be re-ported to the Office of Student Standards.
More detailed policy will be found in a separate file for "Course Policy."
|
| Students with Disabilities: |
If you are a student with a documented disability in need of accommodations to fully participate in this class, please contact the Office of Student Disability Services (OSDS). All accommodations must be approved through OSDS. Please stop by Ninth Street Hall, Room 2006, or call 217-581-6583 to make an appointment.
|
The Student Success Center: |
Students who are having difficulty achieving their academic goals are encouraged to contact the Student Success Center (www.eiu.edu/~success) for assistance with time management, text taking, note taking, avoiding procrastination, setting goals, and other skills to support academic achievement. The Student Success Center provides individualized consultations. To make an appointment, call 217-581-6696, or go to 9th Street Hall, Room 1302.
|
| Unofficial Definition of Professor: |
Those who go to college and never get out of college. |
