Week 6
Things to know & do in week 6.
- The total workload for this course is 140 hours. In week 6, we expect you to spend 4 hours on lectures, 4 hours in the lab and 7 hours on a mix of things (quiz, required readings, peer reviews, additional lab work, etc.).
- Get started on this week's lab assignment (A5) and quiz.
Groups in cluster C2 are assessed this week on Assignments A3 & A4. Make sure you reserve yourself an assessment spot and don't forget to upload your solution via the "Lab Submissions" link here on Blackboard.
- Minor students: http://doodle.com/poll/f5wp7yrftm7x53wd
- Thursday students: http://doodle.com/poll/zgkheytabdrmddy8
- Friday students: http://doodle.com/poll/d5vvg69mtpqwf7c3
Lecture 10-Advanced SQL
- advancedsql-1.pdf
The PDF slides cover the advanced features of the SQL language.
Required reading
In Chapters 4 & 5 of the Database book:
- 4.3 Basic Retrieval Queries in SQL
- 5.1.1 Comparison involving NULL and three-valued logic
- 5.1.5 Explicit Sets and Renaming of Attributes in SQL
- 5.1.6 Joined Tables in SQL and Outer Joins
Recommended Readings
The followings are a set of online resources that can be useful to better understand the SQL syntax and semantics.
- MySQL SQL Syntax Reference
- SQL For Web Nerds. Section 8: Style [HTML]
- Tutorial on subqueries with MySQL [HTML]
Lecture 11
- cookieSessionsAuth-lecture11.pdf
Recommended readings:
- Mozilla's document.cookie documentation (using client-side JavaScript to access/modify cookies)
- Chapter 9 of Web Development with Node & Express by Ethan Brown (available via the campus network)
Quiz W6
The quiz can be attempted once. Its content covers the lectures of week 6 and the sole lecture of week 5 (nodejes II).
Quizzes are individual work!
Deadline: December 21, 2pm.
Lab assignment A5
Labs are team work. Make sure both team members can answer the questions of the lab assignment(s) during the assessment session - it is not the team that passes/fails the assessment, but individual team members!
Note: the lab assignment was updated December 14, 2015 (10am).