Home Up

CIS 220 Tentative* Course Schedule

Fall 2008

Week Mon Tue Wed Thu Fri Sun
1
PPT
9/22
bulletIntroduction
9/23
bulletDatabase Terminology
9/24
bulletMySQL
9/25
Quiz 1 expires - Ch 1 pp. 13-57
9/26
 
9/28
Quiz 2 expires -
Ch. 1, pp. 58-100
2
PPT
9/29
bulletSelecting data
9/30
bulletUpdate
10/1
bulletDelete
10/2
Asst 1 due:  Create
and populate DB
10/3
 
10/5
Quiz 3 expires -
Ch. 2, pp. 101-158
3
PPT
10/6
bulletWorking with databases & tables (DDL)
10/7
bulletIndexes
10/8
bulletTable joins
10/9
Asst 2 due: 
SQL
10/10

 

10/12
Quiz 4 expires -
Ch. 2, pp. 159-200
4
PPT
10/13 10/14
bulletSubqueries
10/15 10/16
Asst 3 due: 
SQL Joins
10/17
Professional Day -
No class
10/19
Quiz 5 expires -
Ch. 3, pp. 201-206,
213-237,
242-250
5 10/20
bulletTransactions
10/21
bulletData Types
10/22 10/23
Asst 4 due:  Subqueries
& Transactions
10/24
 
10/26
Quiz 6 expires -
Ch. 3, pp. 252-287
6 10/27
bulletSequences
bulletRegular Expressions
bulletData Conversion
10/28
 
10/29
10/30
Asst 5 due: Data Types
10/31
MIDTERM EXAM
(Ch. 1-3)
11/2

7
PPT
11/3
bulletStored Procedures

11/4
Quiz 7 - Ch. 4 & E.2, pp. 1028-1033
11/5 11/6
11/7
 
11/9

8
PPT
11/10
 
bulletFunctions & Triggers
11/11
Veteran's Day -
No class
11/12 11/13
Asst 6 due: Procedures
11/14
11/16
Quiz 8 - Ch 5
9
PPT
11/17
bulletQuery Optimization
11/18
 
11/19 11/20
Asst 7 due:  Triggers
11/21
11/23
10
PPT
11/24
bulletDatabase Security
11/25
 
11/26
Asst 8 due: Indexes
11/27
Thanksgiving
No class
11/28
11/30
11 12/1 12/2 12/3 12/4
12/5
 
12/7
12 12/8

 

12/9
FINAL EXAM
10:00-11:50 AM
       

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

*

 

 *This schedule is absolutely, positively subject to change at any time!