Last Updated: March 14, 2019

PostgreSQL (also known as Postgres) is an object-relational database management system (ORDBMS). PostgreSQL was first released in 1996. some of it’s features include being ACID-compliant, transactional, updatable views, materialized views, triggers, foreign keys, supports functions and more. Here’s the best PostgreSQL tutorials and best PostgreSQL books to help you learn PostgreSQL in 2019.

 

Best PostgreSQL courses & tutorials 2019

 

The Complete Python & PostgreSQL Developer Course

The Complete Python & PostgreSQL Developer Course by Rob Percival and Jose Salvatierra will help you learn PostgreSQL with Python. This will take you from absolute PostgreSQL beginner to experienced PostgreSQL developer. You will understand software and programming with Python. This PostgreSQL course will help extend Python applications by using PostgreSQL. PostgreSQL allows your applications to store, retrieve, and filter through large data sets easily. You will understand advanced PostgreSQL concepts like data structures and algorithms. They will help you with job interviews. This is the best PostgreSQL tutorial in 2019.

 

SQL & Database Design A-Z: Learn MS SQL Server + PostgreSQL

SQL & Database Design A-Z: Learn MS SQL Server + PostgreSQL by Kirill Eremenko and Ilya Eremenko will teach you both PostgreSQL and SQL Server. You will learn PostgreSQL queries and PostgreSQL database design. This PostgreSQL video tutorial focuses on learning by doing real world PostgreSQL examples. Focus is placed on learning the concepts of Database design.

The Beginners Guide to SQL and PostgreSQL

The Beginners Guide to SQL and PostgreSQL by Jon Avis will teach you to master SQL and PostgreSQL.  You will learn how to retrieve data from database tables using the SELECT statement. This PostgreSQL programming course will teach you to use JOINs to retrieve data from multiple tables. You will learn to use aggregate functions and group data. This PostgreSQL online training contains PostgreSQL exercises and solutions. This is the best PostgreSQL tutorial for beginners in 2019.

 

PostgreSQL: From Zero to Hero

PostgreSQL: From Zero to Hero by Will Bunker will teach you how to use PostgreSQL. You will learn how use basic selection statements. This PostgreSQL online course will teach you to constrain data input using field and table constraints. These constraints will keep the data clean You will group records to get aggregate data. This PostgreSQL interactive tutorial will teach you how to create tables and indexes. You will learn how to the process of inserting, updating and deleting records. You will learn how to use the pgAdmin tool.

 

Best PostgreSQL books 2019

 

Bestsellers

SaleBestseller No. 1
Beginning Databases with PostgreSQL: From Novice to Professional (Beginning From Novice to Professional)
  • Used Book in Good Condition
  • Richard Stones, Neil Matthew
  • Publisher: Apress
  • Edition no. 2 (09/06/2007)
  • Paperback: 664 pages
SaleBestseller No. 2
PostgreSQL: Up and Running: A Practical Guide to the Advanced Open Source Database
  • Regina O. Obe, Leo S. Hsu
  • Publisher: O'Reilly Media
  • Edition no. 3 (10/30/2017)
  • Paperback: 314 pages
SaleBestseller No. 3
Practical SQL: A Beginner's Guide to Storytelling with Data
  • Anthony DeBarros
  • Publisher: No Starch Press
  • Paperback: 392 pages
Bestseller No. 5
PostgreSQL 11 Administration Cookbook: Over 175 recipes for database administrators to manage enterprise databases
  • Simon Riggs, Gianni Ciolli, Sudheer Kumar Meesala
  • Publisher: Packt Publishing
  • Paperback: 600 pages
Bestseller No. 6
PostgreSQL 10 Administration Cookbook: Over 165 effective recipes for database management and maintenance in PostgreSQL 10
  • Gianni Ciolli, Simon Riggs
  • Packt Publishing
  • Kindle Edition
  • Edition no. 1 (05/18/2018)
  • English
Bestseller No. 7
Learning PostgreSQL 10 - Second Edition: A beginner's guide to building high-performance PostgreSQL database solutions
  • Salahaldin Juba, Andrey Volkov
  • Packt Publishing
  • Kindle Edition
  • Edition no. 2 (12/01/2017)
  • English
