Structured Query Language -- An Introduction, provides a comprehensive tutorial
and reference for database programmers of all skill levels. Using the open
source database PostgreSQL as a reference, the reader is taken from the basics
of creating a database, setting permissions, and designing and implementing
tables. The reader is introduced to searching for records in the database using
queries, adding new data, updating existing data, and deleting data.
Advanced topics are also included, such as: the creation and usage of indices
for faster queries; the use of transactions to ensure database integrity;
design and implementation of primary keys, foreign keys, and alternate keys;
joining multiple tables in a single query; and database security.
Additional information available at:
http://www.lulu.com/165318
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
