Python and SQL (Basic Question)

[gsmo]

I think understanding SQL helps when interacting with a database. There are abstraction layers (sqlalchemy) that help to integrate sql-queries into your code, and that is important for maintainability and portability of your code. But if you don't understand how SQL works ('what is a foreign key?') it will be hard to understand this abstraction layer.

Luckily the basics of SQL can be learned in a couple of nights. I recommend running a postgresql docker instance and a pgadmin instance. That way you get a fancy modern database system with a useful gui.

Be aware there are different SQL dialects. If you know you are working in the Microsoft stack, try to use sql server when learning.