Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Interview Questions for a Developer Expand / Collapse
Author
Message
Posted Monday, May 5, 2014 7:02 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 22, 2014 12:24 PM
Points: 2,829, Visits: 8,477
What type of SQL Database questions would you ask of a prospective junior PHP web developer. We know he is fairly new at it, so no tricky "gotcha" questions. More along the lines of basic understanding of concepts.


Post #1567749
Posted Tuesday, May 6, 2014 12:02 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:16 AM
Points: 13,621, Visits: 10,507
The basics I guess. Writing CRUD statements, how do PK and FK work, maybe a bit about normalization.
Maybe more important to check out if he can find solutions on his own and is willing to learn.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1567784
Posted Tuesday, May 6, 2014 7:19 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 10:09 AM
Points: 15,661, Visits: 28,050
Then, basic understanding of concepts. JOINs, WHERE criteria, fundamentals on relational storage. Nothing hard really. Primarily, I'd explore his knowledge set, not actually test it. He's not in a position that I'd be concerned with real skill, but an understanding of how much I'd have to teach him would be useful.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1567931
Posted Tuesday, May 6, 2014 7:54 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:47 PM
Points: 1,651, Visits: 4,707
homebrew01 (5/5/2014)
What type of SQL Database questions would you ask of a prospective junior PHP web developer. We know he is fairly new at it, so no tricky "gotcha" questions. More along the lines of basic understanding of concepts.

For a "prospective junior PHP web developer", I'd expect most of his development time would be spent writing PHP code and doing other front end design work. All he would (should) be using the database for is selecting from tables or making stored procedure calls. Someone else should be designing the database and playing the admin role. So it seems to me the questions for this guy should center around the SQL SELECT statement, PHP connection and query execution objects, working with resultsets, error handling, etc.

Accessing SQL Server Databases with PHP
http://technet.microsoft.com/en-US/library/cc793139(v=SQL.90).aspx
Post #1567958
Posted Tuesday, May 6, 2014 8:03 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 5:39 AM
Points: 338, Visits: 3,289
What blogs, forums, dev websites do you follow

I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Post #1567968
Posted Tuesday, May 6, 2014 8:16 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:47 PM
Points: 1,651, Visits: 4,707
Usually when we interview candidates, the recruiter has already required them to complete a standard technical assessment exam and HR has qualified them based on their education and visa status. At this point a small number of candidates have been selected.

So for the face to face interview, I don't rely on a list of predefined and questions and answers. Rather, I'll ask open ended questions like:
"Tell me about your current position?"
(followed by a half-dozen "Explain in more detail how..." type questions)
"So if you had an opportunity to design that application from start, what would you do different?"

Of course you as the interviewer have to know what you want and what you're talking about for this to work.
Post #1567976
Posted Tuesday, May 6, 2014 10:36 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:28 PM
Points: 11,252, Visits: 13,015
I'd ask:

If you have orders and order items and the purchase price is stored only on the order item how would you generate a Total Order Amount?


I'd be looking for a JOIN and the SUM function. I'm dealing with an application now that is looping within the application to generate a sum, so I find it important for developers to know about using aggregate functions in SQL.





Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1568083
Posted Tuesday, May 6, 2014 2:46 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 5:39 AM
Points: 338, Visits: 3,289
I'm not quite sure whether this is a cunning plan or just a bit arsey for a newbie. Push to get them a Pluralsight account on the company, put that in the bumph alongside the other training and mentoring you are offering.

If it boils down to two, and you ask "Which of their courses do you think would benefit you most?". The one who has done their homework and has an idea, big plus. "No idea, didn't look" that'd be a no for me. If you get "I've got the free introduction and ... " Hell Yeah.

"I don't need that ... " call security at that point.


I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Post #1568195
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse