Web Development
Data Science
Python
SQL
JavaScript
Artificial Intelligence
IT & Software
IT Certifications
Hacking
AWS
Arduino
DevOps
3D Modeling
Graphic Design
Photoshop
Drawing
Digital Painting
UX Design
Business
Data Analysis
Communication Skills
Project Management
Leadership & Management
Human Resources
Digital Marketing
Social Media Marketing
Marketing
SEO
Google Analytics
Branding
Excel
Office Productivity
SAP
PowerPoint
Microsoft Access
SharePoint
Finance & Accounting
Trading & Investing
Accounting
Bitcoin
Personal Finance
Video Editing & Animation
Photography
Adobe Premier Pro
Adobe Lightroom
Personal Development
Productivity
Career Development
Life Coaching
Health & Fitness
Meditation & Mindfulness
Yoga
Music
Music Production
Guitar
Piano
Singing
Language Learning
Teaching & Academics
Engineering
Math
LifestyleIntro To PostgreSQL Databases With PgAdmin For Beginners (Udemy.com)
Intro To SQL and PostgreSQL for Creating Databases and Writing SQL Queries using PostgreSQL and PgAdmin 4
Created by: John Elder
Last updated November 2023
What you will learn
- 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 such as SELECT, WHERE, AND, OR, NOT, ORDER BY, and INSERT INTO
- 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
How it compares
Against the other 47 rated Udemy courses in PostgreSQL on CourseDuck:
- Rating4.5 out of 5higher than 74% of them
- Reviews7,751#5 of 48 by number of reviews
- Length2 hoursshorter than 87% of them
- Last updatedNovember 2023earlier than 51% of them
Quality Score
Overall Score : 90 / 100
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!
My name is John Elder and I have nearly 40 courses here at udemy, with close to 45,000 students and over 105,000 enrollments. I've been writing code and developing neat things online for over 20 years and I'd love to teach you what I know!
What are you waiting for, let's learn some PostgreSQL database wizardry!
-John Elder
CEO Codemy. com
Udemy Discount
The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.
Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.
Instructor Details
- 4.5 Rating
7,751 Reviews
John Elder
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.
Today he teaches Web Development courses at Codemy the online code school he founded.
John graduated with honors with a degree in Economics from Washington University in St. Louis where he was an ArtSci Scholar.
More courses by John Elder
Build An API With The Django Rest Framework Using Python (2023)
4.5 (1,229 Reviews)
Provider: Udemy
Time: 1.4h
$54.99
Top Node and Javascript Bundle: Learn Node and JS (2023)
4.3 (1,126 Reviews)
- Provider: Udemy
- Time: 8.2h
$11.99
Build a Stock Market Web App With Python and Django (2023)
4.6 (946 Reviews)
- Provider: Udemy
- Time: 3.8h
$11.99
More PostgreSQL courses
The Complete SQL Bootcamp: Go from Zero to Hero (2022)
4.7 (258,007 Reviews)
- Provider: Udemy
- Time: 8.9h
$159.99
SQL and PostgreSQL: The Complete Developer's Guide (2026)
4.7 (13,224 Reviews)
- Provider: Udemy
- Time: 22.2h
$139.99
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL (2025)
4.7 (5,426 Reviews)
- Provider: Udemy
- Time: 12.7h
$15.99
Zero to Hero in SQL: SQL for Data Analytics (2026)
4.6 (14,123 Reviews)
- Provider: Udemy
- Time: 10.4h
$129.99
SQL and PostgreSQL for Beginners: Become a SQL Expert (2026)
4.6 (8,732 Reviews)
- Provider: Udemy
- Time: 12.3h
$139.99
PostgreSQL Database Administration on Windows/Linux- Part 1 (2025)
4.6 (7,007 Reviews)
- Provider: Udemy
- Time: 14.3h
$74.99
Reviews
By Sahadev Sharma on 7/17/2026
some tricky things which are most impostratant should be covered for example in PostgreSQL using wildcard is no simple like other RDBMS, it requires collation, which is fully missed. How to create foriegn table is not coverted which is not so simple.
By Monica Jackson on 6/17/2026
John is an excellent and engaging instructor. The best online course and instructor I experienced in a while. Will be taking his other courses via Udemy and/or Codemy.
By Joseph Lephoto on 5/13/2026
Brilliant presentation and explanation, really enjoyed the cause I have knowledge of SQL so this provided an understand and how to apply PostgreSQL
By Madhavi Sutar on 4/24/2026
Very good beginners course, to the point, Could follow and practice simultaneously easily. Would recommend to my colleagues . Thankyou
By Francesco Chiappalone on 4/16/2026
Clear and easy-to-follow course. The instructor is friendly and very natural. It’s a basic course; it doesn’t go into detail or dwell on complex explanations, but it achieves its goal of providing a foundation for beginners and for further learning.
By Arnold Gimeno on 2/10/2026
Concise, straight to the point, and engaging from start to finish. There’s no dull moment—everything is simple, quick, and easy to follow. I especially loved the bonus section introducing his website, where students can enjoy an incredible deal: access to all 60 courses for just $49 with lifetime access. Excellent value and a fantastic learning experience overall. ⭐⭐⭐⭐⭐
By Samuel Malcolm on 2/5/2026
This course was informative and straightforward, easy to understand and broken down into small enough bits that I don't lose focus too often. Was a great course.
By Donald Hoover on 1/27/2026
A very basic and barebones SQL course. The overview of PgAdmin UI was fine. Very little Postgres specific information, it was mostly simple ANSI SQL.
By Analyn Deximo on 1/22/2026
This course is exceptionally well-suited for beginners, as it is designed to be easily comprehensible and accessible. The clarity of the material ensures that new learners can grasp the concepts without difficulty, making it an ideal choice for those just starting their journey in this field.
By Paolo Guagliumi on 12/10/2025
Un ottimo corso, molto chiaro, simpatico e coinvolgente l'istruttore, fornisce gli elementi di base per approcciarsi ad un db PostgreSQL e a PgAdmin.
- Video Duration:
2h - Price: $54.99
- Provider: Udemy
- Updated:
November 2023 - Level:
Beginner - Language:
English - Certificate:
Yes
30-day money-back guarantee on most paid courses
Udemy Coupon Price Tracker
