When you are saying "Use the IDE", are you speaking of the psql CLI or pgadmin 4 web interface?
When using psql, the best bet is to print the help on the commands out, or find one of the tutorials or "cheat sheets" on the internet. It's obtuse to a beginner.
pgadmin 4 is temperamental if you have to set it up from scratch on Linux, but it's fairly easy to figure out if you read the docs or have used a similar GUI.
An alternative GUI is DBeaver. It handles more RDBMS and other data sources than others, there is a free community version and it's cross platform.
One thing to watch for is that Postgres has a slightly different SQL dialect than T-SQL. It's ANSI, but things are different in places.
A good basic book is "Practical SQL" by Anthony DeBarros. May be too elementary, but you will noticed the differences. And cool features.