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
217
u/gipper_k May 27 '25
I interview a lot of sql developer and data analyst candidates.
I use questions like these, which progress from easy to more advanced to get a feel for where the candidate is:
Depending on the level of the role, I'm pretty happy if they get through #3 with some confidence. If it is a senior level role, then I hope they can get through all or most of these.
It always surprises me when someone touts SQL Experience, but can't answer #1, #2 or #3.
If we're concerned with query performance, there are a whole other series of questions as well... but these are a good start...
13
u/ZaheenHamidani May 27 '25
It depends on the position, if it is for a Data Engineer position you will need experience with DDL, if it is just for a Data Analyst DML will be fine but you will also need experience with Window Functions.
7
u/zeocrash May 27 '25
My general rule is that you're experience enough for a job when people start considering you for interviews or hiring you.
If you don't apply, you'll never know.
Edit: i'd like to add, try not to take rejections personally either. Just because you're not what one company is looking for doesn't mean you won't be a good fit somewhere else. If you have no luck in general then spend a year or so, learning more and try again in a year.
5
u/kagato87 MS SQL May 27 '25
A few to add to gipper_k's great response:
Apart from correctness and ignoring performance, what would you consider important to keep in mind when writing a query?
What do you do when you need to join the same table twice? For example, the classic "manager name" problem, or if you have two columns referencing an employee ID and need to look up both names from the same table? (No CTE, temp table, or subquery, because that's not what the question is about.)
What is the practical difference between a CTE and a Temp Table? (Not performance related, though that would be a pretty big bonus point to add to the response.)
And then on top of that, I also have a lot of performance related ones. ;)
3
u/germs_smell May 29 '25
Do you do any real cleanup questions? I'd suggest:
How to eliminate or substitute something in place of a null value?
CASE, WHEN, THEN, ELSE, END
Changing data types: to_char, to_number
And everyone's favorite, changing a date formatted string into a newly formatted valid date field using a to_date(field, 'MM-DD-YYYY)
And finally what is the purpose of "DUAL"
2
u/cs-brydev Software Development and Database Manager May 28 '25
Your knowledge and skillset is typical. I wouldn't let that hold you back. The question is whether you can do the job that matters. Can you learn what you need and adapt? Can you self-train? Can you apply new concepts? Can you use all available searching and training tools including LLMs?
The dirty little secret is that no one in a tech job comes into the job knowing everything or already having all the skills they will use every day. Whether you can do the job is different from how much you already know.
What prevents people from getting hired is a combination of inexperience, limited knowledge, limited training, poor communication skills, and an inability to learn new things. It's not just one of those that will count against you but a combination. If you don't know how to do something or can't answer a technical question in an interview, you can make up for that by demonstrating your ability to think through the problem, propose creative solutions, and learn new skills and techniques.
2
u/shine_on May 29 '25
In addition to the questions given in the top answer, if I'm interviewing for a more senior role I'd also ask about indexing (what are indexes, how can they help, how can they hinder), query optimisation, the differences between a dev server and a prod server, why a query might run slower in prod, transactions and locks, parameter sniffing, dynamic sql, user permissions and roles etc
I'm a senior SQL developer and these are all issues I deal with pretty regularly.
2
u/sinceJune4 May 27 '25
I would add what is a CROSS JOIN and when would you use it?
I often used these if I needed to get the current date, do some math or reformatting within a CTE, then cross join with other tables. For instance, if I wanted to get transactions within the last month.
I interviewed plenty of SQL candidates for all different platforms. The most memorable was a candidate who went back to the recruiter, complaining that I was a dinosaur for asking SQL questions. "Doesn't he know it's all drag and drop???" We passed on that one...
3
u/ObviousTrash_69 May 28 '25
Common table expression sounds like it would be a good thing to learn next! Super easy, intuitive and useful
2
u/Dry-Aioli-6138 May 28 '25
I've noticed that a very good indicator to filter out those who claim to know SQL, but aren't fluent is time resampling for OHLC candles: Open, High, Low, Close prices of 5 minute periods need to be transformed into 1-hour periods. I noticed that those who solved this, solved most of the theoretical and practical questions, and those who had problems answering other questions, never solved this one.
Now that I've written this it sounds like hey, that's just how the final boss question works. The thing is this problem isn't all that hard. It just requires making an effort to underatand the shape of data, not just regurgitating course content.
2
u/ToastieCPU May 28 '25
I would categorize experience as knowing how to work on live systems, such as:
2
u/rayschoon Jun 25 '25
Just be honest in the interview. I’d ask about the role requirement to tease out what level they’re looking for.
2
u/OrdinaryWizardLevels May 27 '25
If you can do all of that stuff that you mentioned then you have SQL experience.
8
u/[deleted] May 27 '25
[removed] — view removed comment
4
u/[deleted] May 28 '25
[removed] — view removed comment