index.md

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.

Please do not ask me about the waitlist

Announcements

• Link to er to sql 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

{% 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>