 |
Beginning Databases with PostgreSQL: From Novice to Professional, 2nd Edition
Read an excerpt:
Chapter 2: Relational Database Principles
Excerpt provided courtesy of Apress. Copyright © Apress. Written permission from the publisher is required for any use of this material.
|
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
PostgreSQL is one of the world's most popular open source relational database systems. It is renowned for its wide range of capabilities and its ability to perform functions not available in other databases. This book will provide you with the tools to transition into PostgreSQL for the first time, and it will introduce you to the product's most prominent features.
You will learn simultaneously about key relational database design and management principles—all to help you effectively manage your data-driven application. Also included is extensive coverage of the most popular PostgreSQL APIs, including PHP, Perl, Java, and C. You will benefit from the generous reference material covering PostgreSQL data types, syntax, the psql client, and large object support.
Table of Contents
About the Authors
Acknowledgments
Introduction
About the Technical Reviewer
CHAPTER 1 Introduction to PostgreSQL
CHAPTER 2 Relational Database Principles
CHAPTER 3 Getting Started with PostgreSQL
CHAPTER 4 Accessing Your Data
CHAPTER 5 PostgreSQL Command-Line and Graphical Tools
CHAPTER 6 Data Interfacing
CHAPTER 7 Advanced Data Selection
CHAPTER 8 Data Definition and Manipulation
CHAPTER 9 Transactions and Locking
CHAPTER 10 Functions, Stored Procedures, and Triggers
CHAPTER 11 PostgreSQL Administration
CHAPTER 12 Database Design
CHAPTER 13 Accessing PostgreSQL from C Using libpq
CHAPTER 14 Accessing PostgreSQL from C Using Embedded SQL
CHAPTER 15 Accessing PostgreSQL from PHP
CHAPTER 16 Accessing PostgreSQL from Perl
CHAPTER 17 Accessing PostgreSQL from Java
CHAPTER 18 Accessing PostgreSQL from C#
APPENDIX A PostgreSQL Database Limits
APPENDIX B PostgreSQL Data Types
APPENDIX C PostgreSQL SQL Syntax Reference
APPENDIX D psql Reference
APPENDIX E Database Schema and Tables
APPENDIX F Large Objects Support in PostgreSQL
INDEX
About the Authors
Neil Matthew graduated with a degree in mathematics from the University of Nottingham in the UK and has been using and programming computers for over 30 years. Neil has used just about every flavor of UNIX since 1978, right up to today's Linux distributions. He has co-authored several computing books with Richard Stones, including Beginning Linux Programming, Professional Linux Programming, and Beginning Databases with MySQL.
Richard Stones graduated from university with an electrical engineering degree, but decided software was more fun. He has programmed in a variety of languages, but only admits to knowing VB under duress. He has worked for a number of companies, from the very small to the very large, in a variety of areas, from real-time embedded systems upward. He is currently employed by Celesio AG as a systems architect, working principally on systems for the retail side of the business. He has co-authored several computing books with Neil Matthew, including Beginning Linux Programming, Professional Linux Programming, and Beginning Databases with MySQL.
|
|
