CSE 414 Autumn 2018
Course Calendar

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

 Show color key

September
SundayMondayTuesdayWednesdayThursdayFridaySaturday
23 24 25 26
10:30-11:20 OH (Eric)
CSE 023
11:30-12:20 OH (Josh)
CSE 007
15:30-16:20 Lecture
EXED 110
Introduction (large)(small)
27
Section
Git setup, Sqlite Slides
11:00-12:00 OH (Ryan)
CSE 214
11:30-12:20 OH (Rob)
CSE 007
28
13:00-15:00 OH (Ian)
CSE 023
15:30-16:20 Lecture
EXED 110
Unit 2 Relational Data Model (Textbook sections 2.1-3) (large)(small) demo in sqlite
29
30 01
11:00-12:00 OH (Josh)
CSE 021
13:00-14:00 OH (Kodiak)
CSE 007
15:30-16:20 Lecture
EXED 110
SQL Basics (6.1-2) (large)(small) demo in sqlite
02
11:00-12:00 OH (Ryan)
CSE 214
11:00-12:00 OH (Ryan)
CSE 214
12:00-15:00 OH (Andrew)
5th floor breakout
15:00-17:00 OH (Daniel)
CSE 023
23:00 HW1: SQLite (1 wk)
03
10:30-11:20 OH (Eric)
CSE 023
11:30-12:20 OH (Josh)
CSE 007
15:30-16:20 Lecture
EXED 110
Aggregates (6.3-4) (large)(small) demo in sqlite
04
Section
A SeQueL to SQL Slides, Worksheet Solutions
11:00-12:00 OH (Ryan)
CSE 214
11:30-12:20 OH (Rob)
CSE 007
05
13:00-15:00 OH (Ian)
CSE 023
15:30-16:20 Lecture
EXED 110
Aggregates (6.3-4) (large)(small) demo in sqlite
22:00-23:00 WQ1: Simple SQL
06

