QSIntroduction
This Quick Start takes you step-by-step through the process of creating and using a database using the InterBase IBConsole dialog. 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.
There are five parts in this tutorial:
- Part I: Getting Started
- How to Install and Start the InterBase Server
- How to Create a New User and a Database
- Part II: Data Definition
- What are the Fundamentals of Database Design
- How to Work in the IBConsole Environment
- How to create the Data Structures for your Database
- How to Recover from Errors
- Part III: Populating the Database
- How to Populate Your Database
- Part IV: Retrieving Data
- How to Access or Retrieve your Data
- Part V: Advanced Topics
- How to Work with Database Security
- How to Create Some Triggers and Stored Procedures to Automate Some of Your Database Tasks
Using this Quick Start
Throughout this Quick Start, you are instructed to enter SQL statements manually at the beginning of each new topic in order to give you a hands-on experience. Then you are instructed to read in one of the SQL scripts that accompany this document. These steps allows you to create a database that is complex enough to be interesting without excessive keyboarding. The database that you create is, in fact, the EMPLOYEE database that is used as the example database for InterBase and is referenced throughout the InterBase document set.