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.43 (3538 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

Why take this course?

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

Screenshots

Intro To PostgreSQL Databases With PgAdmin For Beginners - Screenshot_01

Intro To PostgreSQL Databases With PgAdmin For Beginners - Screenshot_02

Intro To PostgreSQL Databases With PgAdmin For Beginners - Screenshot_03

Intro To PostgreSQL Databases With PgAdmin For Beginners - Screenshot_04

Reviews

Rajanikanth

April 11, 2024

Little more topics need to be add in Joins part only discussed inner join need to cover more topics like views and procedures and functions and packages and triggers it would be better to

Keval

April 9, 2024

Content was good and engaging, and what to say about the instructor... he has explained everything in a fun way! Thanks a lot :)

Vasupradha

November 29, 2023

Good Course, Bonus lecture is nothing but promotion of codemy but overall for a fresher, it is good enough to learn

ŁUKASZ

November 8, 2023

It is PostgreSQL for beginners, as described. More advanced students might want to looks somewhere else for more in-depth course. For people like me, having no prior experience with the subject, this is very good place to begin.

Moharana

October 26, 2023

His explanation is exceptionally clear and easy to comprehend. I feel confident in applying this to my project. Thank you for the beautifully articulated explanation.

Wayne

August 28, 2023

This course was mostly a review for me, but was well organized and covered the basics in a short amount of time.

Erno

August 18, 2023

I think it was quick and easy introduction to PostgresSQL databases. Only thing I would add is some exercise to create third table. That can of course be done after the course, but repetition is the key in the beginning.

Tony

July 14, 2023

As a DBA working with MS SQL Server since the 4.2 days, I was just looking for an overview of Postgres. This covered that from a "using the product" angle...get it installed, create some tables, queries, backups/restore....now on the hunt for a similar intro to the administration and performance tuning side ;)

BOYALLA

July 12, 2023

Trainer can show up more confidence while training the students.. Overall a good course for a beginner

Jeff

July 11, 2023

Lots of fumbling around, doesn't seem like an advanced/expert instructor of postgresql. Covered the basics though, just could have been cut down by 75% without the silly user errors

Andrew

June 16, 2023

The difference between the current Windows PGAdmin and the one used in the demo is now so great it detracts from the course material. Current is desktop app not browser-based and most dialogs have changed format, icons and terminology in some way.

Aearha1

June 13, 2023

I am using a mac in 2023 and my options are nothing like what is shown on the screen. Please update the course or recommend a different one for mac users.

james

May 27, 2023

What's nice about John's style is that he works through things in real time, mistakes and all, which helps a beginner see where things can go wrong and how to fix them.

Robert

April 30, 2023

Teacher seems unconfident using Postgresql GUI OR could be very intelligent and doesn' t know how to simplify what he's explaining to a beginner.

Gary

March 10, 2023

Overall the class was good and provided what I needed. To be able to navigate around Postgresql/PgAdmin, create databases and use SQL to test them. John is very animated during the videos which aren't scripted unlike some other courses and at times he seems to lose this train of thought as a result. In a couple of spots in the videos, he is defining items and he appears to be unsure of how to do finish the configuration almost as if he doesn't have enough experience with PgAdmin. It might be worth his time to re-shoot some of the videos. The transition between some of the videos is a little disjointed especially when you are following along and he has added data to the tables between videos. Again, overall not a bad class, with a little more thought and effort it could be a great course.

Charts

Price

Rating

Enrollment distribution

Intro To PostgreSQL Databases With PgAdmin For Beginners - Distribution chart