| james_mcelhannon@cox.net 2005-10-07, 3:24 am |
| 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 databas
e, 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
|