Lesson Log
Some folks knit, some make jam—I write lessons. This one needs three more examples and (at least) six more diagrams, but it’s getting there. If you’d like to help, please get in touch.
| date | time | type | event |
|---|---|---|---|
| 2024-01-30 | 21:16 | refactor | move scripts into subsidiary files |
| 2024-01-30 | 20:49 | fix | formatting glitch with table |
| 2024-01-30 | 17:29 | add | concept map for null |
| 2024-01-30 | 13:09 | refactor | move to-do items to issues |
| 2024-01-30 | 12:57 | refactor | remove junk file |
| 2024-01-30 | 09:49 | fix | hand-drawn diagrams |
| 2024-01-30 | 06:38 | add | ORM using SQLModel |
| 2024-01-29 | 21:24 | add | update to-do section |
| 2024-01-29 | 20:56 | refactor | mark sections |
| 2024-01-29 | 20:08 | add | show how to use SQL with Pandas and Polars |
| 2024-01-29 | 19:46 | add | moving keyword check data to _data |
| 2024-01-29 | 19:44 | add | moving thanks to YAML file |
| 2024-01-29 | 19:37 | add | use “explain query plan” instead of “explain |
| 2024-01-29 | 19:19 | add | Jupyter notebooks |
| 2024-01-29 | 14:33 | fix | minor typos |
| 2024-01-28 | 18:09 | add | thanks |
| 2024-01-28 | 18:08 | fix | typo |
| 2024-01-28 | 17:02 | add | filling in title and GitHub repo link |
| 2024-01-28 | 16:37 | add | date/time converters |
| 2024-01-28 | 16:22 | add | Python |
| 2024-01-28 | 11:37 | add | blobs |
| 2024-01-28 | 09:20 | add | recursive contact tracing |
| 2024-01-28 | 06:37 | add | recursive queries |
| 2024-01-27 | 17:03 | add | contact database |
| 2024-01-27 | 15:43 | add | update to-do list |
| 2024-01-27 | 15:40 | refactor | moving row update and delete |
| 2024-01-27 | 09:47 | add | triggers |
| 2024-01-27 | 08:15 | refactor | single quotes instead of double quotes |
| 2024-01-26 | 14:26 | add | transactions |
| 2024-01-26 | 09:37 | add | except and intersect |
| 2024-01-26 | 06:50 | add | tombstones and views |
| 2024-01-25 | 21:53 | add | renumber headings |
| 2024-01-25 | 18:50 | add | filter inputs to aggregates |
| 2024-01-25 | 18:23 | add | deleting rows |
| 2024-01-25 | 11:09 | add | JSON |
| 2024-01-25 | 08:28 | add | window functions |
| 2024-01-24 | 19:31 | add | lab logs |
| 2024-01-23 | 19:34 | add | correlated subqueries |
| 2024-01-23 | 09:19 | add | randomness and string operators |
| 2024-01-23 | 07:48 | add | self join |
| 2024-01-23 | 07:21 | refactor | move conditional lessons |
| 2024-01-23 | 06:50 | add | check numbering of headings |
| 2024-01-22 | 21:18 | add | improving detection in SQL keyword finder |
| 2024-01-22 | 18:39 | add | tracking unexplained keywords |
| 2024-01-22 | 13:07 | add | acknowledgments |
| 2024-01-22 | 12:32 | add | extract SQL features used in examples |
| 2024-01-21 | 21:11 | add | case/when |
| 2024-01-21 | 20:57 | add | iif function |
| 2024-01-21 | 18:16 | refactor | convert Jupyter notebooks to Jekyll |
| 2024-01-21 | 16:16 | add | filling in missing days |
| 2024-01-21 | 13:58 | add | sequence numbers |
| 2024-01-21 | 08:43 | add | adding to-do list |
| 2024-01-21 | 08:35 | add | explaining queries |
| 2024-01-21 | 08:22 | add | adding code of conduct and license to site |
| 2024-01-21 | 08:19 | add | marking home page |
| 2024-01-21 | 08:00 | add | adding ER diagrams |
| 2024-01-20 | 16:16 | add | comparing individual to aggregate and using CTEs |
| 2024-01-20 | 14:10 | add | reorganize as Jekyll site |
| 2024-01-19 | 21:19 | add | joins and aggregate comparisons |
| 2024-01-19 | 19:33 | add | outlining |
| 2024-01-19 | 16:20 | add | generate HTML |
| 2024-01-19 | 08:55 | add | left join and CTEs |
| 2024-01-18 | 13:35 | add | joins |
| 2024-01-18 | 08:38 | add | aggregation |
| 2024-01-16 | 21:01 | add | add assay database |
| 2024-01-16 | 07:34 | add | first tutorial notebook |
| 2024-01-15 | 19:00 | add | initial commit |