October
SundayMondayTuesdayWednesdayThursdayFridaySaturday
07 08
11:00-12:00 OH (Josh)
CSE 021
13:00-14:00 OH (Kodiak)
CSE 007
15:30-16:20 Lecture
EXED 110
SQL Subqueries (6.3) (large)(small) demo in sqlite
09
11:00-12:00 OH (Ryan)
CSE 214
12:00-15:00 OH (Andrew)
5th floor breakout
15:00-17:00 OH (Daniel)
CSE 023
23:00 HW2: SQL basics (1 wk)
10
10:30-11:20 OH (Eric)
CSE 023
11:30-12:20 OH (Josh)
CSE 007
15:30-16:20 Lecture
EXED 110
SQL wrap-up, Relational algebra (2.4 & 5.1) (large)(small)
11
Section
Azure, Grouping, and Nesting Slides, Worksheet Solutions
11:00-12:00 OH (Ryan)
CSE 214
11:30-12:20 OH (Rob)
CSE 007
12
11:30-14:30 OH (Ian)
2nd floor breakout
13:00-15:00 OH (Ian)
CSE 023
15:30-16:20 Lecture
EXED 110
More relational algebra (2.4 & 5.1) (large)(small)
22:00-23:00 WQ2: SQL Aggregates
13
14 15
11:00-12:00 OH (Josh)
CSE 021
13:00-14:00 OH (Kodiak)
CSE 007
15:30-16:20 Lecture
EXED 110
Datalog (5.3-5.4) (large)(small)
16
11:00-12:00 OH (Ryan)
CSE 214
12:00-15:00 OH (Andrew)
5th floor breakout
15:00-17:00 OH (Daniel)
CSE 023
22:00-23:00 WQ3: SQL Nested Queries
17
10:30-11:20 OH (Eric)
CSE 023
11:30-12:20 OH (Josh)
CSE 007
15:30-16:20 Lecture
EXED 110
Datalog (5.3-5.4) (large)(small)
18
Section
Relational Algebra and Datalog Slides, Worksheet, Solutions
11:00-12:00 OH (Ryan)
CSE 214
11:30-12:20 OH (Rob)
CSE 007
19
13:00-15:00 OH (Ian)
CSE 023
15:30-16:20 Lecture
EXED 110
Unit 3 NoSQL, JSON, SQL++ (large)(small)
23:00 HW3: Advanced SQL and running SQL Azure (1 2/3 wk)
20
21 22
11:00-12:00 OH (Josh)
CSE 021
15:30-16:20 Lecture
EXED 110
JSon and SQL++ (large)(small)
23
9:30-10:30 OH (Ryan)
CSE 214
16:30-18:30 OH (Daniel)
CSE 220
22:00-23:00 WQ4: Relational Algebra
24
10:30-11:20 OH (Eric)
3rd floor breakout
11:30-12:20 OH (Josh)
CSE 007
13:30-14:30 OH (Kodiak)
CSE 007
15:30-16:20 Lecture
EXED 110
SQL++ (large)(small)
25
Section
Datalog and Midterm Review Practice Exam, Solutions
11:00-12:00 OH (Ryan)
CSE 214
11:30-12:20 OH (Rob)
CSE 007
26
13:00-15:00 OH (Ian)
CSE 023
15:30-16:20 Lecture
EXED 110
SQL++ Wrapup (large)(small)
18:00-21:00 OH (Andrew)
4th floor breakout
27
28 29
11:00-12:00 OH (Josh)
CSE 021
13:00-14:00 OH (Kodiak)
CSE 007
15:30-16:20 Lecture
EXED 110
Unit 4 From RA to Query Evaluation (5.2 & 16.3, skim 16.3.2) (large)(small)
30
11:00-12:00 OH (Ryan)
CSE 214
12:00-15:00 OH (Andrew)
5th floor breakout
15:00-17:00 OH (Daniel)
CSE 023
22:00-23:00 WQ5: Datalog
23:00 HW4: Datalog and Relational Algebra(1 1/3 wk)
31
10:30-11:20 OH (Eric)
CSE 023
11:30-12:20 OH (Josh)
CSE 007
15:30-16:20 Midterm
01
Section
SQL++ and AsterixDB HW5 Guide, Slides, Worksheet Solutions
11:00-12:00 OH (Ryan)
CSE 214
11:30-12:20 OH (Rob)
CSE 007
02
13:00-15:00 OH (Ian)
CSE 023
15:30-16:20 Lecture
EXED 110
Storage & Indexing Basics (8.3-4 & 14.1-1.7 & skim 14.2-3) (large)(small)
03

