Features
- Cover Type: Paperback with 664 pages
- Published by: Apress; 2nd ed. edition April 6, 2005
- Written in: English
- ISBN 10 Number: 1590594789
- ISBN 13 Number: 978-1590594780
-
Book Dimensions:
9.2 x 7 x 1.5 inches
- Weighs: 2.2 pounds
Product Description
PostgreSQL is arguably the most powerful open-source relational database system. It has grown from academic research beginnings into a functionally-rich, standards-compliant, and enterprise-ready database used by organizations all over the world. And it's completely free to use.
Beginning Databases with PostgreSQL offers readers a thorough overview of database basics, starting with an explanation of why you might need to use a database, and following with a summary of what different database types have to offer when compared to alternatives like spreadsheets. You'll also learn all about relational database design topics such as the SQL query language, and introduce core principles including normalization and referential integrity.
The book continues with a complete tutorial on PostgreSQL features and functions and include information on database construction and administration. Key features such as transactions, stored procedures and triggers are covered, along with many of the capabilities new to version 8. To help you get started quickly, step-by-step instructions on installing PostgreSQL on Windows and Linux/UNIX systems are included.
In the remainder of the book we show you how to make the most of PostgreSQL features in your own applications using a wide range of
programming languages, including C, Perl, PHP, Java and C#. Many example programs are presented in the book, and all are available for download from the Apress web site.
By the end of the book you will be able to install, use, and effectively manage a PostgreSQL server, design and implement a database, and create and deploy your own database applications.
About The Author
Neil Matthew graduated with a degree in mathematics from the University of Nottingham in the UK and has been using and programming computers for over thirty years. Neil has used just about every flavor of UNIX since 1978, right up to today's Linux distributions. He has co-authored several computing books with Richard Stones, including
Beginning Linux Programming,
Professional Linux Programming, and
Beginning Databases with MySQL.Richard Stones graduated from university with an electrical engineering degree, but decided
software was more fun. He has programmed in a variety of languages, but only admits to knowing VB under duress. He has worked for a number of companies, from the very small to the very large, in a variety of areas, from real-time embedded systems upward. He is currently employed by Celesio AG as a systems architect, working principally on systems for the retail side of the business. He has co-authored several computing books with Neil Matthew, including
Beginning Linux Programming,
Professional Linux Programming, and
Beginning Databases with MySQL.
Reader ReviewsThere are some production problems with the book. But overall it's a fine introduction to Postgres. This isn't a general introduction as the title seems to imply. This text, graphics, and examples, all clearly relate to Postgres. The book is fairly code heavy. With example of the use of Postgres in all of the popular languages. And a hefty amount of SQL examples to learn from and use. A solid introductory walkthrough for anyone new to, or just starting to use Postgres.
Search for books at
