| January 2014 | ||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| 1 | 2 | 3 | 4 | |||
| 5 Week 1 |
6 |
7 Class 1: Course Overview Chapter 1 in Kroenke Monday Schedule |
8 Class 2: Relational Model Chapter 3 in Kroenke |
9 | 10 | 11 |
| 12 Week 2 |
13 Class 3: SQL data queries Chapter 2 in Kroenke |
14 Lab 1: Access Lab Access tutorial |
15 Class 4: SQL Joins, group by queries |
16 | 17 | 18 |
| 19 Week 3 |
20 ML King Jr Day Lab 1 Due at 2359 |
21 Lab 2: SQL using MySQL Madison Imports Instructions to connect to MySQL using Workbench 5.x Instructions to connect to MySQL using Workbench 6.x Lab Solution SQL Quiz at start of lab |
22 Class 5: SQL GROUP BY, Subqueries queries Add Course Deadline |
23 | 24 | 25 |
| 26 Week 4 |
27 Class 6: More SQL SQL Quiz at start of class Lab 2 Due before 2359 |
28 Lab 3: More SQL Movie Ratings Lab Solution Start Prereg |
29 Class 7: SQL JOIN, Set Operations queries |
30 | 31 End Prereg |
|
| February 2014 | ||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| 1 | ||||||
| 2 Week 5 |
3 Class 8: SQL DDL, DML queries SQL Quiz at start of class Lab 3 Due before 2359 |
4 Lab 4: SQL Joins, DDL, and DML Lab Lab Solution |
5 Class 9: Entity-Relationship Model Chapter 5 in Kroenke |
6 | 7 | 8 |
| 9 Week 6 Academic Reserve Week |
10 Class 10: More ER Model SQL, ER model Quiz at start of class Lab 4 Due before 2359 |
11 Lab 5: Entity-Relationship modeling Lab Solution |
12 6-week Exam Review sheet Feedback due |
13 | 14 | 15 |
| 16 Week 7 |
17 Washington's Birthday |
18 Lab 6: ER to Relational lecture Chapter 6, 7 ER to Relational Model lab Lab Solution Lab 5 Due before class |
19 ER to relational model lab Grades Due |
20 | 21 | 22 |
| 23 Week 8 |
24 Class 11: Normalization Chapters 3,4 in Kroenke ER to Relational Quiz Lab 6 Due before 2359 |
25 Lab 7: Normalization lab Lab Solution |
26 Class 12: SQL Triggers, Stored Procedures Chapter 7 p287 in Kroenke, Chapter 13 p 316 in "PHP and MySQL Web Development" Update CQPR trigger Change Email trigger |
27 | 28 | |
| March 2014 | ||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| 1 | ||||||
| 2 Week 9 |
3 snow day |
4 Lab 8: finish triggers, SPs SQL Views lecture SQL triggers, stored procedures, and views lab Lab Solution Normalization, SQL Triggers quiz Lab 7 Due before class |
5 Class 13: Project Start |
6 | 7 Early Schedule |
8 |
| 9 Spring Break |
10 Spring Break |
11 Spring Break |
12 Spring Break |
13 Spring Break |
14 Spring Break |
15 Spring Break |
| 16 Week 10 |
17 Class 14: show day - lecture next day PHP Intro 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" |
18 Lab 9: PHP Intro Sample Order Form Frequent PHP Errors Lab Solution Lab 8 Due before class |
19 Class 15: PHP Arrays, Files, Functions lecture arraysExamples.php arrayFunctions.inc.php ICE: student.inc.php ICE: displayStudents.php Chapters 3 and 4 in "PHP and MySQL" Project part 0 (Project Responsibilities) Due before class |
20 | 21 | 22 |
| 23 Week 11 |
24 Class 16: PHP and MySQL song.inc.php songPage.php Songs table myConnectDB.inc.php PHP quiz at start of class |
25 Lab 10: song.inc.php songPage.php PHP and MySQL Online Store Tables Lab Solution Lab 9 Due before class |
26 Class 17: Sessions and Authentication Session examples Project part 1 (ER Model) Due before class |
27 | 28 | 29 |
| 30 Week 12 Academic Reserve Week |
31 Creating a Shopping cart Shopping Songs Provided Code ICE: song.inc.php ICE: songPage.php No quiz Lab 10 Due before 2359 |
|||||
| April 2014 | ||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| 1 Lab 11: Shopping Cart Online Store Tables |
2 12-week Exam Review sheet Feedback due |
3 Project parts 2, 3 (ER to Relational, Normalization) Due before 1530 |
4 | 5 | ||
| 6 Week 13 |
7 Work on project Lab 11 Due before 2359 |
8 Lab 12: DB Security lecture/lab DB security lab lab12.zip Grades Due |
9 Work on project Project part 4 (Triggers) Due before class |
10 | 11 Drop course deadline |
12 |
| 13 Week 14 |
14 Class 18: Transactions and Concurrency Control Chapter 9, pg 321-335 in Kroenke Start Registration Lab 12 Due before 2359 |
15 Lab 13: Transactions lab |
16 Class 19: Data storage and indexing Project part 5 milestone (login, send/receive messages, exchange) Due before class |
17 | 18 | 19 |
| 20 Week 15 |
21 Class 20: Finish Indexing and Ethics Reading and Blackboard assignment: Ethics assignment Blackboard assignment due at 0900 Lab 13 Due before 2359 |
22 Lab 14: Indexing lab |
23 project work |
24 | 25 End Registration |
26 |
| 27 Week 16 |
28 Final Project Presentations Final Project Due Lab 14 Due before 2359 |
29 SOFs Course Wrap-up Review sheet Last Day of Classes Peer feedback due before lab |
30 Reading Day |
|||
| May 2014 | ||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| 1 Start Finals |
2 | 3 | ||||
| 4 | 5 | 6 | 7 | 8 End Finals Final exam at 0755 in MI223 |
9 | 10 |
| 11 | 12 Grades Due |
13 | 14 | 15 | 16 | 17 |
| 18 | 19 | 20 | 21 | 22 | 23 Graduation Day |
24 |
| 25 | 26 | 27 | 28 | 29 | 30 | 31 |