PostgreSQL CRASH COURSE - Learn PostgreSQL in 2024

Thank you for watching! If you enjoyed please consider subscribing and liking the video.

Tools used (for mac, pc users try pgAdmin)

[TroiCodes]

Full Postgres Course available for 90% off:

My course is focused on the most practical parts of postgres and the goal is to teach you the most useful things as quickly as possible.

[Sara-xiug]

I'd rename it to "SQL crash course"

[boxboxerson]

This is one of the only programming tutorials on the site that deserves its title. You didn't assume I knew anything but you didn't insult my intelligence either. Half of the video isn't being dedicated to setup and you jump in with practical examples. You don't have any annoying ticks and you're not just reading off of documentation. I don't like being meaninglessly positive, if your work isn't good you shouldn't be praised for it, but this video really deserves all the praise in the world. Maybe it would have been good to cover some initial setup but as you rightly point out near the start the docs are there there for a reason.

[doug_horne]

Great video man. Your teaching style is enthusiastic (but not overly done), clear, and concise. Thanks cor creating this, a real time saver for me. I came here because I am learning how to use Prisma + Railway and had no idea how to create and manipulate tables in PostgreSQL, so I had no idea how to create a scheima. 👍

[adamkostandy]

Dude you need to make the advanced tutorial. This was sick, also that slip up at the end killlled me

[SageRap]

I stopped watching 5min in. It absolutely blows my mind that so many people who somehow consider themselves "teachers" actually do things like jump-cutting to an open window, and beginning to type code/commands, with literally *zero* context or explanation regarding *where* they are typing this or how they got there... "This is just an interface for interacting with Postgres." _immediately begins writing code_ Gee, thanks so much... How tf is anyone supposed to follow this? Download Postgres, then sit back and snap our fingers and this window magically opens itself up in front of us, configured properly, connected to a database server, and ready to receive commands?? Wtf? Information about how to prepare/configure and open the GUI or CLI where one begins writing code is *essential* to actually learning about subjects like this, yet literally 9 out of 10 "teachers" *always* skip the first, essential, basic steps like this. It grates me to no end.

[interesting_stuffs]

good one but there was nothing about PostgreSQL in particular, it was all about MySQL and Fireship channel has the same content in < 17mins man, this one with 50 mins was just too much and sadly it doesn't anything specific to PostgreSQL!

[sgp]

I have an extenisve background in DB development going back to DB2. It's been awhile and I need to get up to speed on POSTgres quickly so I can assist my main guy who is doing all the front and back end work. I totally agree with all the people who say, 'hey...this guy is smart, well spoken, a good trainier, and someone who I trust to learn a lot from." Thanks Troy. I appreciate you very much

[KerryEmerson]

Bro sounds like he's trying to hold in the puff puff

[georgesol]

Amazing crash course! Thanks a lot! You're a great teacher, man 😁

[HugoBernardo-ml]

It ´d have been REALLY worthy with some SQL Function template so it´d have killed
it! Very good, anyway.

[TidanOfc]

This seems like a learn SQL tutorial, much less than learn PostgresSQL.

[StalkedHuman]

If you say 2+2=4 they'll say you're being "imperative".. or if you say the sky is blue, they'll saying you're arguing. The polarity of slander is religious.

[mercadocomproposito]

These 50 minutes are better than my 80 hours college course about Database!

[sabinomuniz]

"PostgreSQL CRASH COURSE - Learn PostgreSQL in 2024" but
"222K views 2 years ago" I'm I in 2026??🤣🤣

[Verrisin]

This is not specific to Postgres. Just call it SQL crash course.
- I expected advanced, PostgreSQL specific functionality.

[anthonyngooo]

GOATED definitely one of the best videos with clear explanations, examples, and great commentary of not just what but WHY we do things without the bloat of other videos.

[tomasborek]

such a sweet and easy to follow tutorial. Thank you :)

[ahmedhussein]

bro, good video, but this is a SQL crash course, not PostgreSQL. I mean it is not for someone already knows SQL and looking for PostgreSQL crash course that highlights the unique PostgreSQL features

[shanildajones]

How does everyone not use the PSQL SHELL at all, but tell you two download another program. How does that work, when all I wanted to learn is PSQL in the shell not some easy to use interface, where It won’t be available for use in any job situations. What company used pop whatever.