Discovering SQL: A Hands-On Guide for Beginners

A

Installing the Library Database

The instructions in this appendix assume that all scripts are located in a single directory C:\discovery. Table A-1 lists all the scripts available for download from the book's site www.wrox.com and www.agilitator.com. The .sql script file contains all Data Definition Language (DDL) creation code, including one for creating a database. The .dat file contains data to populate tables.

The examples are given for the most ubiquitous operating system, Microsoft Windows, but would run with cosmetic modifications on any other operating system for which a particular RDBMS installation is available. The SQL scripts will run identically in each environment regardless of the underlying operating system.

Before you can use any of the scripts, you must make sure that your RDBMS is up and running. For simplicity's sake, the SQL syntax for creating a database does not use any of the options that normally accompany such an important act as that of database creation. Everything is left to default, which is not a recipe for a production database.

With the exception of PostgreSQL script, all other scripts contain database creation code. The PostgreSQL has a separate script for this purpose because it cannot run the CREATE DATABASE statement as part of a multi-command string. Additionally, there are two versions of the Oracle DDL script: one for SQL*Plus and one ...