Postgresql PgAdmin for beginners

Explore and Interact with PostgreSQL with PgAdmin

PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley.

What you’ll learn

  • PostgreSQL Database Setup on Windows , Mac , Linux.
  • Connect to PostgreSQL with PgAdmin.
  • Load sample database into PostgreSQL.
  • Explore database objects in PostgreSQL.
  • Create Database.
  • Create Table.

Course Content

  • PostgreSQL | PgAdmin Setup –> 11 lectures • 1hr 2min.
  • Exploring PostgreSQL Database Objects with PgAdmin –> 12 lectures • 57min.

Auto Draft

Requirements

  • No experience of PostgreSQL required..

PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley.

PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying.

PostgreSQL is a highly stable database backed by more than 20 years of development by the open-source community.

PostgreSQL is used as a primary database for many web applications as well as mobile and analytics applications.

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world. pgAdmin may be used on Linux, Unix, macOS and Windows to manage PostgreSQL and EDB Advanced Server 10 and above.

The PostgreSQL is a database engine implementing SQL standards. It usually listen as a server on a network tcp port to provide its abilities. The pgAdmin is a sort of client. You are able to manipulate schema and data on an instance or multiple instances of PostgreSQL engines.

Pgadmin tool can be used to connect to and interact with PostgreSQL  Server and databases.

Get Tutorial