See Canvas for the
full list of lecture and section recordings
Subscribe to this calendar (Google, iCal, etc.)
March | ||||||
---|---|---|---|---|---|---|
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
30 | 31 | 01 | 02
09:30-10:20 Lecture
MGH 389 SQL Basics (SELECT-FROM-WHERE, nested-loop semantics) Textbook sections 6.1-6.2 Slides, Video, Demo
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214 |
03
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout |
04
8:30-9:20 Khushi Support Hrs
Gates (CSE2) 121
09:30-10:20 Lecture
MGH 389 SQL Joins (Inner Joins) Same textbook sections (6.1-6.2) Slides, Video, Demo
12:00-13:00 Hannah Support Hrs
Allen (CSE1) 5th Fl. Breakout |
05 |
April | ||||||
---|---|---|---|---|---|---|
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
06 | 07
09:30-10:20 Lecture
MGH 389 Slides, Video
12:30-13:20 Maria Support Hrs
Allen (CSE1) 4th Fl. Breakout
15:00-16:20 Ananya Support Hrs
Gates (CSE2) 131 |
08
14:30-15:20 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
15:30-17:00 Lydia Support Hrs
Allen (CSE1) 5th Fl. Breakout
22:00 HW1 (Intro to SQL and SQLite) due
|
09
09:30-10:20 Lecture
MGH 389 Slides, Video, Demo
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
15:00-16:00 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout |
10
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout |
11
8:30-9:20 Khushi Support Hrs
Gates (CSE2) 121 |
12 |
13 | 14
09:30-10:20 Lecture
MGH 389 Data in Context; SQL Subqueries Textbook section 6.3 Context Slides, Subqueries Slides, Video
12:30-13:20 Maria Support Hrs
Allen (CSE1) 4th Fl. Breakout
13:30-14:20 Hannah Support Hrs
Allen (CSE1) 4th Fl. Breakout
15:00-16:20 Ananya Support Hrs
Gates (CSE2) 131 |
15
14:30-15:20 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
15:30-17:00 Lydia Support Hrs
Allen (CSE1) 5th Fl. Breakout
22:00 HW2 (Basic SQL Queries) due (schema documentation)
|
16
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
15:00-16:00 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout |
17
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout |
18
8:30-9:20 Khushi Support Hrs
Gates (CSE2) 121
09:30-10:20 Lecture
MGH 389 SQL Query Patterns; Design: Entities, Relationships, and ER Diagrams Textbook sections 4.1-4.6 Query Pattern Slides, Design Slides, Video |
19 |
20 | 21
09:30-10:20 Lecture
MGH 389 Design: Entities, Relationships, and ER Diagrams (cont.) Same textbook sections (4.1-4.6) Slides, Video
12:30-13:20 Maria Support Hrs
Allen (CSE1) 4th Fl. Breakout
13:30-14:20 Hannah Support Hrs
Allen (CSE1) 4th Fl. Breakout
15:00-16:20 Ananya Support Hrs
Gates (CSE2) 131 |
22
14:30-15:20 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
15:30-17:00 Lydia Support Hrs
Allen (CSE1) 5th Fl. Breakout
22:00 HW3 (Advanced SQL Queries) due
|
23
09:30-10:20 Lecture
MGH 389 Design: Design Theory and Normalization Textbook sections 3.1-3.5 Slides, Video
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
15:00-16:00 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout |
24
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout
22:00 Quiz 1 due
|
25
8:30-9:20 Khushi Support Hrs
Gates (CSE2) 121 |
26 |
27 | 28
09:30-10:20 Lecture
MGH 389 Design: Physical Design and Indexes; Query Execution: Relational Algebra Textbook sections 13.1-13.2; 14.1-14.2; 8.3-8.4.3 (design); sections 2.4; 5.1-5.2 (execution) Design Slides, Execution Slides, Video, Handout
12:30-13:20 Maria Support Hrs
Allen (CSE1) 4th Fl. Breakout
13:30-14:20 Hannah Support Hrs
Allen (CSE1) 4th Fl. Breakout
15:00-16:20 Ananya Support Hrs
Gates (CSE2) 131 |
29
14:30-15:20 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
15:30-17:00 Lydia Support Hrs
Allen (CSE1) 5th Fl. Breakout
22:00 HW4 (Database Design) due
|
30
09:30-10:20 Lecture
MGH 389 GUEST LECTURE: Query Execution: Relational Algebra (cont.) Same textbook sections (2.4; 5.1-5.2) Slides, Video
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
15:00-16:00 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout |
01
Section
Relational Algebra, Indexing, and Prepared Statements Slides, Worksheet, Worksheet Solutions, Demo
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout |
02
8:30-9:20 Khushi Support Hrs
Gates (CSE2) 121 |
03 |
May | ||||||
---|---|---|---|---|---|---|
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
04 | 05
09:30-10:20 Lecture
MGH 389 GUEST LECTURE: Database Applications; Password Handling DRAFT DB Apps Slides, DRAFT Password Slides, Video
12:30-13:20 Maria Support Hrs
Allen (CSE1) 4th Fl. Breakout
13:30-14:20 Hannah Support Hrs
Allen (CSE1) 4th Fl. Breakout
15:00-16:20 Ananya Support Hrs
Gates (CSE2) 131 |
06
14:30-15:20 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
15:30-17:00 Lydia Support Hrs
Allen (CSE1) 5th Fl. Breakout |
07
09:30-10:20 Lecture
MGH 389 Query Execution: Physical Algorithms; Pipelining Textbook sections 15.1-15.4; 15.6.1-15.6.2 Slides, Video
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
15:00-16:00 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout |
08
Section
Cardinality Estimation, SQL Injection, and Join Algorithms Slides, Demo, Worksheet, Worksheet Solutions
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout |
09
8:30-9:20 Khushi Support Hrs
Gates (CSE2) 121 |
10 |
11 | 12
12:30-13:20 Maria Support Hrs
Allen (CSE1) 4th Fl. Breakout
13:30-14:20 Hannah Support Hrs
Allen (CSE1) 4th Fl. Breakout
15:00-16:20 Ananya Support Hrs
Gates (CSE2) 131 |
13
14:30-15:20 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
15:30-17:00 Lydia Support Hrs
Allen (CSE1) 5th Fl. Breakout |
14
09:30-10:20 Lecture
MGH 389 Transactions: Serializability Same textbook sections (18.1-18.4) Slides, Video
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
15:00-16:00 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
22:00 Quiz 2 due
|
15
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout |
16
8:30-9:20 Khushi Support Hrs
Gates (CSE2) 121
12:30-14:00 Khushi: β¨ Extra Support Hrs β¨
Allen (CSE1) 3rd Fl. Breakout
14:00-15:00 Hannah: π Extra Support Hrs π
Allen (CSE1) 214
22:00 Project (Flights Application) M1 due (setup and testing documentation)
|
17 |
18 | 19
09:30-10:20 Lecture
MGH 389 Transactions: Locking (cont.); Data Governance Same textbook sections (18.1-18.4); NYT Taxicab post Transactions Slides, Governance Slides, Video
12:30-13:20 Maria Support Hrs
Allen (CSE1) 4th Fl. Breakout
13:30-14:20 Hannah Support Hrs
Allen (CSE1) 4th Fl. Breakout
15:00-16:20 Ananya Support Hrs
Gates (CSE2) 131 |
20
14:30-15:20 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
15:30-17:00 Lydia Support Hrs
Allen (CSE1) 5th Fl. Breakout |
21
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
15:00-16:00 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout |
22
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout |
23
09:30-10:20 Lecture
MGH 389 Parallel Query Execution (cont.); NoSQL: Intro Same textbook sections (20.1; 20.3-20.4.2) Query Execution Slides, NoSQL Slides, Video
11:00-12:00 Kevin: π Extra Support Hrs π
Allen (CSE1) 5th Fl. Breakout
12:00-13:00 Hannah: π€© Extra Support Hrs π€©
Allen (CSE1) 5th Fl. Breakout
13:00-14:00 Ananya: πΆExtra Support HrsπΆ
Allen (CSE1) 3rd Fl. Breakout
22:00 Project (Flights Application) M2 due (setup and testing documentation)
|
24 |
25 | 26
Memorial Day
|
27
14:30-15:20 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout |
28
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
15:00-16:00 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
22:00 Quiz 3 due
|
29
11:30-12:20 Khushi: Support Hrs
Gates (CSE2) 153
14:00-15:00 Lydia: Support Hrs
Allen (CSE1) 5th Fl. Breakout
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout |
30
11:30-12:20 Amal: π Extra Support Hrs π
Allen (CSE1) 5th Fl. Breakout
12:30-11:20 Hannah: π Extra Support Hrs π
Allen (CSE1) 214
22:00 HW6 (Transactions and Society) due
|
31 |
June | ||||||
---|---|---|---|---|---|---|
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
01 | 02
12:30-13:20 Maria Support Hrs
Allen (CSE1) 4th Fl. Breakout
13:30-14:20 Hannah Support Hrs
Allen (CSE1) 4th Fl. Breakout
15:00-16:20 Ananya Support Hrs
Gates (CSE2) 131 |
03
14:30-15:20 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout
15:30-17:00 Lydia Support Hrs
Allen (CSE1) 5th Fl. Breakout |
04
12:30-13:20 Hannah Support Hrs
Allen (CSE1) 214
15:00-16:00 Amal Support Hrs
Allen (CSE1) 5th Fl. Breakout |
05
15:00-16:00 Kevin + Sumedh Support Hrs
Allen (CSE1) 5th Fl. Breakout |
06
8:30-9:20 Khushi Support Hrs
Gates (CSE2) 121
09:30-10:20 Lecture
MGH 389 NoSQL Conclusion; Course Conclusion |
07 |
08
22:00 HW7 (NoSQL Modeling) due
|
09 | 10 | 11
10:20 Final exam due
|
12 | 13 | 14 |