Classroom: TR 9:45a–11:00a, MCRey 315
Web page www.cburch.com/cs/340/
Instructor: Dr. Carl Burch
E-mail:
Telephone: 450–1377 (office); 499–9892 (home)
Office: MCRey 310
Office hours: T 8:30–9:30, W 10:00–11:00, RF 1:30–2:30
drop-ins, appointments always welcome

Schedule

Thu 23 Jan Web system stack
Basic SQL SELECT queries [Notes]
Tue 28 Jan HTML & CSS [Code samples]
Intro JavaScript
Thu 30 Jan HTTP simple GET [Examples]
Tue 4 Feb class canceled (due to weather)
Wed 5 Feb Assn 1 due
Thu 6 Feb HTTP GET v. POST [Examples]
Browser-side AJAX [Code samples]
Tue 11 Feb class canceled (business trip)
Thu 13 Feb Assn 2 due
BCNF [Sections 1–5]
Tue 18 Feb Test 1 [Review A, Review B, Solutions]
Thu 20 Feb Test postmortem
Server-side AJAX [Code samples 0&1]
Tue 25 Feb Server-side AJAX [Code samples 2]
3NF [Sections 6–8]
Thu 27 Feb Entity-relationship diagrams
Tue 4 Mar Data modification in SQL [Section 1]
More SQL SELECT [Notes]
Wed 5 Mar Assn 3 due
Thu 6 Mar Creating tables and indexes [Sections 2 & 3]
Tue 11 Mar Test 2 [Review A, Review B, Solutions]
Thu 13 Mar Assn 4 due
Test postmortem
async library [Notes]
Tue 18 Mar B-trees [Notes]
Thu 20 Mar Assn 5 due
Nested-loop joins [§1–2]
22–30 Mar Spring Break
Tue 1 Apr 2PMMS & non-nested joins [§3–5]
Thu 3 Apr ACID & serializability [Notes]
Tue 8 Apr Project preferences due
locking [Notes]
Thu 10 Apr JDBC example
validation & timestamps [Notes]
Tue 15 Apr Test 3 [Review A, Review B, Solutions]
Thu 17 Apr buffer management [§1]
undo logging [§2]
Fri 18 Feb Assn 6 due
Tue 22 Apr templating [Notes]
cookies & logging
redo logging [§3]
Wed 23 Apr Project design due
Thu 24 Apr NoSQL & Memcached [Notes]
Tue 29 Apr Distributed databases [Notes]
Thu 1 May Project checkpoint
Object-relational databases [Notes]
Fri 2 May Assn 7 due
Tue 6 May Project demo
Wed 7 May Final, 9:00am [Review A, Review B, Solutions]
Fri 9 May Project evaluations due
15 May–25 Aug Summer Break