Welcome to CSE 344! We are so excited for you to join us this quarter. Please get to know us at the staff info page and get to know the course at the syllabus.
Lectures: MWF, 2:20 - 3:20, in JHN 075
Sections:
We want you to enjoy and succeed in CSE 344! In addition to lectures and sections, there are several ways to ask questions or engage with the teaching staff:
Visit office hours! This is the best place to get detailed, hands-on debugging help and to work with other students who may be struggling with the same bug as you are.
Request a 1-on-1! If you feel like you need extra time, can't make it to support hours, or want to discuss something privately, please request a 1-on-1 with us. There is a request form on the message board.
Make a public post about course content on the Ed message board, where they benefit the whole class. This also allows other students to answer your question, which may yield a faster response than emailing only the staff. This is the best way of asking questions about class-related topics.
Make a private post to just the course staff using the staff email alias or the Ed message board. This is a good way to ask questions or discuss issues privately.
Send anonymous feedback to the instructor. She will share the issue with others only as appropriate, but will not be able to reply to you without also addressing the entire class.
Homework 1 - due Monday June 30th @ 11 pm (available on Gradescope)
Section 1 - slides, demo, worksheet, worksheet solutions
See Canvas (under Panopto tab) for lecture recordings
Week 2
Monday, June 30
SQL Aggregates
6.4
Wednesday, July 2
SQL Joins and Aggregates
Friday, July 4
NO CLASS (holiday)
Week 3
Monday, July 7
Sub-Queries
6.3
Wednesday, July 9
Sub-Queries cont.
Friday, July 11
Database Design - ER Diagrams
4.1 - 4.6
Week 4
Monday, July 14
ER Diagrams cont.
Wednesday, July 16
Database Design Theory
3.1 - 3.5
Friday, July 18
Data Normalization
Week 5
Monday, July 21
Relational Algebra
2.4, 5.1 - 5.2
Wednesday, July 23
Cost Estimation
16.1 - 16.2
Friday, July 25
Indexes and Optimization
3.4 - 3.6
Week 6
Monday, July 28
Application Programming
Wednesday, July 30
Transactions - Serializability
18.1 - 18.4
Friday, August 1
Transactions - Serializability cont.
Week 7
Monday, August 4
Transactions - Locking
Wednesday, August 6
Transactions - Isolation Levels
Friday, August 8
Semi Structured Data Model
Week 8
Monday, August 11
SQL++
Wednesday, August 13
SQL++ cont.
Friday, August 15
Parallel Databases
20.1, 20.3 - 20.4
Week 9
Monday, August 18
MapReduce & Spark
Wednesday, August 20
TBD
Friday, August 22
TBD