Schedule for TEC 5323 Advanced Database Tech

TEC 5323 Advanced Database Technology

Schedule (Fall 2011)

Please use the following schedule as a hub for this course. By using this schedule page, you will be able to see all the activities to be happening during each week. There is no reason to miss any due date if you follow the schedule.

Week	Objectives	Required Readings	Assignments	Due Date (11:55 PM )
1	Set up the course Familiarize the delivery system, policy and participants	Syllabus Welcome Letter Ways to Post Technical Problem Course Policy	Course Policy How to Submit Your Project/File Survey Discussion: Self Introduction (bio)	Aug. 27 Free Tips How to Change/Resubmit Your Assignment? Difficulty of Opening Links in WebCT?
2	Principles and applications of database technology	Objectives of Chapter 1 Text of Chapter 1 Supplemental Reading(1) Supplemental Reading(PPT)(2)	Discussion Oracle Downlaod	Sept. 3 Free Tips
3	Installing Oracle	Objectives of Chapter 2 Text of Chapter 2 Oracle Setup Options Oracle 11g Installation Installation Guide for Oracle10g Supplemental Reading Problem Solutions	Discussion Project I	Sept. 10
4	Configuration and architecture of Oracle	Objectives of Chapter 3 Text of Chapter 3 Oracle Enterprise Manager Supplemental Reading Oracle 11g SQL Plus Issue and Solution Oracle History Sample Application Troubleshooting EM Troubleshooting	Discussion Project II	Sept. 17 Free Tips
5	Database access with SQL (1)	Objectives of Chapter 4 Download of Support Files Text of Chapter 4 Supplemental Reading (1)	Discussion	Sept. 24 Important Tips
6	Database access with SQL (2)	Objectives of Chapter 4 Text of Chapter 4 SQL Plus Format	Discussion Projects III	Oct. 1
7	Database access with SQL (3)	Objectives of Chapter 4 Text of Chapter 4 Supplemental Reading (2)	Discussion Projects IV	Oct. 8
8	Programming with PL/SQL (1)	Objectives of Chapter 5 Text of Chapter 5 Lessons for Project IV	Discussion Project V	Oct. 15
9	Programming with PL/SQL (2)	Objectives of Chapter 5 Text of Chapter 5	Discussion Project VI	Oct. 22 Important Tips
10	Building a database (1)	Objectives of Chapter 7 Text of Chapter 7	Discussion Mid Term Test	Oct. 29 Please note the mid term test is on Friday evening (Oct. 28).
11	Building a database (2)	Objectives of Chapter 7 Text of Chapter 7 Supplemental Reading	Discussion Project VII	Nov. 5
12	Security and resource management	Objectives of Chapter 9 Text of Chapter 9	Discussion Project VIII	Nov. 12
13	Database space management	Objectives of Chapter 10 Text of Chapter 10	Discussion Project IX	Nov. 19 (Before Thanksgiving Break)
Eat as much as turkey as you want. You may begin thinking about the final project after meals.
14	Database backup and recovery	Objectives of Chapter 11 Required Reading	Discussion Final Project Starts	Dec. 3
15	Database monitoring and tuning	Objectives of Chapter 12 Required Reading	Discussion	Dec. 10 Tips for Final Project
16	Final Exam Week	Final thoughts	Final Project Due	Dec. 11

There was life before the computer.

An application was for employment. A program was a TV show. A cursor used profanity. A keyboard was a piano!

Memory was something that you lost with age. A CD was a bank account! And if you had a broken disk, it would hurt when you found out!

Compress was something you did to garbage, not something you did to a file. And if you unzipped anything in public, you'd be in jail for awhile!

Log on was adding wood to a fire. Hard drive was a long trip on the road. A mouse pad was where a mouse lived. And a backup happened to your commode!

Cut -- you did with a pocket knife. Paste you did with glue. A web was a spider's home. And a virus was the flu!

Contributed by Dennise Wilson (Graduate Student, Spring 2002)

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