Seminar
Maya Chen Log out

The homework actually uses real tables

Positive · Maya Chen · Sep 10, 2026

Course: SQL for analysts · Rating ★★★★☆ · Course average 4.4

Six weekly sets, each built on a public transit dump. You write joins that fail on dirty keys, then you fix the keys. The lecturer posts a short note after each deadline with the three mistakes that showed up most. Office hours are Thursday, in person, and the queue is real.

I came from spreadsheets. Week three forced a window function I still use at work. The final is a take-home: rebuild a delayed-bus report and write why the numbers lie. I would take the advanced section if they open it in spring.

Comments · 3

Owen Park · Sep 10, 2026

Is the transit dump still the 2024 file? Mine had missing stop ids.

Maya Chen · Sep 10, 2026

Same file. They want you to find the missing ids. There is a hint in week two.

Rita Sol · Sep 11, 2026

Thursday office hours filled up. I mailed the assistant and got a review the same night.