27 Best PostgreSQL Books of All Time

We've researched and ranked the best postgresql books in the world, based on recommendations from world experts, sales data, and millions of reader ratings. Learn more

1

PostgreSQL

Up and Running

If you’re thinking about migrating to the PostgreSQL open source database system, this guide provides a concise overview to help you quickly understand and use PostgreSQL’s unique features. Not only will you learn about the enterprise class features in the 9.2 release, you’ll also discover that PostgeSQL is more than just a database system—it’s also an impressive application platform.

With numerous examples throughout this book, you’ll learn how to achieve tasks that are difficult or impossible in other databases. If you’re an existing PostgreSQL user, you’ll pick up gems you may...
more

See more recommendations for this book...

3
Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. The book focuses on using SQL to find the story your data tells, with the popular open-source database PostgreSQL and the pgAdmin interface as its primary tools.

You'll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from the U.S. Census and other federal and state government agencies. With exercises and real-world examples in each...
more

See more recommendations for this book...

6

SQL Pocket Guide

If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2.

SQL Pocket Guide describes how these database systems implement SQL syntax for querying, managing transactions, and making changes to data. It also shows how the systems use SQL functions, regular expression...
more

See more recommendations for this book...

9
Covering advanced topics such as Warm and Hot standby restore and Streaming replication, Instant PostgreSQL Backup and Restore How-to gives you the power to make complete backups to guarantee you will always be able to restore your database to full working order!

http://www.packtpub.com/how-to-postgr...
less

See more recommendations for this book...

Don't have time to read the top PostgreSQL books of all time? Read Shortform summaries.

Shortform summaries help you learn 10x faster by:

  • Being comprehensive: you learn the most important points in the book
  • Cutting out the fluff: you focus your time on what's important to know
  • Interactive exercises: apply the book's ideas to your own life with our educators' guidance.
11

PostgreSQL для начинающих

В брошюре «PostgreSQL для начинающих» можно получить базовые сведения об устройстве и основных особенностях PostgreSQL, об истории его создания и планах развития, и практические сведения по установке PostgreSQL и начале работы с ним под Windows и Linux. Она предназначена для начинающих работать с PostgreSQL и просто интересующихся его возможностями. less

See more recommendations for this book...

13

PostgreSQL

Over the last few years PostgreSQL has emerged as a viable, even preferable, alternative to high-cost enterprise database systems such as Oracle. Large corporations or organizations using PostgreSQL include BASF (the world's leading chemical company), TiVo, USPS, and Verisign. PostgreSQL also won the 2004 Linux Journal Editors Choice Award for DMBS (database management systems). Like Paul DuBois' best-selling MySQL, Korry Douglas' PostgreSQL is the definitive, comprehensive reference on PostgreSQL for both programmers and database administrators. PostgreSQL, Second Edition leads the... more

See more recommendations for this book...

14

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

more

See more recommendations for this book...

17

Beginning PHP and PostgreSQL 8

From Novice to Professional

Beginning PHP and PostgreSQL 8 delves into some of the most popular open-source web development technologies, the PostgreSQL 8 database server and PHP 5 scripting language. You'll learn to reap the benefits of these core technologies by using them in unison to create dynamic, data-driven web applications. This is an ideal read if you are a web designer, programmer, hobbyist, or novice who wants to create applications with PHP 5 and PostgreSQL 8. less

See more recommendations for this book...

18

PostgreSQL Administration Essentials

If you are a database administrator who needs to get to grips with PostgreSQL quickly and efficiently, then this book is for you. This book will also be highly beneficial if you are a project leader or a developer who is interested in knowing more about database systems or bottleneck detection, as it will enable you to work more closely and cooperatively with your administrators. less

See more recommendations for this book...

20

PostgreSQL Replication - Second Edition

This book is ideal for PostgreSQL administrators who want to set up and understand replication. By the end of the book, you will be able to make your databases more robust and secure by getting to grips with PostgreSQL replication. less

See more recommendations for this book...

Don't have time to read the top PostgreSQL books of all time? Read Shortform summaries.

Shortform summaries help you learn 10x faster by:

  • Being comprehensive: you learn the most important points in the book
  • Cutting out the fluff: you focus your time on what's important to know
  • Interactive exercises: apply the book's ideas to your own life with our educators' guidance.
21

Learning PostgreSQL 10

* Be introduced to the concept of relational databases and PostgreSQL, one of the fastest growing open source databases in the world
* Learn client-side and server-side programming in PostgreSQL, and how to administer PostgreSQL databases
* Discover tips on implementing efficient database solutions with PostgreSQL 10
less

See more recommendations for this book...

24
Eckert's COMPTIA LINUX+ GUIDE TO LINUX CERTIFICATION, 5th Edition, empowers you with the knowledge and skills you need to succeed on CompTIA's Linux+ (Powered by LPI) Certification exam--as well as in your network administration career. The book covers the latest Linux distributions, virtualization, containerization and storage technologies. Comprehensive coverage also addresses key job-related networking and security services, including FTP, NFS, Samba, Apache, DNS, DHCP, NTP, Squid, Postfix, SSH, VNC, Spice, RDP, GPG, PostgreSQL and iptables/firewalld. Hands-on projects give you practice... more

See more recommendations for this book...

25
The most advanced, feature-rich SQL database server available, the open-source PostgreSQL system has rapidly become a key Internet technology. PostgreSQL: Introduction and Concepts, written by a founding member of the PostgreSQL Global Development Team, provides a much-needed tutorial and real-world guide to understanding and working with this complex yet essential system. Assuming no previous knowledge of database systems, the book establishes a firm foundation of basic concepts and commands before turning to PostgreSQLs more advanced and innovative capabilities. It leads you step-by-step... more

See more recommendations for this book...

Don't have time to read the top PostgreSQL books of all time? Read Shortform summaries.

Shortform summaries help you learn 10x faster by:

  • Being comprehensive: you learn the most important points in the book
  • Cutting out the fluff: you focus your time on what's important to know
  • Interactive exercises: apply the book's ideas to your own life with our educators' guidance.