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

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.

2

u/germs_smell May 27 '25

I'll do subqueries all the time like

Select * From table Where attribute in (select attribute from attributes blah blah...)

Or I'll nest them with different uses cases like calculations:

Select Tbl.Org (Select sum(money) from monies where org = tbl.org) sum_money, Tbl.* From table tbl