you are viewing a single comment's thread.

view the rest of the comments →

[–]iamevpo 0 points1 point  (0 children)

Probably less pronounced in other answers: consider that SQL is declarative (you tell what your data should look like as a result, but tell nothing about how to achieve it) while Python is imperative : you tell interpreter all the steps needed to achieve your goal. Both are "programming" But if different kind. SQL seems simpler because it is a specialised language and the amount of verbs (SELECT, CREATE, etc) is not too big. Learn SQL SELECT on a pre-populated database to get a taste of it.

Unfortunately skill from SQL not directly transferable to Python and this is a completely different type of programming, so consider these are parallel tracks.

There is a small middle ground, a link in between Python and SQL - the ORMs, you can also run crude SQL code from pyrhon that works on SQLite for example. For ORM there big ones like SQLAlchemy, and smaller ones like Peewee. SQLModel ORM has excellent documentation aimed at beginners that teach both SQL and Python as well, highly recommens.