CSE 344 Autumn 2014
Course Calendar

Subscribe to this calendar (google, iCal, etc.)

 Show color key

September
MondayTuesdayWednesdayThursdayFriday
22 23 24
13:30-14:20 Lecture
JHN 102
1. Introduction
Slides
25
Section
1. Intro to SQLite
Slides sql code
26
13:30-14:20 Lecture
JHN 102
2. Data Models (2.1-2.3)
Sqlite notes
29
13:30-14:20 Lecture
JHN 102
3. SQL (6.1, 6.2)
Sqlite notes (Sqlite supplement)
14:30-17:00 OH
CSE 006 lab
30
16:30-17:30 OH (Siena)
CSE 006 lab
01
13:30-14:20 Lecture
JHN 102
4. SQL - Aggregates (6.3, 6.4)
Slides, Sqlite notes, lec04-data.txt
16:00-17:00 OH (Srini)
CSE 006 lab
02
Section
2. More SQL
slides problems solutions
16:30-17:30 OH (Hal)
CSE 021
03
13:30-14:20 Lecture
JHN 102
5. SQL - Aggregates (6.3, 6.4) (concl.)
15:30-16:30 OH (Shengliang)
CSE 006 lab

October
MondayTuesdayWednesdayThursdayFriday
06
13:30-14:20 Lecture
JHN 102
6. Basic Query Evaluation, Indexes (14.1)
Slides
15:30-16:30 OH (Dan)
CSE 006 lab
07
16:30-17:30 OH (Siena)
CSE 006 lab
08
13:30-14:20 Lecture
JHN 102
7. SQL - Nested Queries (6.3)
Slides Sqlite notes, Additional notes
16:00-17:00 OH (Srini)
CSE 006 lab
09
Section
3. Subqueries & SQL Azure
slides Worksheet Solutions
16:30-17:30 OH
CSE 006 lab
10
13:30-14:20 Lecture
JHN 102
8. SQL Wrap-up (6.3, 2.4); System Architecture
SQL Slides Architecture Slides
15:30-16:30 OH (Shengliang)
CSE 006 lab
13
13:30-14:20 Lecture
JHN 102
9. Relational Algebra (2.4, 5.1)
Slides
16:00-17:00 OH (Dan)
CSE 006 lab
14
16:30-17:30 OH (Siena)
CSE 006 lab
15
13:30-14:20 Lecture
JHN 102
10. Relational Algebra (concl.)
16:00-17:00 OH (Srini)
CSE 006 lab
16
Section
4. Relational algebra
slides Worksheet Solutions
16:30-17:30 OH (Hal)
CSE 021
17
13:30-14:20 Lecture
JHN 102
11. Datalog (5.3, 5.4)
Slides Query Language Primer
15:30-16:30 OH (Shengliang)
CSE 006 lab
20
13:30-14:20 Lecture
JHN 102
12. Relational Calculus (5.3, 5.4)
Slides
16:00-17:00 OH (Dan)
CSE 006 lab
21
16:30-17:30 OH (Siena)
CSE 006 lab
22
13:30-14:20 Lecture
JHN 102
13. XML, XPath (11.1-11.3, 12.1)
Slides Examples: XML XML with DTD
16:00-17:00 OH (Srini)
CSE 006 lab
23
16:30-17:30 OH
CSE 006 lab
24
13:30-14:20 Lecture
JHN 102
14. XQuery (12.2)
Slides
15:30-16:30 OH (Shengliang)
CSE 006 lab
27
13:30-14:20 Lecture
JHN 102
15. E/R Diagrams (4.1-4.6)
Slides
16:00-17:00 OH (Dan)
CSE 006 lab
28
16:30-17:30 OH (Siena)
CSE 006 lab
29
13:30-14:20 Lecture
JHN 102
16. Constraints (7.1, 7.2, 7.4)
Slides
16:00-17:00 OH (Srini)
CSE 006 lab
30
16:30-17:30 OH (Hal)
CSE 021
31
13:30-14:20 Lecture
JHN 102
17. Design Theory (3.1-3.4)
Slides
15:30-16:30 OH (Shengliang)
CSE 006 lab

November
MondayTuesdayWednesdayThursdayFriday
03
Midterm Review Q&A SUNDAY 2pm
EEB 037
13:30-14:20 Midterm exam
16:00-17:00 OH (Dan)
CSE 006 lab
04
16:30-17:30 OH (Siena)
CSE 006 lab
23:00 WQ5 due: XML
05
13:30-14:20 Lecture
JHN 102
19. Design Theory (concl.)
16:00-17:00 OH (Srini)
CSE 006 lab
06
Section
7. Conceptual Design
Slides
16:30-17:30 OH (Hal)
CSE 021
23:00 HW5 due: XML
07
13:30-14:20 Lecture
JHN 102
20. Views
Slides
15:30-16:30 OH (Shengliang)
CSE 006 lab
10
13:30-14:20 Lecture
JHN 102
21. Transactions Intro
Sqlite Notes
16:00-17:00 OH (Dan)
CSE 006 lab
11
Veterans' Day
12
13:30-14:20 Lecture
JHN 102
22. Transactions I (18.1-18.3)
Slides
16:00-17:00 OH (Srini)
CSE 006 lab
13
Section
8. SQL in Java, Transactions
Slides helloDatabase.java sample code
16:30-17:30 OH
CSE 006 lab
14
13:30-14:20 Lecture
JHN 102
23. Transactions II (18.3-18.4, 6.6)
Slides
15:30-16:30 OH (Shengliang)
CSE 006 lab
17
13:30-14:20 Lecture
JHN 102
24. Transactions (concl.); Parallel Databases (start)
Slides
16:00-17:00 OH (Dan)
CSE 006 lab
18
16:30-17:30 OH (Siena)
CSE 006 lab
19
13:30-14:20 Lecture
JHN 102
25. Parallel Databases (cont.)
16:00-17:00 OH (Srini)
CSE 006 lab
20
Section
9. AWS, MapReduce
Slides
16:30-17:30 OH (Hal)
CSE 021
21
13:30-14:20 Lecture
JHN 102
No lecture today
15:30-16:30 OH (Shengliang)
CSE 006 lab
24
13:30-14:20 Lecture
JHN 102
26. Parallel Databases (concl.); MapReduce
Slides
16:00-17:00 OH (Dan)
CSE 006 lab
25
16:30-17:30 OH (Siena)
CSE 006 lab
26
13:30-14:20 Lecture
JHN 102
27. Parallel Databases - MapReduce, PigLatin
Slides Pig examples
16:00-17:00 OH (Srini)
CSE 006 lab
27
Thanksgiving
28
Day after Thanksgiving

December
MondayTuesdayWednesdayThursdayFriday
01
13:30-14:20 Lecture
JHN 102
28. Parallel Databases - Wrapup
Slides
16:00-17:00 OH (Dan)
CSE 006 lab
02
16:30-17:30 OH (Siena)
CSE 006 lab
03
13:30-14:20 Lecture
JHN 102
29. NoSQL
Slides
16:00-17:00 OH (Srini)
CSE 006 lab
04
Section
10. No section this week - course summary in lecture Friday
16:30-17:30 OH (Hal)
CSE 021
05
13:30-14:20 Lecture
JHN 102
30. Final Review
Slides
15:30-16:30 OH (Shengliang)
CSE 006 lab
08
Final Exam Review Q&A SUNDAY 2pm
EEB 037
14:30-16:20 Final exam
09 10 11 12