| |
|
|
CIS332 SQL |
Thursday |
5:00 - 6:55pm |
12/1/2008 |
|
|
|
| |
|
|
Introduction to Structured Query Language |
|
Changed Below on |
|
|
|
| |
Week |
|
Assigned Reading from Text |
Monday |
Activity Due |
|
|
|
|
| |
1 |
Introduction to SQL and
Premiere Products |
Chapter 3 |
8/28/2008 |
|
|
|
|
|
| |
2 |
Create a database and DDL
tables |
DDL Create, drop, use |
9/4/2008 |
|
|
|
|
|
| |
3 |
NO CLASS TONIGHT! |
Instructor sick today |
9/11/2008 |
|
|
|
|
|
| |
4 |
DML, Insert data into our tables |
DML Insert Into, delete
from, update, DML |
9/18/2008 |
|
|
|
|
|
| |
5 |
Upload, download tables,
select |
DML, DRL,Delete, update |
9/25/2008 |
|
|
|
|
|
| |
6 |
Select |
Test WebCT |
10/2/2008 |
Test WebCT |
|
|
|
|
| |
7 |
Select |
Select |
10/9/2008 |
|
|
|
|
|
| |
8 |
Multiple Tables |
Hand out
midterm scripts |
10/16/2008 |
|
|
|
|
|
| |
9 |
Test tonight
on WebCT |
Test Tonight on WebCt |
10/23/2008 |
L5/6 due |
|
|
|
|
| |
10 |
No class tonight |
No class tonight |
10/30/2008 |
No class |
|
|
|
|
| |
11 |
L8 due Email them |
Functions,
Hand out Final Script Assignment |
11/6/2008 |
L8 due |
|
|
|
|
| |
12 |
Views |
Views |
11/13/2008 |
|
|
|
|
|
| |
13 |
No class
tonight in room 234 |
Midterm due
at 7pm tonight |
11/20/2008 |
Midterm Due |
|
|
|
|
| |
|
Thanksgiving |
Thanksgiving |
11/27/2008 |
Thanksgiving |
|
|
|
|
| |
14 |
TEST, Final Scripts Due |
TEST, Final Scripts Due |
12/4/2008 |
Final Due |
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
15 |
|
Turn back scripts and tests |
12/11/2008 |
|
|
|
|
|
| |
|
|
Approximate Schedule |
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
Ken's web site |
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
Email
Ken |
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
Call: 515-248-7230 |
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|