A three hour tutorial presented at PyCon 2023.
Now available as an official Datasette tutorial.
2hr45m YouTube video of this tutorial: https://www.youtube.com/watch?v=5TdIxxBPUSI
See also Data analysis with SQLite and Python for PyCon 2023 on my blog.