| January 2013 | ||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| 1 | 2 | 3 | 4 | 5 | ||
| 6 Week 1 |
7 |
8 Class 1: Course Overview Chapter 1 in Kroenke Monday Schedule |
9 Class 2: Relational Model Chapter 3 in Kroenke |
10 | 11 Lab 1: Access Lab Access tutorial |
12 |
| 13 Week 2 |
14 Class 3: SQL data queries Chapter 2 in Kroenke |
15 | 16 Class 4: SQL Joins, Aggregation queries Class Exercises Solutions |
17 Lab 1 Due at 2359 |
18 Lab 2: Basic SQL Madison Imports Instructions to connect to MySQL Lab Solution |
19 |
| 20 Week 3 |
21 ML King Jr Day |
22 Add Course Deadline |
23 Class 5: SQL GROUP BY, Subqueries queries SQL Quiz at start of class |
24 Lab 2 Due before 2359 |
25 Lab 3: More SQL Movie Ratings Lab Solution |
26 |
| 27 Week 4 |
28 Class 6: SQL JOIN, Set Operations queries |
29 Start Prereg |
30 Class 7: SQL DDL, DML queries SQL Quiz at start of class |
31 Lab 3 Due before 2359 |
||
| February 2013 | ||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| 1 Lab 4: SQL Joins, DDL, and DML Lab Lab Solution End Prereg |
2 | |||||
| 3 Week 5 |
4 Class 8: Entity-Relationship Model Chapter 5 in Kroenke SQL Quiz at start of class |
5 | 6 Class 9: More ER Model |
7 Lab 4 Due before 2359 |
8 Lab 5: Entity-Relationship modeling Lab Solution |
9 |
| 10 Week 6 X-week |
11 Class 10: ER to Relational ER to Relational Exercises Chapter 6, 7 Feedback due Entity-Relationship Model Quiz |
12 | 13 6-week Exam Review sheet |
14 Lab 5 Due before 2359 |
15 Lab 6: ER to Relational Model Lab Solution End X-week |
16 |
| 17 Week 7 |
18 Washington's Birthday |
19 | 20 Class 11: Normalization Normalization Exercises Chapters 3,4 in Kroenke Grades Due ER to Relational Quiz |
21 Lab 6 Due before 2359 |
22 Lab 7: Normalization lab Lab Solution |
23 |
| 24 Week 8 |
25 Class 12: PHP Intro PHP Intro Handout page.inc.php person.inc.php getPersonInfo.php processPersonInfo.php readPersonsInfo.php Chapter 1 and Chapter 6 (up to page 183) in "PHP and MySQL Web Development" Normalization quiz at start of class |
26 | 27 Class 13: PHP Arrays, Files, Functions PHP Arrays, Files, Functions Handout arraysExamples.php arrayFunctions.inc.php ICE: student.inc.php ICE: displayStudents.php Chapters 3 and 4 in "PHP and MySQL" |
28 Lab 7 Due before 2359 |
||
| March 2013 | ||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| 1 Lab 8: PHP Intro Sample Order Form Frequent PHP Errors Lab Solution |
2 | |||||
| 3 Week 9 |
4 Class 14: PHP and MySQL song.inc.php songPage.php Songs table myConnectDB.inc.php PHP quiz at start of class |
5 | 6 Class 15: More PHP and MySQL song.inc.php songPage.php |
7 Lab 8 Due before 2359 |
8 Lab 9: PHP and MySQL Online Store Tables Lab Solution Early Schedule |
9 |
| 10 Week 10 |
11 Spring Break |
12 Spring Break |
13 Spring Break |
14 Spring Break |
15 Spring Break |
16 Spring Break |
| 17 Week 11 |
18 Class 16: Sessions and Authentication Session examples No quiz |
19 | 20 Creating a Shopping cart Shopping Songs Provided Code ICE: song.inc.php ICE: songPage.php |
21 Lab 9 Due before 2359 |
22 Lab 10: Shopping Cart Online Store Tables Lab Solution |
23 |
| 24 Week 12 |
25 Class 17: Project Start |
26 | 27 Work on project |
28 Lab 10 Due before 2359 |
29 Project work |
30 |
| 31 Week 13 |
||||||
| April 2013 | ||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| 1 Class 18: Ethics Reading (quiz at start of class): Data misuse The Code of Professional Responsibility Start X-week Project part 1 (ER Model) Due before class Feedback due |
2 | 3 12-week Exam Review sheet |
4 | 5 Lab 11: DB Security lecture DB security lab lab11.zip Lab Solution End X-week |
6 | |
| 7 Week 14 |
8 Class 19: SQL Triggers, Stored Procedures Chapter 7, 10b in Kroenke, Chapter 13 p 316 in "PHP and MySQL Web Development" Project parts 2, 3 (ER to Relational, Normalization) Due before class |
9 Grades Due |
10 Class 20: finish triggers, SPs SQL Views LimitStudents trigger FixEmail trigger InsertStudents stored procedure |
11 Lab 11 Due before 2359 |
12 Lab 12: SQL triggers, stored procedures, and views Lab Solution Drop course deadline |
13 |
| 14 Week 15 |
15 TBA Start Registration Project milestone - partial web interface Due before class |
16 | 17 Class 21: Transactions and Concurrency Control Chapter 9, pg 321-335 in Kroenke |
18 Lab 12 Due before 2359 |
19 Lab 13: finish lecture Transactions lab Lab Solution Project Description (Part 5) and Hints updated (April 19) |
20 |
| 21 Week 16 |
22 Project work in lab |
23 | 24 Final Project Presentations Final Project Due |
25 | 26 Lab 14: Data storage and indexing lecture Indexing lab Lab Solution End Registration Lab 13 Due before lab Peer feedback due before lab |
27 |
| 28 | 29 Class 22: SOFs Course Wrap-up Review sheet in lab |
30 Last Day of Classes |
||||
| May 2013 | ||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| 1 Reading Day |
2 Start Finals Lab 14 Due before 1200 |
3 Final Exam at 1330 in MI223 |
4 | |||
| 5 | 6 Final Exam Alternate 0755 in MI223 |
7 | 8 | 9 End Finals |
10 | 11 |
| 12 | 13 Grades Due |
14 | 15 | 16 | 17 | 18 |
| 19 | 20 | 21 | 22 | 23 | 24 Graduation Day |
25 |
| 26 | 27 | 28 | 29 | 30 | 31 | |