Overview

The goal of this class is two-fold. First, to introduce you to core database concepts (e.g., data modeling, logical design, SQL) so that you too can build a billion dollar application. Second, to teach enough about database engine internals (e.g., physical database design, query optimization, transaction processing) so you have a good sense of why queries may be running slowly/incorrectly. We will also discuss their relevance to systems used in industry.

Announcements

• 4/24
  • Added extra credit assignment
  • added extra credit assignment on Gradescope. Named “Extra Credit Drawing”
• 4/22: links to practice problems for…
  • Join ordering and access methods
  • FDs
  • Schedules
• 4/2
  • Updated lecture 7 to clarify conditions when checking BCNF, as well as additional examples of BCNF decomposition.
• 3/4
  • Updated lecture 5 with group-by examples and midterm logistics.
• 3/2
  • HW2 won’t accept late submission after 3/5 10:00 AM EST because we will release solution.
• 2/28
  • Updated lecture 4 to include full example of “Students that reserved all books”
  • Updated lecture 5 with full example of INTERSECT
• 2/25
  • Updated lecture 3 slide 82 so it say “Alternatively combine Courses and Instructs” rather than “Courses and Users”
  • Practice exams
  • Link to class SQL demo notebook
• Sign up for Project 1 Part 1 staff meetings! One meeting per team.
• Updated lecture 2 slides to clarify constraints over N-way relationships.
• HW0 released.

Schedule