Announcements

Description

This course is an introduction to databases using a language called SQL. Students learn how to create, read, update, and delete data with relational databases, which store data in rows and columns, and how to model real-world entities and relationships among them using tables with appropriate types, triggers, and constraints. The course covers how to normalize data to eliminate redundancies and reduce potential for errors and how to join tables together using primary and foreign keys. Students learn how to automate searches with views and expedite searches with indexes, as well as how to connect SQL with other languages like Python and Java. The course begins with SQLite for portability’s sake and ends with introductions to PostgreSQL and MySQL for scalability’s sake. Assignments are inspired by real-world datasets.

Table of Contents

Querying

  1. Watch Week 0 after 2024-01-22T12:00:00-05:00.
  2. Complete Check 0 by 2024-01-28T23:59:00-05:00.
  3. Attend section, live and with webcam and audio enabled (per sections’ norms).
  4. Optionally attend office hours.
  5. Complete Problem Set 0 by 2024-02-04T23:59:00-05:00.

Relating

  1. Watch Week 1 after 2024-02-05T12:00:00-05:00.
  2. Complete Check 1 by 2024-02-11T23:59:00-05:00.
  3. Attend section, live and with webcam and audio enabled (per sections’ norms).
  4. Optionally attend office hours.
  5. Complete Problem Set 1 by 2024-02-18T23:59:00-05:00.

Designing

  1. Watch Week 2 after 2024-02-19T12:00:00-05:00.
  2. Complete Check 2 by 2024-02-25T23:59:00-05:00.
  3. Attend section, live and with webcam and audio enabled (per sections’ norms).
  4. Optionally attend office hours.
  5. Complete Problem Set 2 by 2024-03-03T23:59:00-05:00.

Writing

  1. Watch Week 3 after 2024-03-04T12:00:00-05:00.
  2. Complete Check 3 by 2024-03-10T23:59:00-04:00.
  3. Attend section, live and with webcam and audio enabled (per sections’ norms).
  4. Optionally attend office hours.
  5. Complete Problem Set 3 by 2024-03-17T23:59:00-04:00.

Viewing

  1. Watch Week 4 after 2024-03-18T12:00:00-04:00.
  2. Complete Check 4 by 2024-03-24T23:59:00-04:00.
  3. Attend section, live and with webcam and audio enabled (per sections’ norms).
  4. Optionally attend office hours.
  5. Complete Problem Set 4 by 2024-03-31T23:59:00-04:00.

Optimizing

  1. Watch Week 5 after 2024-04-01T12:00:00-04:00.
  2. Complete Check 5 by 2024-04-07T23:59:00-04:00.
  3. Attend section, live and with webcam and audio enabled (per sections’ norms).
  4. Optionally attend office hours.
  5. Complete Problem Set 5 by 2024-04-14T23:59:00-04:00.
  6. Begin thinking about your final project proposal, due 2024-04-14T23:59:00-04:00.

Scaling

  1. Watch Week 6 after 2024-04-15T12:00:00-04:00.
  2. Complete Check 6 by 2024-04-21T23:59:00-04:00.
  3. Attend section, live and with webcam and audio enabled (per sections’ norms).
  4. Optionally attend office hours.
  5. Complete Problem Set 6 by 2024-04-28T23:59:00-04:00.
  6. Submit your final project status report, due 2024-04-28T23:59:00-04:00.

Assessment Opportunity

  1. Submit the assessment opportunity, due 2024-05-07T23:59:00-04:00.