DATA 514 Winter 2019
Course Calendar

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

 Show color key

January
MondayTuesdayWednesdayThursdayFriday
07 08
14:00-15:00 OH by appointment (Mark)
CSE 264
17:00-20:50 Lecture
JHN 111
1. Intro, Data models, SQL (Basic)
Slides
20:00-20:50 Section
JHN 111
Sqlite practice
Slides Sqlite Solution
09 10 11
14
23:59 WQ1 due: Introduction, Data Models, and Simple SQL
23:59 HW1 due: Sqlite
15
14:00-15:00 OH by appointment (Mark)
CSE 264
17:00-20:50 Lecture
JHN 111
2. Join and Aggregates in SQL
Slides
20:00-20:50 Section
JHN 111
Sqlite practice
Excercise Slides Solutions
16 17 18
21
Martin Luther King Jr. Day
23:59 WQ2 due: SQL Aggregates
23:59 HW2 due: Basic SQL
22
14:00-15:00 OH by appointment (Mark)
CSE 264
17:00-20:50 Lecture
JHN 111
3. SQL (Cont.)
Slides
20:00-20:50 Section
JHN 111
Advanced SQL
Slides Excercise Solutions
23 24 25
28
16:00-17:00 OH (Shrainik)
CSE 370
23:59 WQ3 due: Nested Queries in SQL
29
14:00-15:00 OH by appointment (Mark)
CSE 264
17:00-20:50 Lecture
JHN 111
4. Query Execution and Indexes
Slides-1 Slides-2
20:00-20:50 Section
JHN 111
Advanced SQL (Cont.)
Excercise Solutions
30 31 01

February
MondayTuesdayWednesdayThursdayFriday
04
16:00-17:00 OH (Shrainik)
CSE 370
23:59 HW3 due: Advanced SQL
23:59 WQ4 due: Relational Algebra
05
14:00-15:00 OH by appointment (Mark)
CSE 264
17:00-19:00 Midterm
17:00-20:50 Lecture
JHN 111
5. RDMBS internals
Slides
06 07 08
11
16:00-17:00 OH (Shrainik)
CSE 370
12
14:00-15:00 OH by appointment (Mark)
CSE 264
17:00-20:50 Lecture
JHN 111
6. RDMBS internals (cont.)
Slides
20:00-20:50 Section
JHN 111
Conceptual Designs
13 14 15
18
Presidents Day
23:59 WQ5 due: Conceptual Design
19
14:00-15:00 OH by appointment (Mark)
CSE 264
17:00-20:50 Lecture
JHN 111
7. Transactions
Slides
20
23:59 HW4 due: Entity Relationship Diagrams and Query Plans
21 22
25
16:00-17:00 OH (Shrainik)
CSE 370
26
14:00-15:00 OH by appointment (Mark)
CSE 264
17:00-20:50 Lecture
JHN 111
8. NoSQL
Slides
27 28 01

March
MondayTuesdayWednesdayThursdayFriday
04
16:00-17:00 OH (Shrainik)
CSE 370
23:59 HW5 due: Database Application and Transaction Management
05
14:00-15:00 OH by appointment (Mark)
CSE 264
17:00-20:50 Lecture
JHN 111
9. TBD
06 07 08
11
16:00-17:00 OH (Shrainik)
CSE 370
23:59 HW6 due: JSON, NoSQL, and AsterixDB
23:59 WQ6 due: Transaction Management
12
14:00-15:00 OH by appointment (Mark)
CSE 264
13 14 15
18 19
17:00-19:00 Final exam
20 21 22