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-06-24T00:00:00-04:00.
2. Complete Check 0 by 2024-06-26T23: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 0 by 2024-06-30T23:59:00-04:00.

Relating

1. Watch Week 1 after 2024-07-01T00:00:00-04:00.
2. Complete Check 1 by 2024-07-03T23: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 1 by 2024-07-07T23:59:00-04:00.

Designing

1. Watch Week 2 after 2024-07-08T00:00:00-04:00.
2. Complete Check 2 by 2024-07-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 2 by 2024-07-14T23:59:00-04:00.

Writing

1. Watch Week 3 after 2024-07-15T00:00:00-04:00.
2. Complete Check 3 by 2024-07-17T23: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-07-21T23:59:00-04:00.

Viewing

1. Watch Week 4 after 2024-07-22T00:00:00-04:00.
2. Complete Check 4 by 2024-07-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-07-28T23:59:00-04:00.

Optimizing

1. Watch Week 5 after 2024-07-29T00:00:00-04:00.
2. Complete Check 5 by 2024-07-31T23: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-08-04T23:59:00-04:00.
6. Begin work on your final project with:
   1. The proposal due 2024-08-01T23:59:00-04:00; and
   2. The status report due 2024-08-05T23:59:00-04:00; and
   3. The implementation due 2024-08-09T23:59:00-04:00.

Scaling

1. Watch Week 6 after 2024-08-02T00:00:00-04:00.
2. Complete Check 6 by 2024-08-04T23: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-08-09T23:59:00-04:00.
6. Complete work on your final project, with:
   1. The proposal due 2024-08-01T23:59:00-04:00; and
   2. The status report due 2024-08-05T23:59:00-04:00; and
   3. The implementation due 2024-08-09T23:59:00-04:00.
      • As a reminder, no portion of the final project may be turned in late, per the syllabus. And specifically, with respect to the final project implementation and Project 6, the semester ends at the moment the project is due, and we are not allowed for any reason to accept late work after the semester ends.