PostgreSQL, also known as Postgres, is a popular free and open source relational database management system. Postgres is a great technology to learn. It is a powerful, secure, and fast relational database system that is growing in popularity. It is a mature, stable database that has been around for over 30 years. Postgres runs on a wide variety of operating systems, including Linux, Windows, macOS, and it even runs in the cloud. Postgres helps you to maintain the integrity of your data. It has a robust set of features, and is even extensible if you ever need to do something unconventional that it doesn’t already do.
If you want to learn the basics of Postgres development, Essential Postgres is for you. This book gets right to the point, and gives you exposure to the most used – and useful – parts of database development using Postgres version 13. Writing SQL statements, creating tables, functions, triggers, views, as well as data integrity are explained.