PostgreSQL: Introduction and Concepts - Softcover

Momjian, Bruce

Softcover

ISBN 10: 0201703319 ISBN 13: 9780201703313

Publisher: Addison Wesley, 2000

Synopsis

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.

About this title

About the Author

Bruce Momjian is a founding member of the PostgreSQL Global Development Team. He is currently a senior consultant with Wilson Technology Associates in Newtown Square, Pennsylvania, designing and developing relational database applications for some of the largest law firms nationwide.

0201703319AB04062001

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.

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

Edition details

• Publisher: Addison Wesley
• Publication date: 2000
• Language: English
• ISBN 10: 0201703319
• ISBN 13: 9780201703313
• Binding: Paperback
• Number of pages: 496