Beginning Databases with PostgreSQL

Richard Stones,Neil Matthew

ISBN 10: 1861005156 / ISBN 13: 9781861005151

Editore: Apress, 2001

Riguardo questo articolo

Connecting readers with great books since 1972. Used textbooks may not include companion materials such as access codes, etc. May have condition issues including wear and notes/highlighting. We ship orders daily and Customer Service is our top priority!

Codice articolo S_429570391

Dati bibliografici

• Titolo: Beginning Databases with PostgreSQL
• Editore: Apress
• Data di pubblicazione: 2001
• Lingua: Inglese
• ISBN 10: 1861005156
• ISBN 13: 9781861005151
• Rilegatura: paperback
• Condizione: Acceptable

Descrizione articolo

Riassunto

PostgreSQL is rapidly on its way to becoming the most successful open source relational database system. It has had an explosive growth, from its mots in academia, to the Internet, through the efforts of a talented hard-working worldwide development team. The vast array of enterprise businesses migrating to PostgreSQL from proprietary databases are stark evidence for its success to come. This book is a complete tutorial on PostgreSQL features and functions beginning with the basics and building up to the design and construction of databases and integrating them with programming languages for the Web. Here we'll show you how to make the most of this fully programmable databases' powerful features like aggregate, join, transaction, inheritance, embedding your own C routines and more. Who is this book for ? This book is designed for beginners and will lead you through your very first database query, to the complex database commands needed to solve 'real world' problems. However, it's an advantage if you know the essentials of SQL programming and for specific chapters, familiarity with PHP Perl, and Java will be useful. You can set up your favourite PostgreSQL database on both Windows and UNIX systems. What does this book cover ? Detailed tutorial in PostgreSQL ; Installing from binaries and source code on UNIX and Windows ; Working with graphical tools ; Various forms of queries, subqueries, aggregate functions and joins ; Transactions, locking, stored procedures and triggers ; Performance monitoring, tuning and server control ; Connecting and executing SQL statements using C (libpq) and Embedded SQL ; Developing applications in PHP Perl and Java.