Tentative Course Schedule: Subject to change |
|||
|
|
|
|
|
Week
|
Date |
Topic |
Chapter |
|
1 |
01/07/08 01/09/08 |
Intro., DB
Environments, Oracle 10g Express: download/Install,
Launch |
Chapter 1 |
|
2 |
01/14/08 01/16/08 |
Lab on SQL – Interactive SQL queries |
Chapter 2 |
|
3 |
01/21/08 01/23/08 |
MLK Day - No Class SQL - More
DDL & DML |
|
|
4 |
01/28/08 01/30/08 |
Lab on Interactive SQL queries, Updates, Inserts, Alter SQL, Referential Integrity |
|
|
5 |
02/04/08 02/06/08 |
Lab MS-Access/VB, lab on MS-Access/Oracle Test # 1 - in class |
|
|
6 |
02/11/08 02/13/08 |
Chapter 3 Chapter 4 |
|
|
7 |
02/18/08 02/20/08 |
E-R
Diagrams |
Chapter 5 Chapter 5 |
|
8 |
02/25/08 02/27/08 |
Converting ER Diagrams to Tables Converting ER Diagrams to Tables |
Chapter 6 Chapter 6 |
|
9 |
03/03/08 03/05/08 |
Spring Break Spring Break |
|
|
10 |
03/10/08 03/12/08 |
Review for Test, Hw. Questions Test # 2 |
|
|
11 |
03/17/08 03/19/08 |
Views, Triggers, Stored Procedures, ASU examples Lab/Triggers, Example |
Chapter 7 Chapter 7 |
|
12 |
03/24/08 03/26/08 |
Chapter 8 Chapter 9 |
|
|
13 |
03/31/08 04/02/08 |
Database Administration, Security |
Chapter 12 |
|
14 |
04/07/08 04/09/08 |
Lab on JDBC |
Chapter 14 Ch. 12-14 |
|
15 |
04/14/08 04/16/08 |
Lab-Transfer Data & XML Datawarehouse (see moodle) |
Chapter 15 |
|
16 |
04/21/08 04/23/08 |
Presentations |
|
|
|
04/28/08 |
Presentations Final Exam (in class; covers all topics) 04/30/08 - 11:00 am - 3310/01 – 11:00am-1pm 05/05/08 - 3:30 pm – 3310/02 - 3:30-5:30 pm 05/05/08 - 6:30 pm – 3310/03 – 6:30-8:30 pm |
|
Previous Exams
Fall 06: t1 answers,
t2, t2 answers,
t3, t3answers
Old
Tests: t1,
t1answers, t2 Spring 06,
t2Spring06
answers, t3
Quiz: quiz1, quiz1answer , quiz2
& answer, quiz3 &
answer quiz4
& answer
Additional
Resources: SQL (w3schools) SQL Tutorial (new lin) !
Opportunities:
Summer Research
Opportunity , Brazil study abroad