A guide to learning SQL via data about the United States' national parks.
If you don't want to install sqlite3 locally, or you have trouble you can run SELECT queries in your browser:
https://sqlime.org/#https://raw.githubusercontent.com/ajmarcus/nationalparks/main/data/nps.sqlite
Just note that the CREATE and INSERT queries covered below will not work in the browser.
If you want to install sqlite3, first check if you have it already:
- Open a terminal
- Type "sqlite3" and press enter
sqlite3 ./nps.sqlite- If you see a prompt like "sqlite>", then you have sqlite3 installed
SQLite version 3.43.2 2023-10-10 13:08:14
Enter ".help" for usage hints.
sqlite>If you don't already have it, this is how to install sqlite3:
- Go to https://www.sqlite.org/download.html
- Choose the "Precompiled Binaries For" Mac OS X or Windows section
- Download the sqlite-tools-*.zip file
- Unzip and you should have a sqlite3 executable
- On Mac you will need to right click on the sqlite3 file and choose "Open" to bypass the security warning
- On Windows, I'm not sure what you need to do
- On Mac, you can then move
sqlite3to/usr/local/binto make it available from the command line
mv ~/Downloads/sqlite-tools-osx-x64-3450100/sqlite3 /usr/local/bin- Now you should be able to run
sqlite3from the command line
sqlite3 ./nps.sqliteSQLite version 3.43.2 2023-10-10 13:08:14
Enter ".help" for usage hints.
sqlite>Use these settings in your sqlite3 shell locally to get pretty output:
sqlite> .header on
sqlite> .mode table