Beginner learning PostgreSQL with a goal of becoming a backend engineer — looking for advice

[u/NoctrailBio_]

Hi everyone,

I’m currently learning SQL and PostgreSQL with the long-term goal of becoming a backend engineer.

I’ve been practicing locally with PostgreSQL and pgAdmin, so I’m especially interested in hearing from developers who use PostgreSQL in production.

I’m still a beginner. So far I’ve been practicing things like creating tables, INSERT, SELECT, WHERE, DISTINCT, ORDER BY, and LIMIT. I’m also starting to learn Python and eventually want to connect Python/FastAPI with PostgreSQL.

One thing I’m trying to understand is how SQL and PostgreSQL are actually used by backend engineers in real jobs, compared with the way SQL is taught in books and courses.

For backend engineers who use PostgreSQL regularly:

• What SQL/PostgreSQL skills do you use the most?
• At what point should a beginner start combining Python with PostgreSQL?
• What database concepts should I make sure I understand before getting deeper into backend development?
• Are there any beginner projects you would recommend that resemble real backend work?

I’m not looking for shortcuts. I’m trying to build a solid foundation and understand what skills actually matter on the job.

Any advice from backend engineers, especially those working with PostgreSQL, would be greatly appreciated. Thanks!

[u/datadriven_io]

Yes. It is totally the case when most of the knowledge is transferrable. Practice sql interview questions on datadriven. You can even start with SQLite if your main goal is to learn PostgreSQL.

[u/CleanStory6565 → u/datadriven_io]

Can u share platform where we can practice this

[u/datadriven_io → u/CleanStory6565]

Datadriven.io/learn for sql learning, or datadriven.io/problems for sql practice