3 ms·
What is intermediate-advanced SQL and how to learn it?
Non-DBA advanced part:
For me subqueries, HAVING clause, GROUP BY clause, CTEs, Indexing, Optimization etc are advanced sql queries. This is mostly used for data analyst, data scientist etc type I mean.
For DBA part:
No idea
What is advanced sql and how'd you learn it.
For data analyst roles? I'll ask in next post about for DBA roles.
I've learnt basic sql. I can write subqueries, but I'm no expert at it. I can do joins and feel pretty confident at it. I am still confused with group by clause which has been my biggest hurdle as a data analyst.
- gigatexal 3y agoI worked as a database admin for a while (5+ years) and then moonlighted as a Python dev and an SRE before settling into Data Engineering. My bread and butter for these batch pipelines is Python and SQL. You can learn SQL best by using it to solve problems or answer questions.
- gigatexal 3y agoAlso reading and breaking down another’s seemingly complex SQL helps.
- shivajikobardan 3y agotell me mor about your sql journey? how did you learn? what did you practice etc.