The PostgreSQL project has a tutorial in their documentation.

Section 1 is about setting up Postgres, and section 2 is the hands-on tutorial for SQL.

although at a glance nothing i'm seeing online looks much like python, but i'm told that you can implement it through python or something?

Databases allow programs to connect to them and send SQL statements to the database. There are Python libraries that help manage this connection within a python program. After you get your feet wet with the above tutorial, you can start writing python programs that populate and retrieve information via SQL.

FULL SQL DATABASE COURSE | Beginner to Intermediate in 1 Hour

https://www.postgresqltutorial.com/

This should get you up to speed with syntax at a high level and is the guide I've had multiple friends use to get up to speed fairly quickly.

I went through an entire computer science degree without ever taking a database course (it was an elective). My first job used SQL heavily and it was not hard to pick up, if you already have a programming mindset.

now I’ve graduated I don’t have access to stuff like that anymore.

What?! Can I get an example?

Also, Anna's Archive probably has what you're looking for.

https://learnsql.com/

It's paid but not prohibatively expensive. The way it's strucrured is it explains a command to you, gives you an example, and then asks you to do a slightly modified example. It ends chapters with some exercises. Honestly a great resource for learning sql. Literally the only one that worked for me tbh.

although at a glance nothing i'm seeing online looks much like python, but i'm told that you can implement it through python or something?

There are libraries that use sql-like queries withib python, you can also run sql queries and feed them into python structures through python. The way I do it is I write up a sql query, test it, add some special characters for myself so I can modify it within python, then store it in a text file to use in python. But sql itself isn't really pythonic. It's very straight forward though, if ylu can code in any language and can solve SAT level logic problems, you can probably write sql reasonably well.

I always find W3schools SQL useful. They also give you an example database to try the statements immediately. And it's free.

I might have some resources available from my uni. Send me a reminder if I forget to update this

Knowing SQL and knowing SQL are different. You can know SQL in an afternoon for sure though.

The language itself is not hard to learn, but to really use it well you need some understanding of data aggregation and set theory.

If you have a computer science background it might all be pretty easy. I didn't and it took me about a year to really git gut in SQL.