Beginning Databases with PostgreSQL: From Novice to Professional, Second Edition (Beginning from Novice to Professional)
| 2005-04-06 00:00:00 | | 0 | PostgreSQL
Beginning Databases with PostgreSQL: From Novice to Professional, Second Edition
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.
User review
Great for learning
This is a very enjoyable book, not meant as a reference manual, but as a way of learning the subject. I cant vouch for it being complete, but I did enjoy the explanations. It explains many of the concepts of relational databases through simple clear language.
If you've been in the database world a lo,g time and you want to see what's specific to Postgres then this might not be your book, but if you have dabbled in databases and you want to consolidate your knowledge then this is a very good book to learn from.
User review
Excellent book
This is an excellent book because it is illustrated by the author thinking that you are new in the language.
User review
Useful, but has limitations
This book would be better labeled `Beginning Databases with Postgresql - From Novice to Amateur with a few Provisos.`
This book is good for getting you to the stage where you have some basic confidence in using PostgreSQL (an excellent database). Do NOT expect to be able to learn what it is you are learning Postgres for without a great deal of googling, hanging out on the #postgresql irc channel (hint: type ?? and topic, VERY useful), searching the mailing list archives, reading the online documentation (which is very useful), and of course, liberal use of ? and h in psql.
After you have some basic familiarity with Postgres you will still use Matthew and Stones from time to time, looking up syntax etc. For that it is useful.
One of the most annoying things is that it promotes bad database design through the `bpsimple` and `bpfinal` sample databases. Anyone using such a database would be constantly having to clean out garbage data in their database. Take for example their customer table. Their only unique constraint is the primary key, customer_id. If they don't have either a multiple column primary key or some other unique constraint, they will constantly be getting duplicate customers.
At least when I was learning MS Access the books I used taught me good principles such that I am not having to deal with duplicate values years later.
Unfortunately due to the dearth of Postgresql books this is still one of the better offerings. I would give it 3 stars if there was more competition.
User review
Before you buy this book,,,,
I really wanted to like this book, but, unfortunately, after the first 100 pages, can't endorse it at all. I'm a `poweruser` of MSAccess and a general fan of databases in general. I have read enough books on SQL and know enough about database theory and implementations to know disorganized and poorly introduced subject matter when I read it. This book suffers from what a lot of database books suffer from, a smattering of this concept and that concept, mixing in a little SQL syntax with database schema design with a little snippet on good table design then off to the multi-user access features of PostgreSQL,,,, whoa Nelly! Sadly, the authors try to be too many things to too many audiences and the result is a mess. Understandably, the subject of databases (from theory, to implementation, to end user) is huge, writing a book to cover it all is a daunting task, and this one fails like the many that have gone before it. My apologies for not providing a list of other books I feel succeed, but time doesn't permit.
User review
Great book
I ordered this book because amazon.com bundled it with « Beginning PHP and PostgreSQL 8 ». I must admit I was happily surprised. It's definitely more than a copy of the PostgreSQL manual. Explanations are simple to understand.
There's a chapter on database design, something really important to me.
Something that surprises me too is the big part on languages. The PostgreSQL manual focused on C with libpq and there's not much on other languages. This book brings a lot of informations with PHP, Perl, Java, C#.
This book also brings informations on new PostgreSQL 8 functionnalities (tablespace, $$ quoting). Unfortunately, there's nothing on release 8.1 (CREATE ROLE for example).
Finally, a great book to begin with, a reference for the rest of us.