the basics
tools
the tools we use in the sql garden adhere to a local first strategy for learning and modeling data.
sqlite
SQLite is an in-progress library that implements a complete SQL database engine. this tool is in the public domain and powers a large part of software used daily. for its ease of use and powerful simplicity it is our de facto hammer for all things data modeling.
sqlite3
the primary way to interface with sqlite is via the sqlite3 cli command. Installation details can be found here
learn sqlite
High Performance SQLite by Aaron Francis is a fantastic guided tutorial for practical and pragmatic understanding of SQLite. Highly recommended.
A quick cheat sheet reference page can be found at sqlitetutorial.net