CSE 414 Spring 2015 Course Calendar

CSE 414 Spring 2015
Course Calendar

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

March

Monday Tuesday Wednesday Thursday Friday

30
13:30-14:20 Lecture
JHN 102
1. Introduction
Slides
31 01
13:30-14:20 Lecture
JHN 102
2. Data Models (2.1-2.3)
Sqlite notes
02
Section
1. Intro to SQLite
slides problems
03
13:30-14:20 Lecture
JHN 102
3. SQL (6.1, 6.2)
Sqlite notes (Sqlite supplement)

April

Monday Tuesday Wednesday Thursday Friday

06
13:30-14:20 Lecture
JHN 102
4. SQL - Aggregates (6.3, 6.4)
Slides, Sqlite notes, lec04-data.txt

16:30-17:30 OH (JN)
CSE 021

23:00 WQ1 due: sql (basic)
07
16:00-17:00 OH (MM)
MGH 286
08
11:00-12:00 OH (YP)
MGH 286

13:30-14:20 Lecture
JHN 102
5. SQL - Aggregates (6.3, 6.4) (concl.)

16:00-17:00 OH (SX)
MGH 286

23:00 HW1 due: sqlite
09
Section
2. More SQL - Aggregates
slides problems sample solutions

16:00-17:00 OH (HU)
MGH 286
10
11:00-12:00 OH (YW)
MGH 286

13:30-14:20 Lecture
JHN 102
6. Basic Query Evaluation, Indexes (14.1)
Slides

13
13:30-14:20 Lecture
JHN 102
7. SQL - Nested Queries (6.3)
Slides Sqlite notes, Additional notes

16:00-17:00 OH (JN)
MGH 286

23:00 WQ2 due: sql (aggregates)
14
16:00-17:00 OH (MM)
MGH 286
15
11:00-12:00 OH (YP)
MGH 286

13:30-14:20 Lecture
JHN 102
8. SQL Wrapup (6.3, 2.4); System Arch.
SQL Slides, Arch. Slides

16:00-17:00 OH (SX)
MGH 286

23:00 HW2 due: Basic SQL
16
Section
3. SQL Azure & nested queries
slides sample sql azure queries problems sample solutions

16:00-17:00 OH (HU)
MGH 286
17
11:00-12:00 OH (YW)
MGH 286

13:30-14:20 Lecture
JHN 102
9. Relational Algebra (2.4, 5.1, 5.2)
Slides

20
13:30-14:20 Lecture
JHN 102
10. Relational Algebra (cont.)

16:00-17:00 OH (JN)
MGH 286

23:00 WQ3 due: sql (nested)
21
16:00-17:00 OH (MM)
MGH 286
22
11:00-12:00 OH (YP)
MGH 286

13:30-14:20 Lecture
JHN 102
11. Relational Algebra (concl.); Query Impl. (15.1-15.6)
Slides

16:00-17:00 OH (SX)
MGH 286

23:00 HW3 due: Advanced SQL
23
Section
4. Relational algebra
slides problems sample solutions

16:00-17:00 OH (HU)
MGH 286
24
11:00-12:00 OH (YW)
MGH 286

13:30-14:20 Lecture
JHN 102
12. Query Implementation

27
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 (JN)
MGH 286

23:00 WQ4 due: Relational algebra & query execution
28
16:00-17:00 OH (MM)
MGH 286
29
11:00-12:00 OH (YP)
MGH 286

13:30-14:20 Lecture
JHN 102
13. XPath (concl.)

16:00-17:00 OH (SX)
MGH 286

23:00 HW4 due: Relational Algebra & Query Execution
30
Section
5. Midterm review

16:00-17:00 OH (HU)
MGH 286
01
11:00-12:00 OH (YW)
MGH 286

13:30-14:20 Lecture
JHN 102
14. XQuery (12.2)
Slides

May

Monday Tuesday Wednesday Thursday Friday

04
Midterm Q&A Session SUNDAY 2PM (slides)
SAV 264

13:30-14:20 Midterm exam

16:00-17:00 OH (JN)
MGH 286
05
16:00-17:00 OH (MM)
MGH 286
06
11:00-12:00 OH (YP)
MGH 286

