Tuesday, 11/03
Building and querying your database
Database project, Part A: ERD, DDL with declared keys, data loaded Due Sunday, 11/08 Checkpoint 4 Due Sunday, 11/08
Open in a new tab
· press f for fullscreen, o for an overview
Open in a new tab
· press f for fullscreen, o for an overview
The notebook is loading. The first load takes about 25 seconds.
Or run it on your own machine, which is how this course works from the second session on.
- Download
06-building-and-querying.pyinto your project'snotebooks/folder. -
Run
uv run marimo editfrom the project, with no file name. You get a page listing every notebook in it.
uv run 06-building-and-querying.py runs the cells and exits without showing you
anything, which looks like nothing happened. No project yet?
uvx marimo edit opens whichever folder you are in.
·
Jupyter version, which
reads without being run but has no working controls.
In the handbook
Reference for this session. None of it is assigned.
- §6
SELECTandFROM - §7
WHERE - §8
ORDER BYandLIMIT - §9
NULL, and why it is not zero - §10
DISTINCT, and what it hides - §11
CASE WHEN - §12 Dates: truncating, differencing, grouping by month
- §13 Aggregate functions
- §14
GROUP BY - §15
HAVING, againstWHERE - §16 The order the clauses actually run in
- §24 DDL:
CREATE TABLE, types, constraints - §25 DML:
INSERT,UPDATE,DELETE - §26 Loading a CSV into DuckDB
- §28 Views