Re:Six Tips to Ace a SQL Interview
by phibz on Friday October 23, 2020 @07:07PM
(#24875332)
When I ask SQL questions I'm looking for a few important things.
1. Have you written SQL
2. Do you understand keys and joins
3. Do you understand one to one, one to many, and many to many relationships
4. Do you know any advanced language features: window functions, CTEs, grouping sets, strategies for pivoting data in different dbs, etc.
I don't care if you write syntactically correct SQL or even remember all the keywords. Just as long as you can talk intelligently about some of those concepts.
1. Have you written SQL 2. Do you understand keys and joins 3. Do you understand one to one, one to many, and many to many relationships 4. Do you know any advanced language features: window functions, CTEs, grouping sets, strategies for pivoting data in different dbs, etc.
I don't care if you write syntactically correct SQL or even remember all the keywords. Just as long as you can talk intelligently about some of those concepts.