Learn PostgreSQL

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



Bookstore > Books > Learn PostgreSQL

Price$40.88 - $60.63
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)



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

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

Price:  $39.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:  $26.99  |  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:  $29.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:  $39.99  |  Publisher:  Packt Publishing  |  Release:  2018

PostgreSQL 9.0 High Performance

PostgreSQL 9.0 High Performance

by Gregory Smith

Learn the right techniques to obtain optimal PostgreSQL database performance, from initial design to routine maintenance. Discover the techniques used to scale successful database installations. Avoid the common pitfalls that can slow your system down. Filled with advice about what you should be doing; how to build experimental databases ...

Price:  $29.99  |  Publisher:  Packt Publishing  |  Release:  2010

PostgreSQL Server Programming

PostgreSQL Server Programming

by Hannu Krosing, Kirk Roybal, Jim Mlodgenski

Learn how to work with PostgreSQL as if you spent the last decade working on it. PostgreSQL is capable of providing you with all of the options that you have in your favourite development language and then extending that right on to the database server. With this knowledge in hand, you will be able to respond to the current demand for adv...

Price:  $29.99  |  Publisher:  Packt Publishing  |  Release:  2013

Machine Learning Yearning

Machine Learning Yearning

by Andrew Ng

AI is transforming numerous industries. Machine Learning Yearning, a free ebook from Andrew Ng, teaches you how to structure Machine Learning projects.This book is focused not on teaching you ML algorithms, but on how to make ML algorithms work. After reading Machine Learning Yearning, you will be able to: Prioritize the most promising di...

Publisher:  Self-publishing  |  Release:  2018