13:30-14:20 Lecture
JHN 102
15. E/R Diagrams (4.1-4.6)
Slides

16:00-17:00 OH (SX)
MGH 286
07
Section
6. XML
slides problems sample solutions

16:00-17:00 OH (HU)
MGH 286
08
11:00-12:00 OH (YW)
MGH 286

13:30-14:20 Lecture
JHN 102
16. Constraints (7.1, 7.2, 7.4)
Slides

11
13:30-14:20 Lecture
JHN 102
17. Design Theory (3.1-3.4)
Slides

16:00-17:00 OH (JN)
MGH 286

23:00 WQ5 due: XML
12
16:00-17:00 OH (MM)
MGH 286
13
11:00-12:00 OH (YP)
MGH 286

13:30-14:20 Lecture
JHN 102
20. Theory (concl.); Views
Slides

16:00-17:00 OH (SX)
MGH 286

23:00 HW5 due: XML
14
Section
7. Database design
slides problems sample solutions

16:00-17:00 OH (HU)
MGH 286
15
11:00-12:00 OH (YW)
MGH 286

13:30-14:20 Lecture
JHN 102
21. Views (concl.); Transactions Intro
Sqlite Notes

18
13:30-14:20 Lecture
JHN 102
22. Transactions I (18.1-18.3)
Slides

16:00-17:00 OH (JN)
MGH 286

23:00 WQ6 due: Conceptual Design
19
16:00-17:00 OH (MM)
MGH 286
20
11:00-12:00 OH (YP)
MGH 286

13:30-14:20 Lecture
JHN 102
23. Transactions II (18.3-18.4, 6.6)
Slides

16:00-17:00 OH (SX)
MGH 286

23:00 HW6 due: Conceptual Design
21
Section
8. Database application programming
slides helloDatabase.java

16:00-17:00 OH (HU)
MGH 286
22
11:00-12:00 OH (YW)
MGH 286

13:30-14:20 Lecture
JHN 102
24. Transactions (concl.); Parallel Databases (start)
Slides

25
Memorial Day
26
16:00-17:00 OH (MM)
MGH 286
27
11:00-12:00 OH (YP)
MGH 286

13:30-14:20 Lecture
JHN 102
25. Parallel Databases - MapReduce
Slides

16:00-17:00 OH (SX)
MGH 286
28
Section
9. Hadoop / Pig Latin / AWS & HW8

16:00-17:00 OH (HU)
MGH 286

23:00 HW7 due: DB Application
29
11:00-12:00 OH (YW)
MGH 286

13:30-14:20 Lecture
JHN 102
26. Parallel Databases - MapReduce, PigLatin
Slides Pig examples

23:00 WQ7 due: Transactions

June

Monday Tuesday Wednesday Thursday Friday

01
13:30-14:20 Lecture
JHN 102
27. Parallel Databases - Parallel SQL & Wrapup
Slides

16:00-17:00 OH (JN)
MGH 286
02
16:00-17:00 OH (MM)
MGH 286
03
11:00-12:00 OH (YP)
MGH 286

13:30-14:20 Lecture
JHN 102
28. Parallel Databases - Wrapup; NoSQL
Slides

16:00-17:00 OH (SX)
MGH 286
04
Section
10. Wrapup and review
slides problems sample solutions

16:00-17:00 OH (HU)
MGH 286
05
11:00-12:00 OH (YW)
MGH 286

13:30-14:20 Lecture
JHN 102
30. NoSQL (concl.); Final Review
Slides

23:00 HW8 due: Pig Latin No Late Days

08
Final Q&A Session SUNDAY 2PM (slides)
SAV 260

14:30-16:20 Final exam
09 10 11 12

March
Monday	Tuesday	Wednesday	Thursday	Friday
30 13:30-14:20 Lecture JHN 102 1. Introduction Slides	31	01 13:30-14:20 Lecture JHN 102 2. Data Models (2.1-2.3) Sqlite notes	02 Section 1. Intro to SQLite slides problems	03 13:30-14:20 Lecture JHN 102 3. SQL (6.1, 6.2) Sqlite notes (Sqlite supplement)

