CS 186

This is the website for Tammy’s Fall 2017 CS 186 section.

Discussion sections

• Wed 9:00 AM - 10:00 PM @ 107 GPB
• Tu 3:00 AM - 4:00 PM @ 103 GPB

You can contact me through email (tammynguyen (at) berkeley.edu) or leave feedback through this anonymous form.

Click here for my Spotify profile, which includes playlists that I play during class.

Week 1

• Intro, SQL slides
• Discussion worksheet (Solutions)
• Homework 0

Week 2

• More SQL, Joins slides
• Discussion worksheet (Solutions)
• Homework 1

Week 3

• Files, Indexes slides
• Discussion worksheet (Solutions)
• B+ trees visualization tool
• Vitamin 1
• Homework 2

Week 4

• Indexes, Buffer Management slides
• Vitamin 1
• Homework 2

Week 5

• Sorting and Hashing slides

Week 6

• Hashing, Joins slides
• Section midsemester survey
• Homework 3
• Relational algebra calculator

Week 7

• Hash Joins slides
• Section midsemester survey

Week 8

• Parallel Queries, Query Optimization slides

Week 9

• Query Optimization slides

Week 10

• ER Diagrams, Functional Dependencies slides

Week 11

• Transactions, Concurrency Control slides

Week 12

• Recovery slides

© 2017 Tammy Nguyen · Hagura Theme for Jekyll