Before class on Monday 28 November, download and install the sqlite3 executable for your computer at: https://www.sqlitetutorial.net/download-install-sqlite/. You should make sure that you can run it in the terminal in order to get output similar to
$ sqlite3
SQLite version 3.16.2 2017-01-06 16:32:41
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>
Python has built-in sqlite support, but we'll also be using the standalone executable.
In class today (Nov 21), we'll be using https://sqlfiddle.com, and you can use that website to practice the quiz problems.
Before class on Monday 28 November, download and install the
sqlite3executable for your computer at: https://www.sqlitetutorial.net/download-install-sqlite/. You should make sure that you can run it in the terminal in order to get output similar toPython has built-in sqlite support, but we'll also be using the standalone executable.
In class today (Nov 21), we'll be using https://sqlfiddle.com, and you can use that website to practice the quiz problems.