Bestseller No. 8
PostgreSQL High Availability Cookbook - Second Edition
  • Shaun M. Thomas
  • Publisher: Packt Publishing - ebooks Account
  • Edition no. 2 (02/08/2017)
  • Paperback: 536 pages
Bestseller No. 9
PostgreSQL 11 Documentation Manual Version 11.2: Volume 1 Chapters 1-36
  • PostgreSQL Global Development Group
  • Publisher: 12th Media Services
  • Paperback: 1142 pages
SaleBestseller No. 10
PostgreSQL 9 Admin Cookbook
  • Simon Riggs, Hannu Krosing
  • Publisher: Packt Publishing
  • Paperback: 360 pages

Beginning Databases with PostgreSQL

Sale
Beginning Databases with PostgreSQL: From Novice to Professional (Beginning From Novice to Professional)
  • Used Book in Good Condition
  • Richard Stones, Neil Matthew
  • Publisher: Apress
  • Edition no. 2 (09/06/2007)
  • Paperback: 664 pages

Beginning Databases with PostgreSQL: From Novice to Professional by Richard Stones and Neil Matthew will help you learn PostgreSQL features and functions. This PostgeSQL book covers key relational database design principles and teaches PostgreSQL. You will also learn all about relational database design topics such as the SQL query language, introduce core principles including normalization and referential integrity. This PostgreSQL book will show you how to make the most of PostgreSQL features in your own applications. You will integrate with programming languages like C, Perl, PHP, Java and C#. This is one of the best PostgreSQL book in 2019.

 

 

Learning PostgreSQL 10 – Second Edition: A beginner’s guide to building high-performance PostgreSQL database solutions

Learning PostgreSQL 10 - Second Edition: A beginner's guide to building high-performance PostgreSQL database solutions
  • Salahaldin Juba, Andrey Volkov
  • Publisher: Packt Publishing - ebooks Account
  • Edition no. 2 (12/01/2017)
  • Paperback: 488 pages

Learning PostgreSQL by Salahaldin Juba, Achim Vannahme and Andrey Volkov is a comprehensive guide to learn about procedural language and PL/pgSQL. This PostgreSQL book will help you learn to create, develop and manage relational databases. You will learn the PostgreSQL development life cycle including testing and refactoring.  This book will teach you the concepts of data modelling and relation algebra. This is one of the best PostgreSQL book for beginners in 2019.

 

PostgreSQL 10 High Performance: Expert techniques for query optimization, high availability, and efficient database maintenance

PostgreSQL 10 High Performance: Expert techniques for query optimization, high availability, and efficient database maintenance
  • Ibrar Ahmed, Gregory Smith, Enrico Pirozzi
  • Packt Publishing
  • Kindle Edition
  • Edition no. 1 (04/30/2018)
  • English

PostgreSQL High Performance by Gregory Smith is a step-by-step guide to optimizing and scaling up PostgreSQL database servers. This book will help you improve database performance.  You will understand the theoretical concepts by working through hands-on examples. You will learn the right techniques to obtain optimal PostgreSQL database performance, from initial design to routine maintenance. This PostgreSQL book is filled with advice about databases and performance topics.

 

PostgreSQL 10 Administration Cookbook: Over 165 effective recipes for database management and maintenance in PostgreSQL 10

PostgreSQL Administration Cookbook by Simon Riggs, Gianni Ciolli and Gabriele Bartolini contains over 150 recipes to help you administer your PostgreSQL database more efficiently. This book is a step-by-step recipe-based guide. It will help you tackle any problem in PostgreSQL administration with ease. You will learn how to monitor, tune, secure and protect your database. This book will teach you the capabilities of PostgreSQL 9.6 to administer your database more efficiently.

 

PostgreSQL High Availability Cookbook

PostgreSQL High Availability Cookbook - Second Edition
  • Shaun M. Thomas
  • Publisher: Packt Publishing - ebooks Account
  • Edition no. 2 (02/08/2017)
  • Paperback: 536 pages

PostgreSQL High Availability Cookbook by Shaun M. Thomas teaches PostgreSQL new features. These features make the PostgreSQL more efficient and adaptive. This PostgeSQL book will help you create a PostgreSQL cluster that stays online even when disaster strikes. You will learn how to automate monitoring and alerts.

 

 

Amazon Associates Disclosure: We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.

Last update on 2019-05-20 / Affiliate links / Images from Amazon Product Advertising API