Non-DBA advanced part:<p>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.<p>For DBA part:<p>No idea<p>What is advanced sql and how'd you learn it.<p>For data analyst roles? I'll ask in next post about for DBA roles.<p>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.
I 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.<p>My bread and butter for these batch pipelines is Python and SQL.<p>You can learn SQL best by using it to solve problems or answer questions.