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.)

C++ for Java Programmers
C++ for Java Programmers

Written for the moderately experienced Java programmer, this book builds on readers¿ existing knowledge of object-oriented programming and covers all important aspects of Standard C++—emphasizing more lower-level C-style details later in the presentation. Chapter topics include philosophy of C++, simplest C++, pointers...

Java 9 for Programmers (4th Edition) (Deitel Developer Series)
Java 9 for Programmers (4th Edition) (Deitel Developer Series)

The professional programmer’s Deitel® guide to Java® 9 and the powerful Java platform


Written for programmers with a background in another high-level language, this book applies the...

Deep Learning: Practical Neural Networks with Java
Deep Learning: Practical Neural Networks with Java

Build and run intelligent applications by leveraging key Java machine learning libraries

About This Book

  • Develop a sound strategy to solve predictive modelling problems using the most popular machine learning Java libraries.
  • Explore a broad variety of data processing, machine learning,...

Pro .NET 2.0 Code and Design Standards in C#
Pro .NET 2.0 Code and Design Standards in C#
This is not a book that tells you what you should or shouldn’t do! So, in the immortal words
of Douglas Adams (www.douglasadams.com): “Don’t Panic!” Yes, it is a book on standards, but
the standards are not presented as a set of rules; rather, they are presented and explained as
a catalog of standard practices
Arduino Programming with .NET and Sketch
Arduino Programming with .NET and Sketch

Leverage .NET and Sketch in your Arduino development implementation and integrate it into your .NET program.

There are many Arduino models and compatible shields that can be used in Arduino boards. Integrating between an Arduino platform and .NET technology or Sketch can produce more...

Artificial Intelligence: Structures and Strategies for Complex Problem Solving (5th Edition)
Artificial Intelligence: Structures and Strategies for Complex Problem Solving (5th Edition)
Can machines think like people? This question is the driving force behind Artificial Intelligence, but it is only the starting point of this ever-evolving, exciting discipline. AI uses different strategies to solve the complex problems that arise wherever computer technology is applied, from those areas pertaining to perception and adaptation...
©2019 LearnIT (support@pdfchm.net) - Privacy Policy