This semester, I’m teaching CS 186: Databases. If you’re a current or past student, welcome! You can find all of my supplementary teaching resources here.

My office hours are Thursdays, 12:30 - 2:00 PM PST in Soda 341B. My discussions are Tuesdays, 10 - 11 AM PST, online.

My discussion attendance/feedback form is here or @

Discussion Resources
Query a database with SQL Slides
Organize your data in records, pages, and files Slides
Improve read performance with a B+ tree index Slides
Choose optimal page replacement policies; Sort pedabytes of data Slides
Hash pedabytes of data Slides
Understand join algorithms Slides
Implement your own query optimizer Slides
Enable concurrent transaction schedules Slides