top of page

SQLite Studio

If you want a free program to view SQL databases, try SQLite Studio 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, .


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].

bottom of page