Introduction to
Data Management

πŸ‘‹πŸ‘‹πŸ‘‹ Welcome πŸ‘‹πŸ‘‹πŸ‘‹! We are very excited to have you here; please get to know us at the staff info page and get to know the course at the syllabus.

It is very important to us that you 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.

  • Request a 1-on-1! If you feel like you need extra time, can't make it to office hours, or want to discuss something privately, please request a 1-on-1 with us.

  • 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 Ed message board or the staff email alias. 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 addressing the entire class.

Calendar


See Canvas for the full list of lecture recordings


Date

Materials

Reading

Week 1

Wed, Sep 29

2.1-2.3


Thu, Sep 30

Section 1 (slides)



Fri, Oct 1

6.1 - 6.2

Week 2

Mon, Oct 4

Same (6.1 - 6.2)


Wed, Oct 6

Same (6.1 - 6.2)


Thu, Oct 7

Section 2 (slides, worksheet, soln, video)



Thu, Oct 7



Fri, Oct 8


Week 3

Mon, Oct 11

Lec06: Subqueries (video)

Subqueries: 6.3


Wed, Oct 13

2.4, 5.1-5.2


Wed, Oct 13



Thu, Oct 14



Thu, Oct 14



Fri, Oct15

4.1-4.6

Week 4

Mon, Oct 18

3.1-3.5


Wed, Oct 20

18.1-18.2


Thu, Oct 21



Fri, Oct 22

Same (18.3)


Wed, Oct 27

Lec13: Transactions: Locks and Isolation Levels (video)

18.4

15.1, 15.1.5, 15.3, 16.4-16.4.3


Wed, Oct 27



Thu, Oct 28



Thu, Oct 28



Fri, Oct 29

Same (15.1, 15.1.5, 15.3, 16.4-16.4.3)

Week 6

Mon, Nov 1

8.3-8.4.3, 16.4.4

Week 7

Mon, Nov 8

N/A


Mon, Nov 8



Thu, Nov 11

Veterans' Day (no section)



Wed, Nov 17



Thu, Nov 18



Thu, Nov 18


Week 9

Mon, Nov 22

N/A


Wed, Nov 24

Bonus Office Hours (no lecture)



Thu, Nov 25

Thanksgiving (no section)



Fri, Nov 26

Native American Heritage Day (no lecture)


Week 10

Mon, Nov 29

N/A


Wed, Dec 1

N/A


Thu, Dec 2



Thu, Dec 2



Fri, Dec 3


Week 11


Mon, Dec 6

Lec28: Stream Processing

N/A


Wed, Dec 8

Lec29: Stream Processing (cont.)

N/A


Thu, Dec 9

Section 11



Thu, Dec 9



Fri, Dec 10

Lec30: Course wrap-up

N/A

Finals

Wed, Dec 15

Quiz 5 due