Re: What is expert SQL knowledge?
"Don Vaillancourt" <donv@webimpact .com> wrote in message
news:TkaFd.8832 6$vO1.526644@nn rp1.uunet.ca...[color=blue]
> Actually, that's a good point. Maybe I should provide another kind of
> test which is still as complex, but based on a different hierarchy.
>
> nib wrote:
>[color=green]
>> As to your specific point. I've been working in SQL for many, many years
>> (back from 6.0) but in all my years have never had to deal with a
>> hierarchy type query. I'd likely fail your test.[/color][/color]
I've a fair bit of sql development experience.
I'd likely fail that test.
Can't recall ever having to write a query like that.
Mind you.
Been a while since I've worked on bill of material stuff.
Last time I was using cobol rather than sql.
Usually though, you have to check the number of levels you can go down and
such a BOM would be one of those one off tasks where you lock yourself in a
quiet room for a long think.
I also have some experience interviewing people.
The guy who's overconfident ( and nothing rattles him ) in an interview is
usually the sort is cocky and abrasive.
I don't want them working in my team.
The one falls to pieces is probably not going to be able to deal with
problems.
The one I want is the bloke who is going to be a bit nervous but not
gibbering.
I don't like written questions.
Anyhow, FWIW.
The way I test people is to ask them several open questions and just see
what they come out with.
You can tell a lot about the way they think and the way they work.
One is how they go about programmaticall y adding a record.
Believe it or not, I was sat next to a fellow contractor actually asked me
this.
If they can't answer that coherently then they're off to a pretty bad start.
On the face of it that's possibly a rather easy one, isn't it?
Although it's an easy question it's very open and puts a lot of pressure on
people.
But do they talk about stored procedures, build sql strings or what?
The others depend on the language we're using.
"Don Vaillancourt" <donv@webimpact .com> wrote in message
news:TkaFd.8832 6$vO1.526644@nn rp1.uunet.ca...[color=blue]
> Actually, that's a good point. Maybe I should provide another kind of
> test which is still as complex, but based on a different hierarchy.
>
> nib wrote:
>[color=green]
>> As to your specific point. I've been working in SQL for many, many years
>> (back from 6.0) but in all my years have never had to deal with a
>> hierarchy type query. I'd likely fail your test.[/color][/color]
I've a fair bit of sql development experience.
I'd likely fail that test.
Can't recall ever having to write a query like that.
Mind you.
Been a while since I've worked on bill of material stuff.
Last time I was using cobol rather than sql.
Usually though, you have to check the number of levels you can go down and
such a BOM would be one of those one off tasks where you lock yourself in a
quiet room for a long think.
I also have some experience interviewing people.
The guy who's overconfident ( and nothing rattles him ) in an interview is
usually the sort is cocky and abrasive.
I don't want them working in my team.
The one falls to pieces is probably not going to be able to deal with
problems.
The one I want is the bloke who is going to be a bit nervous but not
gibbering.
I don't like written questions.
Anyhow, FWIW.
The way I test people is to ask them several open questions and just see
what they come out with.
You can tell a lot about the way they think and the way they work.
One is how they go about programmaticall y adding a record.
Believe it or not, I was sat next to a fellow contractor actually asked me
this.
If they can't answer that coherently then they're off to a pretty bad start.
On the face of it that's possibly a rather easy one, isn't it?
Although it's an easy question it's very open and puts a lot of pressure on
people.
But do they talk about stored procedures, build sql strings or what?
The others depend on the language we're using.
Comment