Job interview tommorow - Transact-SQL query

Mr^B said:
Really? That's interesting.

I say it when I don't want the OP to rock up to an interview thinking that T-SQL is just a bunch of 'select' statements rather than a large set of complex built-in functions, flow of control statements, cursors, CTEs, etc.

I don't think it's difficult to learn or use, nor do I find doing T-SQL particularly interesting. It's just a tool to get the job done. Although performance tuning queries can be strangely rewarding.
Click to expand...

Given that it is a support job, you wouldn't expect that the applicant would know more than the basics of SQL. If it were a developer role you might expect a bit more knowledge.

Just make sure to spit on the floor if they ask about cursors.
 
jamief said:
Given that it is a support job, you wouldn't expect that the applicant would know more than the basics of SQL. If it were a developer role you might expect a bit more knowledge.

Just make sure to spit on the floor if they ask about cursors.
Click to expand...

Even for support, I'd expect them to know about transactions as a minimum, just as a safety net for doing updates/deletes/inserts. ie. start a transaction, run your query, check the results, if they're ok, commit the transaction, if you've barfed something up, roll it back.
 
Not had the interview yet, got it at 330pm but just spoken to them, it's entry level role, more as an administrator of sorts. They said nothing to worry about if i get the job as they will send me on a course and also pay for me to get MS certified. Fingers crossed.

There will be no technical questions asked in the interview either it has been confirmed.
 
SQL injection explained;

exploits_of_a_mom.png
 
Choosing to work with SQL? That way lies madness. I dodged becoming the DB Admin at my work although managed to get lumped with SAN Administration. Pfft. :(
 
Nothing to do with the role. One of the people interviewing disliked the fact that i'd had the audacity to apply for an internal vacancy and made it more than clear.
 
ninjabib said:
Nothing to do with the role. One of the people interviewing disliked the fact that i'd had the audacity to apply for an internal vacancy and made it more than clear.
Click to expand...

That's a shame!

Don't let it put you off more SQL jobs - I had zero SQL experience when I started mine, and now I'm an SQL god :p

It's extremely easy to learn, and once you know the basics, the higher end stuff is just a case of day to day progress :)
 
Hank_Marvin said:
unlucky with the job fella.

what's the payscale like with sql jobs

SQL beginner =
SQL 2 years exp =
SQL 5 years exp =
etc
etc

Thanks
Click to expand...

What is a SQL job?

You could be support staff.
You could be a DBA
You could be a junior developer
You could be a senior developer

Etc etc.
 
Depends wildly on:

a) what job you're actually doing (see previous post)
b) where you are doing it
c) who you are doing it for
 
lol I don't know i've never been any, very rough wage, for say a beginner then in any of the above kind of sections you said.

Currently just doing tech support and web design so want to get another skill to go with em/move into.

Thanks
 
Senior DBA where I am would be about £75-80k (plus bonus).

Junior support staff in a non-finance company would start at about £20-25k maybe less.
 
You must log in or register to reply here.
Back
Top Bottom