November
SundayMondayTuesdayWednesdayThursdayFridaySaturday
04 05
11:00-12:00 OH (Josh)
CSE 021
13:00-14:00 OH (Kodiak)
CSE 007
15:30-16:20 Lecture
EXED 110
Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5) (large)(small)
06
10:00-12:00 OH (Kodiak)
Foster Study Room 2
11:00-12:00 OH (Ryan)
CSE 214
12:00-15:00 OH (Andrew)
5th floor breakout
15:00-17:00 OH (Daniel)
CSE 220
07
10:30-11:20 OH (Eric)
CSE 023
10:30-11:20 OH (Eric)
CSE 007
11:30-12:20 OH (Josh)
CSE 007
15:30-16:20 Lecture
EXED 110
Unit 5 Parallel Databases (20.1) From RA to Query Evaluation (5.2 & 16.3, skim 16.3.2) (large)(small)
23:00 HW5: NoSQL (SQL++) (1 wk)
08
Section
Cost of Query Plans, Spark Slides
11:00-12:00 OH (Ryan)
CSE 214
11:30-12:20 OH (Rob)
CSE 007
09
11:30-17:00 OH (Ian)
CSE 023
15:30-16:20 Lecture
EXED 110
More Parallel Databases (large)(small)
10
11 12
Veteran's Day*
13
11:00-12:00 OH (Ryan)
CSE 214
12:00-15:00 OH (Andrew)
5th floor breakout
15:00-17:00 OH (Daniel)
CSE 023
14
10:30-11:20 OH (Eric)
CSE 023
11:30-12:20 OH (Josh)
CSE 007
15:30-16:20 Lecture
EXED 110
Introduction to Spark (no reading) (large)(small)
15
Section
Spark, Exam Review
11:00-12:00 OH (Ryan)
CSE 214
11:30-12:20 OH (Rob)
CSE 007
16
13:00-15:00 OH (Ian)
CSE 023
15:30-16:20 Lecture
EXED 110
More Spark (no reading) (large)(small)
17
18 19
11:00-12:00 OH (Josh)
CSE 021
13:00-14:00 OH (Kodiak)
CSE 007
15:30-16:20 Lecture
EXED 110
Unit 6 E/R Diagrams and Constraints (4.1-4.6) (large)(small)
20
11:00-12:00 OH (Ryan)
CSE 214
12:00-15:00 OH (Andrew)
5th floor breakout
15:00-17:00 OH (Daniel)
CSE 023
23:00 HW6: Spark and running on AWS (2 wk)
21
10:30-11:20 OH (Eric)
CSE 023
11:30-12:20 OH (Josh)
CSE 007
15:30-16:20 Lecture
EXED 110
Design Theory (3.1-3.4) (large)(small)
22
Thanksgiving
23
Fri. after Thanksgiving
24
25 26
13:00-14:00 OH (Kodiak)
CSE 007
15:30-16:20 Lecture
EXED 110
BCNF (3.1-3.4) (large)(small)
27
11:00-12:00 OH (Ryan)
CSE 214
12:00-15:00 OH (Andrew)
5th floor breakout
15:00-17:00 OH (Daniel)
CSE 023
28
10:30-11:20 OH (Eric)
CSE 023
11:30-12:20 OH (Josh)
CSE 007
15:30-16:20 Lecture
EXED 110
Unit 7 Introduction to Transactions (18.1) Description BCNF (3.1-3.4) (large)(small)
29
Section
Schema Design, BCNF Slides Worksheet, Solutions
11:00-12:00 OH (Ryan)
CSE 214
11:30-12:20 OH (Rob)
CSE 007
30
13:00-15:00 OH (Ian)
CSE 023
15:30-16:20 Lecture
EXED 110
More Transactions (18.1-3) (large)(small)
22:00-23:00 WQ6: Conceptual Design
23:00 HW7: Schema design + index tuning + cost estimation (1 wk)
01

December
SundayMondayTuesdayWednesdayThursdayFridaySaturday
02 03
11:00-12:00 OH (Josh)
CSE 021
13:00-14:00 OH (Kodiak)
CSE 007
15:30-16:20 Lecture
EXED 110
Transaction Implementations (18.1-3) (large)(small)
04
11:00-12:00 OH (Ryan)
CSE 214
11:00-13:00 OH (Kodiak)
Foster Library Study Room 11
12:00-15:00 OH (Andrew)
5th floor breakout
15:00-17:00 OH (Daniel)
CSE 023
05
10:30-11:20 OH (Eric)
CSE 023
11:30-12:20 OH (Josh)
CSE 007
15:30-16:20 Lecture
EXED 110
Transactions Wrapup (large)(small)
06
Section
Transactions and HW8 Worksheet, Solutions
11:00-12:00 OH (Ryan)
CSE 214
11:30-12:20 OH (Rob)
CSE 007
22:00-23:00 WQ7: Transactions
07
13:00-15:00 OH (Ian)
CSE 023
15:30-16:20 Lecture
EXED 110
Final Review (large)(small)
18:00-20:00 OH (Andrew)
4th Floor Breakout
08
23:00 HW8: JDBC application (1.5 wk)
09 10 11 12 13
14:30-16:20 Final exam
14 15