Install and Use SQLiteStudio

First launch

The first time SQLiteStudio opens, it may ask you to choose a language and an interface style. Choose your preferences and click OK. The main window opens with the Databases list on the left.

Step 1: Create a new database

1. Choose Database → Add a database (or press Ctrl + O).
2. Next to File, click the green plus (Create new database file) button. Choose a folder such as Documents, name the file courses.db, and click Save.
3. Leave the Name as suggested and click OK.
4. In the Databases panel, double-click courses to connect to it.

To open an existing file instead, such as library.db from the SQLite guide, click the folder icon next to File and browse to it.

Step 2: Create a table with the designer

1. Select the courses database, then choose Structure → Create a table.
2. Enter the Table name: course.
3. Click the Add column button for each column below. In the column dialog, enter the name, choose the data type, and check any constraints:

   Column name	Data type	Constraints
   course_id	INTEGER	Primary Key
   code	TEXT	Not NULL, Unique
   title	TEXT	Not NULL
   credits	INTEGER	Default value: 3

4. Click the green Commit structure changes check mark at the top of the designer. SQLiteStudio shows the CREATE TABLE SQL it will run; click OK.

Step 3: Enter data in the grid

1. In the table window, click the Data tab.
2. Click the Insert row button (green plus), then type values into the cells. Leave course_id blank; SQLite numbers it automatically.
3. Add these rows:

   code	title	credits
   IS 2010	Business Information Systems	3
   IS 4420	Database Fundamentals	3
   IS 4480	Data Warehousing	3
   IS 1000	Computing Lab	1

4. Click the green Commit check mark on the Data tab's toolbar to save the rows.

Step 4: Run SQL in the SQL editor

1. Choose Tools → Open SQL editor (or press Alt + E).
2. Make sure courses is selected in the database drop-down at the top of the editor.
3. Type the following query:

   SELECT code, title, credits
   FROM course
   WHERE credits = 3
   ORDER BY code;

4. Click Execute query (the blue play button) or press F9. The three 3-credit courses appear in the results grid below.
5. Try a summary query:

   SELECT COUNT(*) AS course_count, SUM(credits) AS total_credits
   FROM course;

   It returns 4 courses and 10 total credits.

Step 5: Export the results

Right-click the results grid (or choose Tools → Export) to export a table or query result to a format such as CSV, HTML, JSON, or SQL. Follow the export wizard and choose a file name.