SQL Learning Experince

Before… I was only knowing NoSQL. I tried MongoDB before. It was fun… but I feel like I should also know SQL.

So I start exploring… MySQL, PostgreSQL, SQLite. Finally I choose PostgreSQL.

First days was setup headache I use Linux (openSUSE) so install was not smooth like Windows. pgAdmin setup, MySQL Workbench try, database connect… But when it worked, I feel like small win.

Then I found one gem VS Code extension “MySQL by Database Client”. Name is MySQL, but it connect both SQL & NoSQL databases. Do everything inside VS Code… no need extra apps. For me, best tool so far.

Learning now SELECT, WHERE, ORDER BY, GROUP BY. Also different functions, Aggregation, Joins (inner, left, right, full) and many more. Joins was little mind bending, but slowly it start making sense.

Also touching ORM like Prisma

Still learning…