The open source PostgreSQL database is soaring in popularity, as thousands of database and web professionals discover its powerful features, transaction support, performance, and industrial-strength scalability. In this book, a founding member of the PostgreSQL development team introduces everything you need to know to succeed with PostgreSQL, from basic SQL commands through database administration and optimization. PostgreSQL assumes no previous database expertise: it establishes a firm foundation of basic concepts and commands before turning to PostgreSQL's advanced, innovative capabilities. Bruce Momjian walks readers step-by-step from their first database queries through the complex queries needed to solve real-world problems. He presents proper query syntax, then explores the value and use of each key SQL commands in working applications. Learn to manipulate and update databases, customize queries, work with SQL aggregates, use joins, combine SELECTs with subqueries, work with triggers and transactions, import and export data, use PostgreSQL query tools, and more. Discover PostgreSQL techniques for server-side programming and multi-user control, and master PostgreSQL's interfaces to C, C++, ODBC, JDBC, Perl, and Tcl/TK. You'll also find detailed coverage of PostgreSQL administration, including backups, troubleshooting, and access configuration.
Book Description
Editorial Reviews
From the Inside Flap
This book is about POSTGRESQL, the most advanced open source database. From its origins in academia, POSTGRESQL has moved to the Internet with explosive growth. It is hard to believe the advances during the past four years under the guidance of a team of worldwide Internet developers. This book is a testament to their vision, and to the success that POSTGRESQL has become.
The book is designed to lead the reader from their first database query through the complex queries needed to solve real-world problems. No knowledge of database theory or practice is required. However, basic knowledge of operating system capabilities is expected, such as the ability to type at an operating system prompt.
Beginning with a short history of POSTGRESQL, the book moves from simple queries to the most important database commands. Common problems are covered early, which should prevent users from getting stuck with queries that fail. The author has seen many bug reports in the past few years and consequently has attempted to warn readers about the common pitfalls.
With a firm foundation established, additional commands are introduced. The later chapters outline complex topics like transactions and performance.
At each step, the purpose of each command is clearly illustrated. The goal is to have readers understand more than query syntax. They should know why each command is valuable, so they can use the proper commands in their real-world database applications.
A database novice should read the entire book, while skimming over the later chapters. The complex nature of database systems should not prevent readers from getting started. Test databases offer a safe way to try queries. As readers gain experience, later chapters will begin to make more sense. Experienced database users can skip the early chapters on basic SQL functionality. The cross-referencing of sections allows you to quickly move from general to more specific information.
Much information has been moved out of the main body of the book into appendices. Appendix A lists sources of additional information about POSTGRESQL.Appendix B provides information about installing POSTGRESQL. Appendix C lists the features of POSTGRESQL not found in other database systems. Appendix D contains a copy of the POSTGRESQL manual pages which should be consulted anytime you have trouble with query syntax. Also, do not overlook the excellent documentation that is part of POSTGRESQL. This documentation covers many complex topics, including much POSTGRESQL-specific functionality that cannot be covered in a book of this length. Sections of the documentation are referenced in this book where appropriate.
This book uses italics for identifiers, SMALLCAPS for SQL keywords, and a monospaced font for SQL queries. The Web site for this book is located at postgresql/docs/awbook.html. 0201703319P04062001
From the Back Cover
The most advanced, feature-rich SQL database server available, the open-source PostgreSQL system has rapidly become a key Internet technology. PostgreSQL: Introduction and Concepts, written by a founding member of the PostgreSQL Global Development Team, provides a much-needed tutorial and real-world guide to understanding and working with this complex yet essential system.
0201703319B04062001
Assuming no previous knowledge of database systems, the book establishes a firm foundation of basic concepts and commands before turning to PostgreSQL's more advanced and innovative capabilities. It leads you step-by-step from your first database query through the complex queries needed to solve real-world database problems. The author not only presents proper query syntax, he goes beyond the mechanics to explore the value and use of these commands in working database applications.
You will read about such important topics as:
- Basic SQL commands for manipulating and updating a database
- Customizing queries
- SQL aggregates
- Joining tables
- Combining SELECTs and subqueries
- Transactions
- Performance
- Importing and exporting data
- Database query tools, including PSQL and PGACCESS
- PostgreSQL interfaces to C, C++, ODBC, JDBC, Perl, TCL/TK, and more
- Server-side programming and multi-user control
- Extending PostgreSQL with C
- PostgreSQL administration, including backups, troubleshooting, and access configuration
- Features unique to PostgreSQL
Throughout, the author highlights common pitfalls, offers tips to save you time and trouble, and provides many examples--all garnered from his extensive experience and inside knowledge. In addition, this resource-rich guide provides a copy of the official PostgreSQL reference manual. A companion web site, www.postgresql.org/docs/awbook.html, will contain updates, corrections, and links to other material.
0201703319B04062001
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
20 of 20 people found the following review helpful:
4.0 out of 5 stars
Great first book on PostgreSQL,
By "ewolpert" (Scottsdale, Az United States) - See all my reviews
This review is from: PostgreSQL: Introduction and Concepts (Paperback)
This is the first book I've seen on PostgreSQL. It's been in progress for sometime, and had been available in electronic form. However, the print version is sure to be a gem. It contains information needed by anyone trying to get a handle on PostgreSQL, beginner or advanced. The folks starting to use PostgreSQL will have alot of examples on standard SQL for database access, including transaction support. The more advanced users will appreciate the level of detail including how PostgreSQL differs from standard SQL (Good news is that this isn't by much) and integration with other tools. It also has good information about transaction requirements and ways they are implemented within the context of PostgreSQL, as well as how to increase performance. I gave it four stars out of five only because I thought it could have used more administration details and hints. Though the administration section in the book is still a good read, and it is clearly a topic that can take another book to complete. In short, I highly recommend the book for those wanting to learn more about this open-source database.
18 of 19 people found the following review helpful:
4.0 out of 5 stars
A great overview of Postgres,
By
Amazon Verified Purchase(What's this?)
This review is from: PostgreSQL: Introduction and Concepts (Paperback)
It's an odd commentary on the open source movement that, while open source code seems sophisticated and reliable -- as a result of the many hands working on it -- open source documentation, as a general rule, sucks. I believe that this book is the _first_ printed book on PostgreSQL. As such, the author is to be commended for his effort at collecting a great deal of useful Postgres info in one place, helping readers find the essential knowledge buried in the sea of online documentation.The book's title says "Introduction and Concepts", letting you know this isn't an advanced treatise on Postgres. The first half of the book handily summarizes SQL and then dives into hands-on PostgreSQL, run interactively via the psql interactive utility. This is a nice way to give readers direct experience with Postgres, but it is also automatically limiting because readers never learn how to use Postgres in the context of an application. There is a chapter on programming interfaces, but it covers ten languages in ten pages, which isn't enough to impart any practical Postgres programming skills. The second half of the book is a verbatim replica of the SQL Commands reference from the official Postgres user's guide. It's handy to have in the book, but it's hard to give the author any credit for simply pouring this stuff into his book unchanged. I would have liked to see some useful annotations from the author, reflecting his obviously considerable experience with Postgres. I gave the book four stars in part because the author is breaking new ground by carving out a niche with publishers for future PostgreSQL books. I'm hoping a second edition of his book comes soon, replacing (or augmenting) those 250 pages of reference material with concrete programming examples in a variety of languages and interesting comments on usage. In the meantime, this book is a very nice primer for our new employees who have to come up to speed on PostgreSQL quickly.
16 of 19 people found the following review helpful:
1.0 out of 5 stars
no limits (and that is a bad thing),
By
This review is from: PostgreSQL: Introduction and Concepts (Paperback)
I teach Software Engineering for Internet Applications. Our students are free to use whatever ACID-compliant RDBMS they prefer. Since PostgreSQL is more or less the only open-source candidate (unless you count the RDBMS open-sourced by SAP), PostgreSQL is our students' third most popular choice (after Oracle and Microsoft SQL Server). The students using this book have a horrible time picking data types because the book doesn't provide fundamental information, or at least none that we could find. Want to know how long a character string can be? How precise a timestamp is? You won't find the answers in this book.
Share your thoughts with other customers: Create your own review
|
|
What Other Items Do Customers Buy After Viewing This Item?
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Listmania!
|
|
