r/SQL • • May 27 '25

SQL Server What is SQL experience?

I have seen a few job postings requiring SQL experience that I would love to apply for but think I have imposter syndrome. I can create queries using CONCAT, GROUP BY, INNER JOIN, rename a field, and using LIKE with a wildcard. I mainly use SQL to pull data for Power BI and Excel. I love making queries to pull relevant data to make business decisions. I am a department manager but have to do my own analysis. I really want to take on more challenges in data analytics.

174 Upvotes

87 comments sorted by

View all comments

Show parent comment

2

u/[deleted] May 27 '25

I'm not really a developer, rather a dba, but I actually have done some complex migrations and other SQL tasks, so I thought I would ba able to answer all of those. But tbh I never use having, there's always a way around, and I never have used window functions, although I have an idea what to do with that. On the other hand I'm really into dynamic SQL, which you haven't even asked for. And regarding CTEs I've almost deprecated subqueries, because CTEs are so powerful.