This class has three mostly independent parts. The first section is on managing external resources with context managers, and defensive programming in general. The second section is on making queries with SQL. The third section is on relational modeling.
- The Jupyter notebook is runnable through mybinder.org.
- The second part of the class uses the San Fransisco trees datasette.
- My favorite tutorial for writing SQL queries is the Mode Analytics sql tutorial.
- My favorite textbook on SQL is "Visual Quickstart Guide" by Chris Fehily.
- If you want more practice writing SQL queries, try solving the SQL Murder Mystery.