Intro To PostgreSQL Databases With PgAdmin For Beginners

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

4.50 (5987 reviews)

Udemy

platform

English

language

Data & Analytics

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

Course Gallery

Intro To PostgreSQL Databases With PgAdmin For Beginners – Screenshot 1 — Screenshot 1 – Intro To PostgreSQL Databases With PgAdmin For Beginners

Intro To PostgreSQL Databases With PgAdmin For Beginners – Screenshot 2 — Screenshot 2 – Intro To PostgreSQL Databases With PgAdmin For Beginners

Intro To PostgreSQL Databases With PgAdmin For Beginners – Screenshot 3 — Screenshot 3 – Intro To PostgreSQL Databases With PgAdmin For Beginners

Intro To PostgreSQL Databases With PgAdmin For Beginners – Screenshot 4 — Screenshot 4 – Intro To PostgreSQL Databases With PgAdmin For Beginners

Loading charts...

Comidoc Review

Our Verdict

This is a solid course for those looking to get started with PostgreSQL and SQL, but be prepared to look elsewhere for more in-depth theoretical knowledge. The outdated PgAdmin version can cause confusion, and some issues could have been resolved before publishing. However, if your focus is on learning the basics and building a strong foundation, this course is a good starting point.

What We Liked

Comprehensive coverage of PostgreSQL basics, suitable for beginners with little experience in databases and SQL
Course is broken down into manageable segments that can be easily referred back to
Provides a good foundation for using PostgreSQL and writing SQL queries
Real-world examples make the concepts more understandable

Potential Drawbacks

The course's practical focus means some theoretical aspects are not covered in depth
Outdated version of PgAdmin used, causing discrepancies with current PgAdmin UI
Some errors and issues encountered during the recording that could have been addressed in post-production
Lacks practical guidance for setting up PostgreSQL on Linux or MacOS