| March 2017 | ||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| 1 Class 11: Input Validation, XSS Attacks Class 12: Cookies, Samy worm |
2 | 3 Lab 8: XSS Simple TCP server Lab 7 Due BEFORE class |
4 | |||
| 5 Week 9 |
6 | 7 | 8 Class 13: Relational Model, SQL DDL, DML (filled-in slides) http://www.sqlcourse.com http://www.w3schools.com/sql/ Class 14: SQL Select intro test data queries handout queries Read w3schools SQL tutorial: everything up to and including SQL Delete, then read SQL Create table Blackboard Online Quiz Due before class |
9 | 10 Lab 9: SQL Intro createMadisonImports.sql Lab solution Early Schedule Lab 8 Due BEFORE class |
11 |
| 12 Week 10 Spring Break |
13 Spring Break |
14 Spring Break |
15 Spring Break |
16 Spring Break |
17 Spring Break |
18 |
| 19 |
20 | 21 | 22 Class 15: Python and MySQL (filled-in slides) song.py config.py songPage_handout.py songPage.py Songs table Class 16: Sessions and Authentication (filled-in slides) Session handout session1.py - create or continue a session session2.py - continue a session session3.py - delete a session Read the Python-MySQL examples: connecting to MySQL, Creating Tables, Inserting Data, and Querying Data using Connector/Python Read CGI Tutorial on Sessions: intro, Cookie based SID, The shelve module, Cookie and Shelve, skim the other parts Blackboard Online Quiz Due before class |
23 | 24 Lab 10: Python + MySQL Project 1 Lab 9 Due BEFORE class (hard-copy and online at submit.cs.usna.edu) |
25 |
| 26 Week 11 |
27 | 28 | 29 Class 17: SQL injection (filled-in slides) Class 18: MySQL and database security Read SQL injections Database security |
30 | 31 Lab 11: SQL Injection Attack Lab 10 Due BEFORE class |
|
| April 2017 | ||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| 1 | ||||||
| 2 Week 12 X-week |
3 | 4 | 5 12-week exam Policy and Topics Sample questions |
6 | 7 Work on the project Lab 11 Due BEFORE class |
8 |
| 9 Week 13 |
10 | 11 12-Week Grades Due |
12 Class 19: Web protocols (filled-in slides) Class 20: CSRF (filled-in slides) |
13 | 14 Lab 12: CSRF lab |
15 |
| 16 Week 14 |
17 | 18 | 19 Project presentations Project 2 starts sy306_projectSecurityEval.docx Project 1 Due BEFORE class |
20 | 21 Work on the project Lab 12 Due BEFORE class |
22 |
| 23 Week 15 |
24 | 25 | 26 Class 21: HTTP authentication (filled-in slides) work on project 2 |
27 | 28 Surveys Course wrap-up Sample questions work on project 2 |
29 |
| 30 Week 16 |
||||||
| May 2017 | ||||||
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
| 1 | 2 Last day of classes Project 2 Due 0900 |
3 Reading Day |
4 Final exam at 1330 in MI222 Exam topics Sample questions Exam Day 1 |
5 Exam Day 2 |
6 Exam Day 3 |
|
| 7 | 8 Exam Day 4 |
9 Exam Day 5 |
10 Exam Day 6 |
11 Exam Day 7 |
12 | 13 Final Grades Due |
| 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| 21 | 22 | 23 | 24 | 25 | 26 Graduation 2017 |
27 |
| 28 | 29 | 30 | 31 | |||