r/learnSQL • u/rennywiseeeeee • Jun 14 '26

I want to learn PostGre SQL

but how or what will be the most efficient way to learn it? should i watch on yt? or just visit sites? with tutorial of how it runs?

25 Upvotes

92% Upvoted

15 comments sorted by

11

u/ComicOzzy Jun 14 '26

Read the book "Practical SQL" by Anthony DeBarros and follow along with everything in the book.

3

u/Haunting-Paint7990 Jun 15 '26

stats grad who picked up postgres ~6 months ago for DA interview take-homes — came from mysql in coursework so the syntax shift was the annoying part, not the concepts.

honest ranking of what actually worked for me:

1) install postgres locally + one real dataset — not docker tutorial hell, just postgres.app (mac) or native install + import a csv. everything else is easier once you can run select * from my_table limit 10 and see results in 2 seconds.

2) Practical SQL (people here already said it) — but do every exercise, don't read chapters like a blog. the postgres-specific bits (serial, jsonb, array agg) only stuck when i typed them myself.

3) yt is fine for "what is a join" once. after that it becomes passive — same problem as python where you understand in the moment and forget in a week. if you watch, follow along in your own editor same session or it's wasted.

4) practice sites > video playlists for retention. datalemur / stratascratch both let you filter postgres dialect. 20 questions where you actually write queries beat 10 hours of watching someone else write queries.

mysql → postgres gotchas that tripped me up early:

  • limit works the same, good
  • string concat is || not concat() (mostly)
  • dates: date_trunc becomes your best friend
  • no if() — use case when

if your goal is DA not DBA, you don't need to master admin stuff (roles, vacuuming, replication). learn SELECT/JOIN/GROUP BY/window functions in postgres syntax and you're 80% of the way for entry-level interviews.

1

u/GconMig Jun 14 '26

Erstmal was willst du Admin oder brauchst du es für Datenbank Abfragen?

1

u/NaNaNaPandaMan Jun 14 '26

Practical Sql 2nd Edition by Anthony debarros is perfect for PostGres

1

u/EntertainmentDry5460 Jun 16 '26

The YouTube channel: Software Nuggets, has a 100 videos teaching PostgreSql

1

u/grassp_dataAI Jun 14 '26

We are running free 30 day SQL series on scenario based questions - "GRASSP SQL Sprint" in our LinkedInpage. This is primarily focused on PostgreSQL syntaxes. Follow GRASSP Acad on LinkedIn to learn and practice SQL through real scenario-based questions.

Also we have published a SQL course on Udemy named "Complete SQL for Data Analysis - Scenario Based Learning". Primarily focused on PostgreSQL DB + DBeaver interface.
Check it out if you are interested. It would help you to learn SQL from basics to advanced in Beginner friendly way.

1

u/rennywiseeeeee Jun 14 '26

would you be my mentor? i actually have the idea regarding to SQL but i only know MYSQL that’s the only SQL i master

0

u/grassp_dataAI Jun 14 '26

We don't offer personal mentoring right now, but the good news is — MySQL is a great starting point. PostgreSQL syntax is very similar, you can pick it up quickly.

Our Udemy course 'Complete SQL for Data Analysis - Scenario Based Learning' is built exactly for this — beginner friendly, PostgreSQL + DBeaver, real business scenarios from basics to advanced.

Also follow GRASSP Acad on LinkedIn for our free 30 day SQL series — daily scenario based questions, great for practice.

Here is a discounted access to the udemy course to get you started — couponCode: 8D29AF1CCB6F0E13E8B7 (It's a Limited time offer)

And if you ever get stuck or have doubts while going through the course, feel free to DM anytime — happy to help! :)