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:
pgsql-announce by date
|Next:||From: Marc G. Fournier||Date: 2005-10-04 23:15:16|
|Subject: New Point Releases Now Available|
|Previous:||From: Egor Abramov||Date: 2005-10-03 13:07:42|
|Subject: EMS SQL Query 2005 for PostgreSQL released|