Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Postgresql PgAdmin for beginners
Rating: 3.6 out of 5(5 ratings)
1,480 students

Postgresql PgAdmin for beginners

Explore and Interact with PostgreSQL with PgAdmin
Last updated 3/2026
English

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

3 sections26 lectures2h 5m total length
  • Introduction0:20
  • What is PostgreSQL3:44
  • What is PgAmin0:11
  • PgAdmin and database administration2:44
  • Installing Python on Windows9:53
  • Installing Python on Macs2:54
  • Installing Python on Linux7:17
  • Install PgAdmin for Macs5:23
  • Install PgAdmin for Linux5:58
  • Connect PgAmin to PostgreSQL7:30
  • Install Sample Database9:26
  • Database Concepts8:57
  • Overview of PgAdmin2:04

Requirements

  • No experience of PostgreSQL required.

Description

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.

Who this course is for:

  • Beginners to PostgreSQL and PgAdmin