April
Monday	Tuesday	Wednesday	Thursday	Friday
06 13:30-14:20 Lecture JHN 102 4. SQL - Aggregates (6.3, 6.4) Slides, Sqlite notes, lec04-data.txt 16:30-17:30 OH (JN) CSE 021 23:00 WQ1 due: sql (basic)	07 16:00-17:00 OH (MM) MGH 286	08 11:00-12:00 OH (YP) MGH 286 13:30-14:20 Lecture JHN 102 5. SQL - Aggregates (6.3, 6.4) (concl.) 16:00-17:00 OH (SX) MGH 286 23:00 HW1 due: sqlite	09 Section 2. More SQL - Aggregates slides problems sample solutions 16:00-17:00 OH (HU) MGH 286	10 11:00-12:00 OH (YW) MGH 286 13:30-14:20 Lecture JHN 102 6. Basic Query Evaluation, Indexes (14.1) Slides
13 13:30-14:20 Lecture JHN 102 7. SQL - Nested Queries (6.3) Slides Sqlite notes, Additional notes 16:00-17:00 OH (JN) MGH 286 23:00 WQ2 due: sql (aggregates)	14 16:00-17:00 OH (MM) MGH 286	15 11:00-12:00 OH (YP) MGH 286 13:30-14:20 Lecture JHN 102 8. SQL Wrapup (6.3, 2.4); System Arch. SQL Slides, Arch. Slides 16:00-17:00 OH (SX) MGH 286 23:00 HW2 due: Basic SQL	16 Section 3. SQL Azure & nested queries slides sample sql azure queries problems sample solutions 16:00-17:00 OH (HU) MGH 286	17 11:00-12:00 OH (YW) MGH 286 13:30-14:20 Lecture JHN 102 9. Relational Algebra (2.4, 5.1, 5.2) Slides
20 13:30-14:20 Lecture JHN 102 10. Relational Algebra (cont.) 16:00-17:00 OH (JN) MGH 286 23:00 WQ3 due: sql (nested)	21 16:00-17:00 OH (MM) MGH 286	22 11:00-12:00 OH (YP) MGH 286 13:30-14:20 Lecture JHN 102 11. Relational Algebra (concl.); Query Impl. (15.1-15.6) Slides 16:00-17:00 OH (SX) MGH 286 23:00 HW3 due: Advanced SQL	23 Section 4. Relational algebra slides problems sample solutions 16:00-17:00 OH (HU) MGH 286	24 11:00-12:00 OH (YW) MGH 286 13:30-14:20 Lecture JHN 102 12. Query Implementation
27 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 (JN) MGH 286 23:00 WQ4 due: Relational algebra & query execution	28 16:00-17:00 OH (MM) MGH 286	29 11:00-12:00 OH (YP) MGH 286 13:30-14:20 Lecture JHN 102 13. XPath (concl.) 16:00-17:00 OH (SX) MGH 286 23:00 HW4 due: Relational Algebra & Query Execution	30 Section 5. Midterm review 16:00-17:00 OH (HU) MGH 286	01 11:00-12:00 OH (YW) MGH 286 13:30-14:20 Lecture JHN 102 14. XQuery (12.2) Slides

June
Monday	Tuesday	Wednesday	Thursday	Friday
01 13:30-14:20 Lecture JHN 102 27. Parallel Databases - Parallel SQL & Wrapup Slides 16:00-17:00 OH (JN) MGH 286	02 16:00-17:00 OH (MM) MGH 286	03 11:00-12:00 OH (YP) MGH 286 13:30-14:20 Lecture JHN 102 28. Parallel Databases - Wrapup; NoSQL Slides 16:00-17:00 OH (SX) MGH 286	04 Section 10. Wrapup and review slides problems sample solutions 16:00-17:00 OH (HU) MGH 286	05 11:00-12:00 OH (YW) MGH 286 13:30-14:20 Lecture JHN 102 30. NoSQL (concl.); Final Review Slides 23:00 HW8 due: Pig Latin No Late Days
08 Final Q&A Session SUNDAY 2PM (slides) SAV 260 14:30-16:20 Final exam	09	10	11	12