Skip to Main Content
Learn PostgreSQL
book

Learn PostgreSQL

by Luca Ferrari, Enrico Pirozzi
October 2020
Beginner content levelBeginner
650 pages
13h 25m
English
Packt Publishing

Overview

Dive into the world of PostgreSQL, one of the most powerful and versatile open-source relational databases! This book guides you through all the essentials of PostgreSQL version 12 and 13, from installation to high-performance database deployments. You'll learn how to design schemas, perform database operations efficiently, and implement advanced functionalities.

What this Book will help me do

  • Install, configure, and monitor a PostgreSQL server for optimal performance.
  • Implement SQL and PL/pgSQL scripts to build complex database solutions.
  • Analyze and optimize database schemas and indexes for efficiency.
  • Secure a PostgreSQL database and manage roles and permissions effectively.
  • Set up high-availability configurations through replication techniques.

Author(s)

None Ferrari and Enrico Pirozzi are seasoned database professionals with extensive experience in PostgreSQL. They bring practical expertise and a real-world perspective to the subject, ensuring you get hands-on knowledge and apply it effectively. Their approachable writing style simplifies even the most complex database concepts.

Who is it for?

This book is perfect for database professionals, developers, or tech enthusiasts looking to gain mastery over PostgreSQL. Whether you are new to PostgreSQL or have a fundamental understanding of databases, you'll find this book highly insightful in achieving your database management goals.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Practical PostgreSQL

Practical PostgreSQL

Joshua D. Drake, John C. Worsley
PostgreSQL High Performance Cookbook

PostgreSQL High Performance Cookbook

Dinesh Kumar, Chitij Chauhan

Publisher Resources

ISBN: 9781838985288Supplemental Content