See Canvas for the full
list of lecture and section recordings
Subscribe to this calendar (Google, iCal, etc.)
| September | ||||
|---|---|---|---|---|
| Monday | Tuesday | Wednesday | Thursday | Friday |
| 22 | 23 | 24
09:30-10:20 Lecture
IEB G109 Introduction (Syllabus + Relational Model) Textbook sections 2.1-2.3 Slides, Video
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout |
25 | 26
09:30-10:20 Lecture
IEB G109 SQL Basics (SELECT-FROM-WHERE, nested-loop semantics) Textbook sections 6.1-6.2 Slides, Demo, Video
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152 |
| 29
09:30-10:20 Lecture
IEB G109 SQL Joins (Inner Joins) Same textbook sections (6.1-6.2) Slides, Demo, Video
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout |
30
10:00-11:00 Lydia Support Hrs
Allen (CSE1) 5th fl breakout
16:00-17:00 Kevin + Stanley Support Hrs
Allen (CSE1) 4th fl breakout
22:00 HW1 (Intro to SQL and SQLite) due
|
01
09:30-10:20 Lecture
IEB G109 SQL Joins (Outer Joins and NULL) Same textbook sections (6.1-6.2) Slides, Demo, Video
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout |
02 | 03
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152 |
| October | ||||
|---|---|---|---|---|
| Monday | Tuesday | Wednesday | Thursday | Friday |
| 06
09:30-10:20 Lecture
IEB G109 SQL Aggregates with Joins; Data in Context SQL Slides, Context Slides, Video
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout |
07
10:00-11:00 Lydia Support Hrs
Allen (CSE1) 5th fl breakout
16:00-17:00 Kevin + Stanley Support Hrs
Allen (CSE1) 4th fl breakout
22:00 HW2 (Basic SQL Queries) due
(direct link to flights schema documentation) |
08
09:30-10:20 Lecture
IEB G109 SQL Subqueries Textbook section 6.3 Slides, SUPPLEMENTAL Slides (witnessing problem as a self-join), Video
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout |
09 | 10
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152 |
| 13
09:30-10:20 Lecture
IEB G109 SQL Subqueries (cont.); SQL Query Patterns Same textbook section (6.3) Subquery Slides, Query Patterns Slides, Video
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout |
14
10:00-11:00 Lydia Support Hrs
Allen (CSE1) 5th fl breakout
16:00-17:00 Kevin + Stanley Support Hrs
Allen (CSE1) 4th fl breakout
22:00 HW3 (Advanced SQL Queries) due
(direct link to setup documentation) |
15
09:30-10:20 Lecture
IEB G109 Design: Entities, Relationships, and ER Diagrams Textbook sections 4.1-4.6 Slides, Video
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout |
16 | 17
09:30-10:20 Lecture
IEB G109 Design: Entities, Relationships, and ER Diagrams (cont.); Design: Design Theory and Normalization Same textbook sections (4.1-4.6) for ER Diagrams; sections 3.1-3.5 for Design Theory ER Slides, Normalization Slides, Video
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152 |
| 20
09:30-10:20 Lecture
IEB G109 Design: Design Theory and Normalization (cont.) Same textbook sections (3.1-3.5) Slides, Video
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout |
21
10:00-11:00 Lydia Support Hrs
Allen (CSE1) 5th fl breakout
16:00-17:00 Kevin + Stanley Support Hrs
Allen (CSE1) 4th fl breakout |
22
09:30-10:20 Lecture
IEB G109 Design: Design Theory and Normalization (cont.); Design: Physical Design and Indexes Textbook sections 13.1-13.2; 14.1-14.2; 8.3-8.4.3 (design) Slides, Supplemental B+-tree Slides, Video
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout |
23 | 24
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152
22:00 Take-home Midterm due
|
| 27
09:30-10:20 Lecture
IEB G109 Design: Physical Design and Indexes (cont.); Database Applications; Password Handling DRAFT Design Slides, DRAFT DB Apps Slides, DRAFT PW Handling Slides
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout |
28
10:00-11:00 Lydia Support Hrs
Allen (CSE1) 5th fl breakout
16:00-17:00 Kevin + Stanley Support Hrs
Allen (CSE1) 4th fl breakout
22:00 HW4 (Design Theory) due
|
29
09:30-10:20 Lecture
IEB G109 Query Execution: Relational Algebra Textbook sections 2.4; 5.1-5.2 (execution)
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin Support Hrs
Allen (CSE1) 220 |
30
Section
Relational Algebra, Prepared Statements, and SQL Injection |
31
09:30-10:20 Lecture
IEB G109 Query Execution: Relational Algebra (cont.) Same textbook sections (2.4; 5.1-5.2)
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152 |
| November | ||||
|---|---|---|---|---|
| Monday | Tuesday | Wednesday | Thursday | Friday |
| 03
09:30-10:20 Lecture
IEB G109 Query Execution: Cardinality Estimation Textbook sections 16.1-16.4
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout |
04
10:00-11:00 Lydia Support Hrs
Allen (CSE1) 5th fl breakout
16:00-17:00 Kevin + Stanley Support Hrs
Allen (CSE1) 4th fl breakout
22:00 HW5 (Query Execution) and FlightApp Project: M0 due
|
05
09:30-10:20 Lecture
IEB G109 Query Execution: Physical Algorithms; Pipelining Textbook sections 15.1-15.4; 15.6.1-15.6.2
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout |
06
Section
Cardinality Estimation and Join Algorithms |
07
09:30-10:20 Lecture
IEB G109 Query Execution: Physical Algorithms; Pipelining (cont.) Same Textbook sections (15.1-15.4; 15.6.1-15.6.2)
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152 |
| 10
09:30-10:20 Lecture
IEB G109 Transactions: Basics Textbook section 18.1-18.4
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout |
11
Veteran's Day
|
12
09:30-10:20 Lecture
IEB G109 Transactions: Serializability Same textbook sections (18.1-18.4)
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout
22:00 FlightApp Project: M1 due
|
13
Section
Transactions, Serializability |
14
09:30-10:20 Lecture
IEB G109 Transactions: Locking Same textbook sections (18.1-18.4)
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152 |
| 17
09:30-10:20 Lecture
IEB G109 Transactions: Locking (cont.); Data Governance Same textbook sections (18.1-18.4); NYT Taxicab post
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout |
18
10:00-11:00 Lydia Support Hrs
Allen (CSE1) 5th fl breakout
16:00-17:00 Kevin + Stanley Support Hrs
Allen (CSE1) 4th fl breakout
22:00 FlightApp Project: M2 due
|
19
09:30-10:20 Lecture
IEB G109 Partitioning and Parallel Query Execution 20.1; 20.3-20.4.2
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout |
20
Section
Locking, Data Governance, and Parallel DBs |
21
09:30-10:20 Lecture
IEB G109 Parallel Query Execution (cont.); NoSQL: Intro Same textbook sections (20.1; 20.3-20.4.2)
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152 |
| 24
09:30-10:20 Lecture
IEB G109 NoSQL: Key/Value Stores; NoSQL: Document Stores
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout |
25
10:00-11:00 Lydia Support Hrs
Allen (CSE1) 5th fl breakout
16:00-17:00 Kevin + Stanley Support Hrs
Allen (CSE1) 4th fl breakout
22:00 HW6 (Transactions and Society) due
|
26
09:30-10:20 Lecture
IEB G109 NoSQL: Document Stores (cont.); NoSQL: Wide Column
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout |
27
Thanksgiving
|
28
Native American Heritage Day
|
| December | ||||
|---|---|---|---|---|
| Monday | Tuesday | Wednesday | Thursday | Friday |
| 01
15:30-16:20 Rudra + Hannah Support Hrs
Allen (CSE1) 5th fl breakout |
02
10:00-11:00 Lydia Support Hrs
Allen (CSE1) 5th fl breakout
16:00-17:00 Kevin + Stanley Support Hrs
Allen (CSE1) 4th fl breakout |
03
09:30-10:20 Lecture
IEB G109 NoSQL: Wide Column (cont.); NoSQL Conclusion
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 210
15:30-16:20 Kevin + Sumedh Support Hrs
Allen (CSE1) 3rd fl breakout |
04
Section
NoSQL and Office Hours |
05
09:30-10:20 Lecture
IEB G109 Course Conclusion
16:00-17:00 Stanley Support Hrs
Gates (CSE2) 152
22:00 HW7 (NoSQL Design) due
|
| 08 | 09 | 10
10:20 Take-home Final due
|
11 | 12 |