SQL Bible [Electronic resources] نسخه متنی

What's on the CD

The following sections provide a summary of
the software and other materials you'll find on the CD.

Author-created materials

All author-created material from the
book, including code listings and samples, are on the CD in the folder named
"sqlbib." The CD also contains complete authors' SQL scripts and examples used
in the book, with different versions for Oracle 9i, IBM
DB2 UDB 8.1, and Microsoft SQL Server 2000.

Please run the specific version for the
RDBMS of your choice as from the respective directories:
/sqlbib/acme_oracle/,
/sqlbib/acme_db2/, and
/sqlbib/acme_mssql/.

The following files are supplied for you
to create and populate the sample ACME database:

i

load_data_oradat: populates the ACME
database with the appropriate data for Oracle 9i

create_acme_oracle.sql and then
load_data_oracle.sql

: creates
database and all database objects for IBM DB2 UDB 8.1

Chapter
16

Chapters
3,
4,
5,
and
6)

The use of these files is described in
Appendixes
D,
E, and
F, as well as in chapters where they are
mentioned. Examples in Chapters 3 through 6 assume an empty ACME database
created with Appendix
F.

Applications

The following applications are on your
CD:

IBM DB2 Universal Database Personal Edition Version 8.1 for
Microsoft Windows Operating Environments Evaluation Copy (Windows NT/2000/XP).
It provides a single-user database engine for deployment to PC-based users. The
PE includes the ability to be remotely managed, which makes it the perfect
choice for deployment in occasionally connected or remote office
implementations that don't require multi-user capability. Detailed installation
instructions are provided in
Appendix
D.

Note: This is a
time-limited version of DB2 and will expire and become unoperational on or
about November 30, 2004.

Adobe Acrobat Reader free software for viewing and printing
Adobe Portable Document Format (PDF) files on all major hardware and operating
system platforms.

Shareware programs
are fully functional, trial versions of copyrighted programs. If you like
particular programs, register with their authors for a nominal fee and receive
licenses, enhanced versions, and technical support. Freeware
programs are copyrighted games, applications, and utilities that are
free for personal use. Unlike shareware, these programs do not require a fee or
provide technical support. GNU software is governed by its
own license, which is included inside the folder of the GNU product. See the
GNU license for more details.

Trial, demo, or evaluation
versions are usually limited either by time or functionality (such
as being unable to save projects). Some trial versions are very sensitive to
system date changes. If you alter your computer's date, the programs will "time
out" and will no longer be functional.

eBook version of SQL
Bible

The complete text of this book is
provided in Adobe's Portable Document Format (PDF). It does not include the
scripts required to create sample database. You can read and search through the
file with the Adobe Acrobat Reader (also provided).