By Eric Burden | June 5, 2019
Presented May 31st, 2019 @ Memphis NonProfit Data Professionals Meetup
The git repository for this talk can be found HERE.
The presentation can be viewed HERE.
Resources cited in this talk include:
- SQLCourse: An interactive online training course for SQL, includes good background information about SQL in general.
- SQLite.org: Website for the SQLite project, houses downloads, documentation, and just about anything else you’d need regarding SQLite.
- sqlitetutorial.net: A collection of SQLite tutorials.
- SQLite Browser: GUI for SQLite. This isn’t the only GUI, but it is cross-platform, reliable, and easy to use.
- DBHub.io: An optional “Cloud” storage service for SQLite databases. The database used in this talk is stored here for public access.
- nycflights13 documentation:
Airline on-time data for all flights departing NYC in 2013. Also includes useful ‘metadata’ on airlines, airports, weather, and planes.
- SQLite Online: An online SQLite GUI and browser. Useful for working with a SQLite database in the absence of a local SQLite installation.