News for hackers. Stuff that matters.
Re:Our SQL interview questions by brixon on Tuesday May 28, 2013 @08:36AM (#5779556)
My first weed out question is asking them to describe a Left Outer Join. They don't have to get it exactly right, I just want to see if they ever did anything more than a two table inner join.

For a Web Developer the first weed out question is to tell me the difference between a GET and an POST. Here all I really want then to know is that a GET is what generally see in the URL and a POST is commonly what you see in HTML Forms. I want to see if all they ever did was ASP.NET WYSIWYG web development or if they actually know something about the internet.

These two questions can be done in a phone screen. The faster that you can weed out people the cheaper the hiring process is.

Re:Our SQL interview questions by jasonkester on Tuesday May 28, 2013 @08:42AM (#5779579)
Careful using that terminology. You'll get false negatives on people who still think in terms of *= syntax, and will tell you that the words "left", "outer", and "join" are all redundant and probably don't belong in SQL in the first place.

I used to be one of those guys, but I'm much less grumpy about it these days so I'd still pass your test. I have a sad suspicion that I'm on the progressive end of the spectrum when it comes to guys who deeply understand SQL.

Re:Our SQL interview questions by ajuc on Tuesday May 28, 2013 @09:11AM (#5779740)
Yep, I've done a lot of PL/SQL programming, and we've always used (+)= syntax and joins with all the tables after commas and all the joining conditions after WHERE.

Now I work on different project and we use join syntax, but I could easily imagine people that do joins all day, and not know JOIN .. ON .. syntax.

Re:Our SQL interview questions by jacques_chester on Tuesday May 28, 2013 @09:23AM (#5779810)
I came to Oracle after it adopted the ANSI syntax, so that's what I use. So my experience is the opposite of yours -- when I see the (+) I need to look up the syntax to remember if it's left or right outer.
Re:Our SQL interview questions by jfb on Tuesday May 28, 2013 @09:29AM (#5779862)
And then I ask, hey, where's my BOOLEAN? And then I drink.
Re:Our SQL interview questions by jacques_chester on Tuesday May 28, 2013 @09:32AM (#5779879)
Oh god.

And the lack of a serial/autoincrement/identity type.

So. Many. Effing. Triggers.

And 32-character identifiers.

sigh

Re:Our SQL interview questions by tmzt on Tuesday May 28, 2013 @07:11PM (#5783477)
It's so much better to use a database that only allows one autoincrementing value per record, or one TIMESTAMP and then only allows you to have either a create timestamp or an update timestamp without writing a trigger.

I prefer the way Oracle does it, you may have to do more work but it's more explicit and flexible that way.

Re:Our SQL interview questions by jacques_chester on Tuesday May 28, 2013 @07:30PM (#5783560)
I don't. I prefer for the common case to be correctly and automatically handled for me.
Re:Our SQL interview questions by brixon on Tuesday May 28, 2013 @11:31AM (#5780600)
True, I use it for a conversation starter. You can tell the split second after you ask the question if you will get any kind of reasonable answer.

I personally have used the *= syntax more than the LEFT syntax, but that concept has helped filter people since I am not allowed to "test" people.

Re:Our SQL interview questions by tmzt on Tuesday May 28, 2013 @07:03PM (#5783441)
Obviously a GET has variables and a POST doesn't (that's why they are called "GET variables")

[I've encountered this belief more than once working with PHP developers. I would hope that the answer was closer to something demonstrating knowledge of HTTP as a protocol.]

Re:Our SQL interview questions by zerr on Tuesday May 28, 2013 @08:49AM (#5779608)
Good point - that they don't have to get it exactly right. For me, it would be enough if the candidate is just aware that there are different types of Joins for different scenarios.
Re:Our SQL interview questions by Ecio78 on Tuesday May 28, 2013 @08:53AM (#5779637)
Interesting, so I think I'll pass your first screening even though I'm not a (web) developer but (most of all) a system/network engineer :D