InterBase Quick Start
Go Up to Main Page
This Quick Start tutorial takes you step-by-step through the process of creating and using a database. You learn to create data structures that enforce referential integrity constraints and maintain security. You populate your tables, create triggers and stored procedures, and learn a number of techniques for retrieving the data with precision. Instructions assume that you use the interactive SQL window of the IBConsole but you may use the command-line
isql instead. If you use the command-line
isql, you may need to modify the provided code.
InterBase provides an intuitive graphical user interface called IBConsole. With IBConsole you can perform all the necessary tasks to configure and maintain an InterBase server, to create and administer databases on the server, and to execute interactive SQL (isql). IBConsole only runs on Windows, but can manage databases on any server on the local network. For more information about the IBConsole environment, see the IBConsole reference topics. For more information about how to use IBConsole and related tools, see Using IBConsole and Tools.
isql is a utility for processing SQL data definition (DDL) and data manipulation (DML) statements from interactive input or from a source file. It enables you to create and view metadata, add and modify data, grant user permissions, test queries, and perform database administration tasks.
- Overview of SELECT
- Removing Duplicate Rows with DISTINCT
- Using the WHERE Clause
- Using Subqueries
- Using Aggregate Functions
- Grouping and Ordering Query Results
- Joining Tables
- Formatting Data