Structured Query Language : An Introduction

Structured Query Language -- An Introduction EBOOK, 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.