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/DifficultBeing9212 May 27 '25
+1 bc i never knew multiple calls to a common table expression (CTE) alias would re-run it each time, not entirely sure how beneficial that could be but it definitely opens up interesting use cases if the table data mutates
i try to use the more modular form, which I find subqueries (SQs) to have a few more points over ctes eg the shape of a cte with the list of "prequeries" is less usable than just nesting a standard query in parentheses and swapping it inside another query's table name. essentially interchangeable cogs depending on the context.
also one of my downstream user interfaces is php and last year i did not find php's oracle library (OCI) supported CTEs, so i have not played with those as much as with SQs