Overview
- The most updated PostgreSQL book on the market, covering version 8.0
- Highlights the most popular PostgreSQL APIs, including C, Perl, PHP, and Java
- This is two books in one; it simultaneously covers key relational database design principles, while teaching PostgreSQL
Access this book
Tax calculation will be finalised at checkout
Other ways to access
About this book
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.
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.
Similar content being viewed by others
Keywords
Table of contents (18 chapters)
About the authors
Bibliographic Information
Book Title: Beginning Databases with PostgreSQL
Book Subtitle: From Novice to Professional
Authors: Neil Matthew, Richard Stones
DOI: https://doi.org/10.1007/978-1-4302-0018-5
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)
Copyright Information: Richard Stones and Neil Matthew 2005
Softcover ISBN: 978-1-59059-478-0Published: 07 April 2005
eBook ISBN: 978-1-4302-0018-5Published: 03 November 2006
Edition Number: 2
Number of Pages: XXIV, 664
Topics: Database Management, Software Engineering/Programming and Operating Systems