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

SQL exercises for job applicants Expand / Collapse
Author
Message
Posted Wednesday, March 7, 2012 9:21 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 25, 2014 2:32 PM
Points: 206, Visits: 451
Hello,

I'm not sure if this is the right forum for this question but here it goes.

It looks like we may be looking for a jr. sql developer in the near future, but I was wondering if there are any set of exercises that we can use as part of the interview for the applicant(s). I think this would help us better assess their skills and fit for the job.

Regards,

john
Post #1263093
Posted Wednesday, March 7, 2012 2:36 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:07 PM
Points: 283, Visits: 263
You could ask them how to find duplicate rows in a table. Possibly even finding the highest id value if the id is an integer column, say perhaps an identity. You should be able to learn a lot about them by how they solve this.
Post #1263293
Posted Saturday, March 10, 2012 9:46 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, September 8, 2012 10:25 PM
Points: 61, Visits: 35
A lot of exercises at SQL Exercises.


Post #1264798
Posted Saturday, March 10, 2012 9:57 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 5:20 PM
Points: 17,600, Visits: 15,462
Brandon Leach (3/7/2012)
You could ask them how to find duplicate rows in a table. Possibly even finding the highest id value if the id is an integer column, say perhaps an identity. You should be able to learn a lot about them by how they solve this.

I think this is a good approach.

I'd start by asking them how to solve various issues pertinent to your environment that maybe you have encountered and resolved in the past. It would give a lot of insight.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1264801
Posted Sunday, March 11, 2012 3:59 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:24 AM
Points: 6,823, Visits: 13,270
I like the FizzBuzz puzzle.
I use it to identify if an applicant
- prefers using a set or loop based method where both methods are possible
- knows enough T-SQL to generate a numbers list from scratch (or if the person knows a method to generate such a list based on a system table)
- understand how the CASE fuction works
- knows how deal with error messages (usually an applicant would simply add "ELSE number" leading to a conversion error)

This simple test is also a good start to talk about some rather basic SQL internals: (Why does SQL Server try to convert "fizz" to a numeric value?)

The test to find duplicate rows is a good test for solving a common task.




Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
Post #1264833
Posted Monday, April 1, 2013 4:44 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 10:28 PM
Points: 35,215, Visits: 31,666
LutzM (3/11/2012)
I like the FizzBuzz puzzle.
I use it to identify if an applicant
- prefers using a set or loop based method where both methods are possible
- knows enough T-SQL to generate a numbers list from scratch (or if the person knows a method to generate such a list based on a system table)
- understand how the CASE fuction works
- knows how deal with error messages (usually an applicant would simply add "ELSE number" leading to a conversion error)

This simple test is also a good start to talk about some rather basic SQL internals: (Why does SQL Server try to convert "fizz" to a numeric value?)

The test to find duplicate rows is a good test for solving a common task.


Unless it's a very smart Junior, I wouldn't expect them to even know what a numbers list is never mind be able to generate one. Sure, the code is simple but I've worked with many supposedly Sr. Level Developers and DBAs that have never heard of things when it comes to numbering things. Shoot, even ROW_NUMBER has been out for over 8 years and I'm still finding Seniors that know nothing about it.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1437653
Posted Monday, April 1, 2013 5:09 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:28 AM
Points: 20,676, Visits: 32,267
Jeff Moden (4/1/2013)
LutzM (3/11/2012)
I like the FizzBuzz puzzle.
I use it to identify if an applicant
- prefers using a set or loop based method where both methods are possible
- knows enough T-SQL to generate a numbers list from scratch (or if the person knows a method to generate such a list based on a system table)
- understand how the CASE fuction works
- knows how deal with error messages (usually an applicant would simply add "ELSE number" leading to a conversion error)

This simple test is also a good start to talk about some rather basic SQL internals: (Why does SQL Server try to convert "fizz" to a numeric value?)

The test to find duplicate rows is a good test for solving a common task.


Unless it's a very smart Junior, I wouldn't expect them to even know what a numbers list is never mind be able to generate one. Sure, the code is simple but I've worked with many supposedly Sr. Level Developers and DBAs that have never heard of things when it comes to numbering things. Shoot, even ROW_NUMBER has been out for over 8 years and I'm still finding Seniors that know nothing about it.


That wouldn't be a problem with some of the students coming from one of the colleges here in town if they would higher me to teach a MS SQL Server class. Using a Tally or Numbers table has become an important part of what I do on a regular basis almost. Using ROW_NUMBER() as well.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1437663
Posted Saturday, April 20, 2013 7:14 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 3:20 AM
Points: 196, Visits: 650
If you're looking for a junior I hope you wouldn't restrict yourself by solely asking questions that are all SQL Server specific...at least give them the option to use psuedocode. You might have a whizzkid fresh out of uni in the room with you who doesn't know any MSSQL currently but given a couple months may start showing up a couple of your mid-level staff


Dird // Junior DBA
11g OCA
10.5 newbie
Post #1444710
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse