Beginning Databases with PostgreSQL: From Novice to Professional

( 2 )
Pick Up In Store

Pick Up in Store

Reserve and pick up in 60 minutes at your local store

Paperback
$29.84
BN.com price
$44.99 List Price (Save 34%)
Marketplace (New and Used)
from
$29.68
$44.99 List Price (Save 34%)
Usually ships in 1-2 business days
All (12)  
Used (4)  
New (8)  
Close
Sort by
Page 1 of 2
Showing 1 – 10 of 12 (2 pages)
$29.68
(Save 34%)
TKH media
Seller since 2010

Feedback rating:

(203)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Clean New Book. Ship within 2 business days with tracking number where available. 2nd Edition.

Ships from: Union City, CA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
$34.14
(Save 24%)
indoo
Seller since 2007

Feedback rating:

(21685)

Condition: New
BRAND NEW

Ships from: Avenel, NJ

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
$41.77
(Save 7%)
Books For Least
Seller since 2012

Feedback rating:

(10)

Condition: New
1590594789 New Book. Minor Shelf Wear. Please contact us for any queries or concerns, we sure will fix it for you.

Ships from: Greater London, United Kingdom

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
$41.95
(Save 7%)
savethetrees
Seller since 2012

Feedback rating:

(37)

Condition: Good

Ships from: Lookout Mountain, GA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Express, 48 States
  • •Express (AK, HI)
$43.05
(Save 4%)
CourteneyCraig
Seller since 2009

Feedback rating:

(281)

Condition: New
Brand New-Fast Shipping

Ships from: Deerfield Beach, FL

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
$45.01
PaperbackshopUS
Seller since 2009

Feedback rating:

(4796)

Condition: New
Shipped from US in 4 to 14 business days. Established seller since 2000

Ships from: Aurora, IL

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
$45.91
Extremely_Reliable
Seller since 2007

Feedback rating:

(3210)

Condition: New
Buy with confidence. Excellent Customer Service & Return policy.

Ships from: Richmond, TX

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
$49.75
Sandman Book Company
Seller since 2010

Feedback rating:

(87)

Condition: Good
1590594789 Used, in good condition. Book only. May have interior marginalia or previous owner's name.

Ships from: Punta Gorda, FL

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$49.75
Crashing Rocks Bookstore
Seller since 2012

Feedback rating:

(9)

Condition: Good
PAPERBACK Good 1590594789 Used, in good condition. Book only. May have interior marginalia or previous owner's name.

Ships from: Punta Gorda, FL

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$50.77
EuroBooks
Seller since 2008

Feedback rating:

(3504)

Condition: New
Shipped from UK in 4 to 14 business days. Established seller since 2000

Ships from: Horcott Rd, Fairford, United Kingdom

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
Page 1 of 2
Showing 1 – 10 of 12 (2 pages)
Close
Sort by

Overview

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

See more details below
Sending request ...

More About This Book

Overview

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.

Product Details

  • ISBN-13: 9781590594780
  • Publisher: Apress
  • Publication date: 4/7/2005
  • Edition number: 2
  • Pages: 664
  • Sales rank: 487,460
  • Series: The Expert's Voice in Open Source Series
  • Product dimensions: 9.25 (w) x 7.50 (h) x 1.40 (d)

Meet the Author

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 Visual Basic 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 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.

Neil Matthew graduated with a degree in mathematics from the University of Nottingham in the U.K., 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.

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

Customer Reviews

Average Rating 3
( 2 )

Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(0)

2 Star

(1)

1 Star

(0)

Your Rating:

Review Guidelines
Add Recommendations
Your Name: Create a Pen Name or Leave Anonymously

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identiy on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

We're sorry, but penname is already taken.

Please select one of the following:
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

penname is available!

By visiting the BN.com website or marking a purchase on BN.com, a User is deemed to have accepted the Terms of Use.

Continue Anonymously

Welcome, penname

You have successfully created your Pen Name. Start enjoying the benefits of the BN.com Community today.

Sort by: Showing all of 2 Customer Reviews

  • Anonymous

    Posted April 25, 2005

    learn general SQL

    The book serves two audiences. One is those seeking to learn SQL. The other is those wanting to learn Postgresql. Naturally there is some overlap. But consider the first group. There are indeed several good texts on the theory of relational databases and using SQL to access and change these tables. But the books often deal at an abstract level that does not use a specific SQL implementation. Which makes it very hard to learn SQL. As a practical matter, you need to commit to an implementation, even just as a pedagogic decision. Well, as the authors explain, Postgresql is a good choice. It conforms broadly to SQL92 and is free open source. (The only other major free alternative being MySQL.) After all, you typically can't get onto a free copy of Oracle 10g or IBM's dB2 to learn from. So just from this standpoint, the book gives you a solid learning experience with SQL. Eminently transportable to a job involving a proprietary SQL, like those mentioned above. Of course, those have unique tweaks. But the methods described here are universal to the field. Now what you want to actually learn Postgresql? There are chapters on using it from the command line and so on. The book also devotes a chapter each to getting at Postgresql from C, PHP, Perl, Java and C#. Typically, you are unlikely to need all of these chapters. But it shows the flexibility of the database.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.

  • Anonymous

    Posted December 26, 2008

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews
If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)
500 character limit