Beginning Databases with PostgreSQL: From Novice to Professional

Beginning Databases with PostgreSQL: From Novice to Professional, Second Edition|Pub. Date: April 2005 |Publisher: Apress L. P.|Format: Paperback, 664pp | Format:pdf |Series: The Expert's Voice in Open Source Series | ISBN-13: 9781590594780 |ISBN: 1590594789 |Edition Number: 2 www.woebooks.com

PostgreSQL is arguably the most powerful open-source relational database system. It has grown from academic research beginnings into a functionally-rich, standards-compliant, and enterprise-ready database used by organizations all over the world. And it's completely free to use.

See inside the book click me www.woebooks.com

Download Links www.woebooks.com

Beginning Databases with PostgreSQL offers readers a thorough overview of database basics, starting with an explanation of why you might need to use a database, and following with a summary of what different database types have to offer when compared to alternatives like spreadsheets. You'll also learn all about relational database design topics such as the SQL query language, and introduce core principles including normalization and referential integrity.

The book continues with a complete tutorial on PostgreSQL features and functions and include information on database construction and administration. Key features such as transactions, stored procedures and triggers are covered, along with many of the capabilities new to version 8. To help you get started quickly, step-by-step instructions on installing PostgreSQL on Windows and Linux/UNIX systems are included.

In the remainder of the book we show you how to make the most of PostgreSQL features in your own applications using a wide range of programming languages, including C, Perl, PHP, Java and C#. Many example programs are presented in the book, and all are available for download from the Apress web site.

By the end of the book you will be able to install, use, and effectively manage a PostgreSQL server, design and implement a database, and create and deploy your own database applications.

Table of Contents

Ch. 1 Introduction to PostgreSQL 1

Ch. 2 Relational database principles 17

Ch. 3 Getting started with PostgreSQL 43

Ch. 4 Accessing your data 73

Ch. 5 PostgreSQL command-line and graphical tools 113

Ch. 6 Data interfacing 149

Ch. 7 Advanced data selection 173

Ch. 8 Data definition and manipulation 201

Ch. 9 Transactions and locking 243

Ch. 10 Functions, stored procedures, and triggers 267

Ch. 11 PostgreSQL administration 309

Ch. 12 Database design 357

Ch. 13 Accessing PostgreSQL from C using libpq 385

Ch. 14 Accessing PostgreSQL from C using embedded SQL 419

Ch. 15 Accessing PostgreSQL from PHP 445

Ch. 16 Accessing PostgreSQL from Perl 465

Ch. 17 Accessing PostgreSQL from Java 491

Ch. 18 Accessing PostgreSQL from C# 517

App. A PostgreSQL database limits 543

App. B PostgreSQL data types 545

App. C PostgreSQL SQL syntax reference 551

App. D psql reference 573

App. E Database schema and tables 577

App. F Large objects support in PostgreSQL 581