Skip to content

Latest commit

 

History

History
96 lines (77 loc) · 4.38 KB

index.md

File metadata and controls

96 lines (77 loc) · 4.38 KB
Raw
layout
index

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

  • 4/22: links to practice problems for...

  • 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

  • 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

{% assign idx = 0 %}

{% for r in site.data.schedule %} {% assign idx = idx | plus: 1 %}

{% endfor %}

Date

Topic

Assigned

Due

{{r.date}} {% if r.lshow == "1" %} {% endif %} {{r.slug}} {% if r.lshow == "1" %} {% endif %} {%if r.title %}: {{r.title}}{% endif %} {% if r.optional %}
{{r.optional | safe}}{% endif%} 
  {% if r.readings %}
    <br/>optional: Textbook {{r.readings | safe}}
  {% endif %}
  </td>
<!--<td class="readings">{{r.readings | safe}}</td>-->
<td>{% if 1 or r.ashow == "1" %} {{r.assigned | safe}} {% endif %}</td>
<td>{% if 1 or r.dshow == "1" %} {{r.due | safe}} {% endif %}</td>