PostgreSQL Tutorial

What is PostgreSQL?

PostgreSQL is a popular open-source object-relational database management system (RDBMS). And this the advanced topics and 30 years+ of still active development in the industry. It's a strong architecture and PostgreSQL works on all operating systems like Windows, Linux,macOS....etc. and it supports relational and non-relational queries like both SQL and JSON.

In this tutorial we will dicuss and learn all the topics of PostgreSQL like create a database, create a table, drop table, triggers, stored procedures, drop a database...etc and advance like joins, view ...etc end of this tutorial you will learn.

I hope you will complete understanding the different concepts and commands and use data in the PostgreSQL databases.

History of PostgreSQL

PostgreSQL was developed at UCB(University of California, Berkeley) it's evolved from the INGRES database project in 1982.INGRES team leader and professor Michael Stonebraker. It was originally called Postgres. PostgreSQL is the most advanced world's largest open-source database.

Ingres stands for INteractive Graphics REtrieval System.

Ingres research projects are starting in the early 1970s at the University of California, Berkeley.

Ingres is commercial database applications including Sybase, Microsoft SQL Server, Nonstop SQL

Postgres projects are started in the mid-1980s in that time later evolved PostgreSQL.

The source code of INGRES was not used for Postgres.

Stonebraker started a new company to commercialize Postgres in the 1990s (under the name of ILLUSTRA and later purchased by Informix corporation)

In 1996 the project was re-released or rename to Postgresql and reflect to support for SQL

Features of PostgreSQL is Atomicity,consistency,isolation,Durability (ACID) properties for transactions.

The function of PostgreSQL is to add a custom with help of various programming languages such as like java,c,c++ .., etc.