SQLite Studio

If you want a free program to view SQL databases, try SQLite Studio http://sqlitestudio.pl/?act=download You just download the files for this program in a zip file and extract it; there's no actual installation wizard. To start it just click on the file named, 'SQLiteStudio.exe',. SQLite Studio is recommended by Thomas Nield, the author of Getting Started with SQL: A Hands-on Approach for Beginners, a new O'Reilly Guide. The O'Reilly Guide makes some practice data available here, https://github.com/thomasnield/oreilly_getting_started_with_sql .


Once you have a SQL database open, you can activate the editor by going to Tools . . . Open SQL Editor

To get all of the data from a table in the database you run this command:


SELECT followed an asterisk [to select all of the data] FROM [the database name].