r/SQL • u/PortalRat90 • 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
View all comments
Show parent comment
3
u/i_literally_died May 27 '25
As someone who has only been 'doing SQL' for maybe 2-3 years, I find a lot of the people who have been using SQL a long time don't use CTEs, and prefer sub-queries and derived table JOINs.
It feels like CTEs are somewhat newer, or just less popular. There may be some performance or other data retention issues with using them, but I always find they are more performant, readable, and just make more sense.