Learning PostgreSQL

Learning PostgreSQL cover
Good Books rating 3.83
Buy online
Technical
  • ID: 8613
  • Added: 2025-12-22
  • Updated: 2025-12-22
  • ISBN: 9781783989195
  • Publisher: Packt Publishing Ltd
  • Published: 2015-11-30
  • Reviews: 3

Learning PostgreSQL is a comprehensive guide designed for students, database developers, and administrators interested in developing and maintaining PostgreSQL databases. The book starts with the basics of relational databases and PostgreSQL, covering data definition and manipulation languages, and advanced topics like locking and multi-version concurrency control. It then delves into implementing data models, creating tables, setting up integrity constraints, building indexes, and defining views. The book also explores PostgreSQL's NoSQL capabilities, including Hstore, XML, Json, and arrays. By the end, you'll learn to use the JDBC driver and manipulate data objects in the Hibernate framework, making this book an essential resource for anyone looking to harness the power of PostgreSQL in their applications. This practical guide is an easy-to-follow resource for learning to program, build applications with PostgreSQL, and manage a PostgreSQL database instance. It provides detailed knowledge of the main PostgreSQL building objects, most used extensions, and practices database development life cycle including analysis, modeling, testing, bug fixes, and refactoring.

Reviews
Goodreads · 2025-05-24
good 3.70

PostgreSQL is praised for its power and ease of use, with strong community support and active development. The book is seen as a valuable resource for both beginners and experienced users.

The reviewer highlights PostgreSQL as one of the most powerful and user-friendly database management systems available. They appreciate the strong community support and the active development that keeps the system up-to-date. The book is described as a comprehensive guide that covers a wide range of topics, making it suitable for both beginners and those with more experience. The practical examples and clear explanations are particularly noted as strengths.


Quick quotes

    PostgreSQL is one of the most powerful and easy to use database management systems.

    It has strong support from the community and is being actively developed.

    This book is a valuable resource for anyone looking to learn or improve their skills with PostgreSQL.

Articly.in · 2025-05-24
positive 4.50

The reviewer shares their positive experience with learning PostgreSQL, finding it a tool they can grow with. The book is seen as a practical and engaging resource.

The reviewer shares their journey of learning PostgreSQL, highlighting the book as a practical and engaging resource. They appreciate the hands-on approach and the clear explanations provided. The book is seen as a valuable tool for beginners, offering a solid foundation in PostgreSQL. The reviewer notes that the book helped them set up and understand PostgreSQL locally, making it a useful companion for their learning journey.


Quick quotes

    It felt like a tool I could grow with.

    The book is a practical and engaging resource for learning PostgreSQL.

    It helped me set up and understand PostgreSQL locally.

Amazon · 2015-11-30
moderate 3.30

The book is rated moderately, with praise for its content but some criticism for its presentation. It is seen as a useful guide for learning PostgreSQL, though not without its flaws.

The reviewer gives the book a moderate rating, acknowledging its usefulness as a learning resource. They appreciate the depth of information provided but note that the presentation could be improved. The book is seen as a good starting point for those new to PostgreSQL, but it may not be as comprehensive as some other resources. The reviewer suggests that while the book has its merits, it might not be the best choice for those looking for an in-depth guide.


Quick quotes

    This book is a useful guide for learning PostgreSQL.

    The presentation could be improved to make it more accessible.

    It's a good starting point but may not be as comprehensive as other resources.