Learn PostgreSQL

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



Bookstore > Books > Learn PostgreSQL

Price$44.99 - $58.08
Rating
AuthorsLuca Ferrari , Enrico Pirozzi
PublisherPackt Publishing
Published2020
Pages650
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-10183898528X
ISBN-139781838985288
EBook Hardcover Paperback

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.


  1. (2 books)
  2. (2 books)


5 5 7

Similar Books


Learning PostgreSQL

Learning PostgreSQL

by Salahaldin Juba, Achim Vannahme, Andrey Volkov

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 with a new release every year. PostgreSQL supports the most advanced features included in SQL standards. Also it provides NoSQL capabilities, and very rich data types and extensions. ...

Price:  $31.51  |  Publisher:  Packt Publishing  |  Release:  2015

Beginning PHP and PostgreSQL E-Commerce

Beginning PHP and PostgreSQL E-Commerce

by Cristian Darie, Mihai Bucica, Emilian Balanescu

The PHP language and PostgreSQL database server have long offered an ideal blend of practicality and power for both the novice and experienced programmer alike. Yet the continued evolution of both technologies makes them better suited to drive enterprise-class applications than ever before.Each chapter is devoted to a specific new feature...

Price:  $37.48  |  Publisher:  Apress  |  Release:  2006

Machine Learning with Spark

Machine Learning with Spark

by Nick Pentreath

Apache Spark is a framework for distributed computing that is designed from the ground up to be optimized for low latency tasks and in-memory data storage. It is one of the few frameworks for parallel computing that combines speed, scalability, in-memory processing, and fault tolerance with ease of programming and a flexible, expressive, ...

Price:  $34.99  |  Publisher:  Packt Publishing  |  Release:  2015

PostgreSQL for Data Architects

PostgreSQL for Data Architects

by Jayadevan Maymala

PostgreSQL is an incredibly flexible and dependable open source relational database. Harnessing its power will make your applications more reliable and extensible without increasing costs. Using PostgreSQL's advanced features will save you work and increase performance, once you've discovered how to set it up.PostgreSQL for Data...

Price:  $49.99  |  Publisher:  Packt Publishing  |  Release:  2015

PostgreSQL Cookbook

PostgreSQL Cookbook

by Chitij Chauhan

PostgreSQL is an open source database management system. It is used for a wide variety of development practices such as software and web design, as well as for handling large datasets (big data).With the goal of teaching you the skills to master PostgreSQL, the book begins by giving you a glimpse of the unique features of PostgreSQL and h...

Price:  $21.00  |  Publisher:  Packt Publishing  |  Release:  2015

PostgreSQL Server Programming, 2nd Edition

PostgreSQL Server Programming, 2nd Edition

by Usama Dar, Hannu Krosing, Jim Mlodgenski, Kirk Roybal

This book will show you that PostgreSQL is so much more than a database server. In fact, it could even be seen as an application development framework, with the added bonuses of transaction support, massive data storage, journaling, recovery, and a host of other features that the PostgreSQL engine provides.You will get to grips with creat...

Price:  $49.99  |  Publisher:  Packt Publishing  |  Release:  2015

PostgreSQL 10 Administration Cookbook

PostgreSQL 10 Administration Cookbook

by Simon Riggs, Gianni Ciolli

PostgreSQL is a powerful, open source database management system with an enviable reputation for high performance and stability. With many new features in its arsenal, PostgreSQL 10 allows users to scale up their PostgreSQL infrastructure. This book takes a step-by-step, recipe-based approach to effective PostgreSQL administration.Through...

Price:  $49.99  |  Publisher:  Packt Publishing  |  Release:  2018

Mastering Azure Machine Learning, 2nd Edition

Mastering Azure Machine Learning, 2nd Edition

by Christoph Korner, Marcel Alsdorf

Azure Machine Learning is a cloud service for accelerating and managing the machine learning (ML) project life cycle that ML professionals, data scientists, and engineers can use in their day-to-day workflows. This book covers the end-to-end ML process using Microsoft Azure Machine Learning, including data preparation, performing and logg...

Price:  $41.99  |  Publisher:  Packt Publishing  |  Release:  2022