GitXplorerGitXplorer
j

sqlite-class

public
0 stars
0 forks
0 issues

Commits

List of commits on branch master.
Unverified
6567bea81ca47b18a7740839b31d0dd433ac4b20

[README] resources section has SQL Murder Mystery

jjgarst committed 5 years ago
Unverified
c7c54e09418c5b492bfca0dbaeb2a2e7d14d49e8

Class has README.md

jjgarst committed 5 years ago
Unverified
f0155014ecab18aecbf1d8f999c9484c639d3f54

initial commit

jjgarst committed 5 years ago

README

The README file for this repository.

What is a database, and why would I need one?

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.

Resources

  1. The Jupyter notebook is runnable through mybinder.org. Binder
  2. The second part of the class uses the San Fransisco trees datasette.
  3. My favorite tutorial for writing SQL queries is the Mode Analytics sql tutorial.
  4. My favorite textbook on SQL is "Visual Quickstart Guide" by Chris Fehily.
  5. If you want more practice writing SQL queries, try solving the SQL Murder Mystery.