4 ms·
Would you really interview and hire for a job based on SQL tricks instead of spending $50 to give someone a reference book?
by lonelappde 6y ago
Would you really interview and hire for a job based on SQL tricks instead of spending $50 to give someone a reference book?
- kragen 6y agoIf someone claims to be a SQL expert but hasn't bothered to read a comprehensive book cover to cover, it probably isn't because they didn't have $50, especially now that we have Library Genesis.
- WWLink 6y agoI've never claimed to be an expert in anything, but if I read a book on SQL from cover to cover, I'd probably still not remember wtf BETWEEN ROWS was unless I was using it daily. -- The guy that uses C and C++ all the time and often forgets the order of the arguments to common functions.
- yellowapple 6y agoHell, at least 50% of my day job involves hacking together SQL Server sprocs, most of which have thoroughly used (and abused) most or all of the concepts demonstrated in the article, and I take no shame in admitting that I'm frequently double-checking syntax or looking at how other people solved similar problems.
- eyelidlessness 6y agoI spend more and more of my time writing relatively complex SQL, and I too frequently look stuff up. That's what good engineers do, like all the time. I seldom leave my editor when it's TypeScript, because intellisense does most of the looking up for me. But for SQL I hit the google frequently and I'm not ashamed to admit that at all.
- kragen 6y agoI guess what I'm trying to say is that having a reference book won't help you if you don't know what to look for. Perhaps the interview problems can tell you who knows what to look for and who doesn't.