What do you get with Print?

Instant access to your digital eBook copy whilst your Print order is Shipped

Paperback book shipped to your preferred address

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Introduction to PostgreSQL

PostgreSQL is a well-known open-source relational database, and its motto states what the project intends to be: the most advanced open-source database in the world.

The main qualities that attract masses of new users every year and keep current users enthusiastic about their projects are its rock-solid stability, scalability, and safeness, as well as the features that an enterprise-level database management system provides.

But PostgreSQL is not just a database; it has grown to be a whole ecosystem of extensions, tools, and languages tied together by communities spread around the world.

PostgreSQL is an open-source project and is fully developed in the open-source world. That means that there is no single entity in charge of the project and the result is that PostgreSQL is not a commercial product. In other words, PostgreSQL belongs to everyone, and...

Key benefits

Set up your database cluster and monitor, secure, and fine-tune it for optimal performance

Learn the fundamentals of database management and implement client- and server-side programming using SQL and PL/pgSQL

Explore useful tips to develop efficient PostgreSQL database solutions from scratch

Description

PostgreSQL is one of the fastest-growing open source object-relational database management systems (DBMS) in the world. As well as being easy to use, it’s scalable and highly efficient. In this book, you’ll explore PostgreSQL 12 and 13 and learn how to build database solutions using it. Complete with hands-on tutorials, this guide will teach you how to achieve the right database design required for a reliable environment. You'll learn how to install and configure a PostgreSQL server and even manage users and connections. The book then progresses to key concepts of relational databases, before taking you through the Data Definition Language (DDL) and commonly used DDL commands. To build on your skills, you’ll understand how to interact with the live cluster, create database objects, and use tools to connect to the live cluster. You’ll then get to grips with creating tables, building indexes, and designing your database schema. Later, you'll explore the Data Manipulation Language (DML) and server-side programming capabilities of PostgreSQL using PL/pgSQL, before learning how to monitor, test, and troubleshoot your database application to ensure high-performance and reliability. By the end of this book, you'll be well-versed with the Postgres database and be able to set up your own PostgreSQL instance and use it to build robust solutions.

Who is this book for?

This Postgres book is for anyone interested in learning about the PostgreSQL database from scratch. Anyone looking to build robust data warehousing applications and scale the database for high-availability and performance using the latest features of PostgreSQL will also find this book useful. Although prior knowledge of PostgreSQL is not required, familiarity with databases is expected.

What you will learn

Understand how users and connections are managed by running a PostgreSQL instance

Interact with transaction boundaries using server-side programming

Identify bottlenecks to maintain your database efficiently

Create and manage extensions to add new functionalities to your cluster

Choose the best index type for each situation

Use online tools to set up a memory configuration that will suit most databases

Explore how Postgres can be used in multi-instance environments to provide high-availability, redundancy, and scalability

What do you get with Print?

Instant access to your digital eBook copy whilst your Print order is Shipped

Paperback book shipped to your preferred address

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Frequently bought together

€32.99

€36.99

PostgreSQL 12 High Availability Cookbook

€36.99

Total € 106.97 Stars icon

Kindleのお客様 Mar 15, 2023

Not too happy with this one. The writing is poor and the examples are confusing. Sometimes the examples don't even use the feature they are supposed to be showing. The whole thing feels unorganized and just thrown together in random order without much thought. It also lacks the depth that I was hoping for.

Amazon Verified review

Chris Feb 18, 2023

I have been looking for a resource to streamline my learning of postgresql and also learn SQL at the same time on Ubuntu 20.04 which ships with Postgresql 12. I have been scanning through this book and it seems to have everything I wanted. Info on psql and intro SQL material. I do not see the major issues that the other reviewer saw. I think it is perfectly readable and wish I had not been discuoraged by those comments initially. It is also evident in the sample of the book that formatting is fine. Just take a look.

fkasulke Mar 24, 2021

Ich liebe Fach-Bücher. Da kann man eine Randnotiz hinzufügen und auch ein paar Blätter einlegen, wenn im Inhalt mal was fehlt. Ich geniesse es, bequem im Sessel zu sitzen, anstatt verkrampft auf den Bildschirm zu starren.Nach 2 Tagen habe ich die Replikation und die Partitionierung mit Bedingungen eingerichtet.Inhalt ist gut strukturiert und ausreichend ausführlich, was bei "modernen Fach-Comics" anderer Verlage nicht immer der Fall ist.

George Jempty Jan 16, 2021

Not the author's fault but anybody intending to buy the Kindle version needs to know this. When you get to the part on SQL commands like insert and select, the number of characters per line decrease and decrease until there's only one per line. Simply unacceptable.

JOSE R. Dec 07, 2020

El libro no entra en todas y cada una de las posibilidades de cada concepto y comando, enseña lo necesario para empezar de forma que no abrume, pero si cita donde se pueden ampliar los conocimientos.Me leí la documentación oficial, y para empezar y aprender es mejor un libro de estas características, luego cada uno es libre de profundizar mas en cada tema. Lo bueno es que como digo no abruma y da buenas explicaciones. Una vez acabe el libro, se consigue un nivel básico que ayuda a saber donde seguir para profundizar mas, de forma amena, pero sin escatimar en las explicaciones cuando hay que darlas.

Learn PostgreSQL: Build and manage high-performance database solutions using PostgreSQL 12 and 13

What do you get with Print?