Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
PostgreSQL: Introduction and Concepts

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.

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.

(HTML tags aren't allowed.)

Mathematics of the Securities Industry
Mathematics of the Securities Industry

Includes every calculation needed for the Series 7 test!

The Essential How-To Guide for Calculating P/Es, YTMs, and Other Important Wall Street Numbers

For both professional stockbrokers and self-directed individual investors, the ability to understand and use ratios, calculations, and formulas...

Computer Programming for Teens
Computer Programming for Teens
Ready to learn computer programming but aren’t sure where to start? Look no further, Computer Programming for Teens is the book for you. Other books on programming tend to be language specific and often get bogged down in the syntax of the language. That is fine if you already have a strong background in programming, but if you’re a...
Creating a Digital Home Entertainment System with Windows Media Center
Creating a Digital Home Entertainment System with Windows Media Center

Even though the Windows Media Center interface is simple to operate, not all activities are intuitive or easy to implement. You may need help determining which type of Media Center PC to buy, or with connecting and configuring the Media Center PC in your home theater system. Creating a Digital Home...

Real-Time Stability Assessment in Modern Power System Control Centers
Real-Time Stability Assessment in Modern Power System Control Centers
This book answers the need for a practical, hands-on guide for assessing power stability in real time, rather than in offline simulations. Since the book is primarily geared toward the practical aspects of the subject, theoretical background is reduced to the strictest minimum. For the benefit of readers who may not be quite familiar with the...
Teach Yourself VISUALLY Windows 8 Tablets
Teach Yourself VISUALLY Windows 8 Tablets

A visual guide to all the features of the new Windows 8 Tablet

This must-have resource features visually rich, step-by-step instructions that show you how to get the most enjoyment from your Windows 8 tablet. Learn about the exciting new Metro UI, optimized specifically for touch devices. The most popular and commonly used...

Challenging Mathematical Problems With Elementary Solutions, Vol. 1
Challenging Mathematical Problems With Elementary Solutions, Vol. 1
Over 170 challenging problems ranging from the relatively simple to the extremely difficult. Volume 1 contains 100 problems on probability theory and combinatorial analysis.

This book is the first of a two-volume translation and adaptation of a well-known Russian problem book entitled Non-Elementary Problems in an...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy