January 2012
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
1 2 3 4 5 6 7
8

Week 1 
9

10

Class 1: Course Overview

Read Chapter 1 in Kroenke

Monday Schedule
11 12

Lab 1: Access Lab
Access tutorial
13

Class 2: SQL
data
queries
Chapter 2 in Kroenke
14
15

Week 2 
16

ML King Jr Day
17 18

Lab 1 Due at 2359
19

Lab 2: Basic SQL
Madison Imports
Instructions to connect to MySQL

Lab Solution

SQL Quiz at start of lab
20

Class 3: More SQL
queries
21
22

Week 3 
23

Class 4: More SQL
queries
24

Add Course Deadline
25 26

Lab 3: More SQL
Movie Ratings

Lab Solution

Lab 2 Due BEFORE start of Lab

SQL Quiz at start of lab
27

Class 5: Relational Model

Chapter 3 in Kroenke
28
29

Week 4 
30

Class 6: Normalization
Chapters 3,4 in Kroenke
31

Start Prereg
       

February 2012
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
      1 2

Lab 4: Normalization lab

Lab Solution

Lab 3 Due before lab

Relational Model and Normalization Quiz
3

Class 7: Entity-Relationship Model
ER Model Exercises

Chapter 5

End Prereg
4
5

Week 5 
6

Class 8: More ER Model
7 8 9

Lab 5: Entity-Relationship modeling

Lab Solution

Lab 4 Due before lab

Entity-Relationship Model Quiz
10

Class 9: ER to Relational
ER to Relational Exercises

Chapter 6, 7
11
12

Week 6 
13

Class 10: Review

Start X-week
14 15 16

Lab 6: ER to Relational Model

Lab Solution

Lab 5 Due before lab
17

6-week Exam

End X-week
18
19

Week 7 
20

Washington's Birthday
21 22

Grades Due
23

Lab 7: SQL lecture queries
More SQL Lab

Lab Solution

Lab 6 Due before lab
24

Class 11: PHP Intro
page.inc
person.inc
getPersonInfo
processPersonInfo
readPersonsInfo

Chapter 1 and Chapter 6 (up to page 183) in "PHP and MySQL Web Development"
25
26

Week 8 
27

Class 12: PHP Arrays, Files, Functions
arraysExamples
arrayFunctions.inc
ICE: student.inc
ICE: displayStudents

Chapters 3 and 4 in "PHP and MySQL"
28 29      

March 2012
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
        1

Lab 8: PHP Intro
Sample Order Form
Frequent PHP Errors

Lab 7 Due before lab

PHP quiz at start of lab
2

Class 13: PHP and MySQL
Song Class
Song Page
Songs table
myConnectDB.inc.php
3
4

Week 9 
5

Class 14: More PHP and MySQL, lab work
6 7 8

Lab 9: PHP and MySQL

Lab Solution
9

Class 15: lab work

Early Schedule

Lab 8 Due before class
10
11

Spring Break
12

Spring Break
13

Spring Break
14

Spring Break
15

Spring Break
16

Spring Break
17
18

Week 10 
19

Class 16: Project Start
20 21 22

Project work

Lab 9 Due before lab

Project responsibilities email and hardcopy due at noon
23

Class 17: Sessions and Authentication
Session examples
24
25

Week 11 
26

Class 18: Creating a Shopping cart
Shopping Songs Provided Code
ICE: song.inc
ICE: songPage
27 28 29

Lab 10: Shopping Cart
Online Store Tables

Project Parts 1-4 (ER model, ER to Relational, Normalization, Load Data) Due before lab
30

Project work
31

April 2012
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
1

Week 12 
2

Class 19: SQL Stored Procedures, Triggers
Chapter 7, 10b in Kroenke, Chapter 13 p 316 in "PHP and MySQL Web Development"

Start X-week
3 4 5

Lab 11: SQL Views Lecture
SQL stored procedures, triggers and views lab

Lab Solution

Lab 10 Due before lab

Feedback due
6

12-week Exam
Review sheet

End X-week
7
8

Week 13 
9

Project work
10

Grades Due
11 12

Lab 12: DB Security lecture
DB security lab
lab12.zip

Lab Solution

Lab 11 Due before lab

Project milestone - upload/view photo due before lab (demo during lab)
13

Class 20: Transactions and Concurrency Control
Chapter 9, pg 321-335 in Kroenke

Drop course deadline
14
15

Week 14 
16

Guest lecture

Start Registration
17 18 19

Lab 13: finish lecture
Transactions lab

Lab Solution

Lab 12 Due before lab

Project milestone - add/view friends due before lab (demo during lab)
20

Class 21: Ethics Reading (quiz at start of class): Data misuse
The Code of Professional Responsibility
21
22

Week 15 
23

Class 22: Data storage and indexing
24 25 26

Lab 14: Indexing

Lab Solution

Lab 13 Due before lab
27

Final Project Presentations

End Registration

Final Project Due
28
29

Week 16 
30

SOFs,
Course Wrap-up Review sheet
         

May 2012
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
    1

Last Day of Classes
2

Reading Day
3

Start Finals
4 5
6 7 8 9 10

Final Exam at 0755 in MI223

End Finals
11 12
13 14

Grades Due
15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31