Introduction To PostgreSQL Databases With PgAdmin For Beginners

person icon John Elder

Introduction To PostgreSQL Databases With PgAdmin For Beginners

Intro To SQL and PostgreSQL for Creating Databases and Writing SQL Queries using PostgreSQL and PgAdmin 4

updated on icon Updated on Sep, 2023

language icon Language - English

person icon John Elder

architecture icon Business,Business Analytics & Intelligence,PostgreSQL

Lectures -24

Duration -1.5 hours


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

In this course I'll teach you how to setup and use PostgreSQL databases with the PgAdmin 4 interface! 

There's a reason why Postgres is so popular, find out why in this course!

You have many databases to choose from, and even many free databases to choose from. But Postgresql is constantly ranked a top database for everything from data analytics to basic web development - and everything in between. 

Postgres is pretty easy to use!  You'll be amazed at how quick and easy it is to dive in and get started!

In this course, you learn to:

  • Install pgAdmin and PostgreSQL

  • What Is A Database

  • pgAdmin Overview

  • Create Table Columns

  • Add Data To A Table

  • PostgreSQL Select Statements

  • PostgreSQL Where Clause

  • PostgreSQL Wildcards

  • PostgreSQL AND OR NOT

  • PostgreSQL Order By

  • PostgreSQL Insert Into

  • PostgreSQL Update

  • PostgreSQL Delete

  • PostgreSQL Limit

  • pgAdmin Menu Walkthru

  • PostgreSQL Foreign Keys

  • PostgreSQL Inner Join

  • PostgreSQL Join Where Hack

  • PostgreSQL Delete Table

  • PostgreSQL Import and Export Tables

  • PostgreSQL Backup and Restore Database

  • And More!

This course is perfect for anyone just starting out, you don't need any special skills or prior knowledge to take this course.

And as always, we offer a 100% money back guarantee if you aren't completely happy with the course.  No questions asked!

What are you waiting for, let's learn some PostgreSQL database wizardry!

-John Elder

CEO Codemy. com

Who this course is for:

  • Anyone who wants to use the PostgreSQL database with the PgAdmin 4 Interface


What will you learn in this course:

  • Understand how to use PostgreSQL Database with PgAdmin 4
  • Understand the basics of what a Database can do
  • How to Install PostgreSQL and PgAdmin 4
  • You'll Learn How To Create a Database and Table
  • How to put data in and take data out using PgAdmin
  • How to update and delete data from the database
  • How to explore what's in the database whenever you want
  • How to create basic reports with the data from your database
  • SQL Commands like UPDATE, DELETE, LIMIT, INNER JOIN, and more
  • All about Primary Keys
  • All About Foreign Keys
  • How To Backup and Restore Database
  • How To Backup and Restore Tables


What are the prerequisites for this course?

  • You don't need any special tools, we'll download everything we need for free. You just need a Windows, Mac, or Linux computer
  • You don't need any prior database experience, I'll walk you through everything
Introduction To PostgreSQL Databases With PgAdmin For Beginners


Check out the detailed breakdown of what’s inside the course

23 Lectures
  • play icon Introduction 02:22 02:22
  • play icon Installing pgAdmin and PostgreSQL 08:48 08:48
  • play icon What Is A Database 06:17 06:17
  • play icon PgAdmin Overview 05:50 05:50
  • play icon Create Table Columns 06:25 06:25
  • play icon Add Data To A Table 07:02 07:02
  • play icon PostgreSQL Select Statements 03:30 03:30
  • play icon PostgreSQL Where Clause 03:56 03:56
  • play icon PostgreSQL Wildcards 03:49 03:49
  • play icon PostgreSQL AND OR NOT 02:52 02:52
  • play icon PostgreSQL Order By 02:40 02:40
  • play icon PostgreSQL Insert Into 02:49 02:49
  • play icon PostgreSQL Update 03:05 03:05
  • play icon PostgreSQL Delete 02:30 02:30
  • play icon PostgreSQL Limit 03:27 03:27
  • play icon PgAdmin Menu Walkthru 05:39 05:39
  • play icon PostgreSQL Foreign Keys 08:50 08:50
  • play icon PostgreSQL Inner Join 07:10 07:10
  • play icon PostgreSQL Join Where Hack 03:49 03:49
  • play icon PostgreSQL Delete Table 02:20 02:20
  • play icon PostgreSQL Import and Export Tables 04:32 04:32
  • play icon PostgreSQL Backup and Restore Database 04:48 04:48
  • play icon Conclusion 04:40 04:40

Instructor Details

John Elder

John Elder

Founder of Codemy

John Elder is a pioneer in Web Development who created one of the first Internet advertising networks back in 1997. He sold it to a publicly traded company at the height of the dot com boom and then went on to create the best-selling Submission-Spider search engine submission software that's been used by over 3 million individuals and small businesses in over 45 countries. 

John graduated with honors with a degree in Economics from Washington University in St. Louis where he was an ArtSci Scholar. 

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best



Sujeet Toppo

Thank you for your effort, I am really a beginner in SQL language and your tutorials is opening for me to enter in SQL language. I would love to begin my journey with advance level soon. Thanks


Norma Espinosa

Thanks! Great for beginners like me! : )

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us