Tutorials
This section contains the following tutorials:
•"Nanonull" Database: This tutorial runs you through the main features of DatabaseSpy. You do not need a running database server to follow the tutorial because it uses a file-based database (SQLite). You will learn how to create a file-based database from scratch, as well as how to perform basic data manipulation tasks from DatabaseSpy.
•"ZooDB" Database: This tutorial provides more in-depth information about DatabaseSpy features. To follow this tutorial, you need access to a running SQL Server database where you have rights to create a demo schema and populate it with data.
All the required SQL scripts and other accompanying files for both tutorials are available in the C:\Users\<username>\Documents\Altova\DatabaseSpy2023\DatabaseSpyExamples\Tutorial folder, relative to your personal Documents folder. The SQL grammar of the accompanying scripts is specific to SQLite and SQL Server, respectively. Nevertheless, the features highlighted in the tutorials are identical or similar across various database kinds supported by DatabaseSpy.