Basic Tutorial
This tutorial shows you the basics of how to interact with a database using the DatabaseSpy graphical user interface. To follow this tutorial, no previous experience with databases is required, although basic knowledge of SQL (Structured Query Language) will be advantageous. The tutorial uses a file-based database (SQLite), for portability reasons. Most of the described procedures are either very similar or identical in other database kinds, so you can follow the tutorial even if you have little or no experience with SQLite.
The tutorial is organized into the following parts. It is recommended that you follow them sequentially.
1.Create a new database: Shows how to create a new SQLite database and how DatabaseSpy projects are useful.
2.Design database tables: Shows how to design database tables visually.
3.Run SQL script: Shows how to run various SQL scripts against the database, generate SQL statements from existing tables, save scripts to files, and organize them inside the project for ease of access.
4.Open the tutorial project: Shows how to view the structure of objects inside a database. It also illustrates how to retrieve data from the database and edit it.
5.Explore the database: Explains how to navigate the contents of an existing database and modify some data.