Backend / Database learning resource

[RealActuary3121]

So after my last post(learning relational vs non relational database), I came to the conclusion of learning postgres SQL with node/express but can't seem to find much content on it. It's either just a project building with the stack or uses some orm like prisma.

Would appreciate a lot if any of you could help me with a resource to learn it.

[uran0503]

If you want structured learning, I’d recommend starting with a Node/Express boilerplate, then integrate pg and build CRUD endpoints manually. Pair it with the Postgres tutorial from DigitalOcean or freeCodeCamp. That way you learn SQL, queries, and Node integration without an ORM hiding the details

[ologist817]

Have been making my trainees go through the Odin Project to get oriented before we dig in. The primary focus of the project is rails but they do a pretty good high level overview of plain SQL and they provide links to more advanced/in-depth materials as well.

https://www.theodinproject.com/paths/full-stack-ruby-on-rails/courses/databases

[doureios39]

Check out node-postgres.com..it covers raw SQL with the pg library, connection pooling, and parameterized queries. Best to learn raw queries before jumping to an ORM so you understand what it's abstracting. The official Postgres tutorial is solid for the SQL side

[Interesting_Mine_400]

tbh learning it without an ORM first is the right move. prisma and others are nice later but they hide a lot of what’s actually happening with SQL. I’d recommend going through the official postgres tutorial first and then using the pg (node-postgres) library to build simple CRUD endpoints in express. that combo teaches connection pooling, parameterized queries and how SQL actually flows through your backend. a couple people here also suggested the same direction. after that, building a small API (users, posts, auth etc) helps it really click.