Solved

How do I tech out a prospective programmer?

Posted on 2002-07-28
4
202 Views
Last Modified: 2010-05-02
Hi  
I would like to put together a list of about 10 questions for hiring a pretty advanced VB.NET and ADO.NET programmer. I am not very technical. Would have anyone have some questions that I can use? Also a few for SQL as well.
0
Comment
Question by:Massiel_VB
  • 2
4 Comments
 
LVL 49

Expert Comment

by:Ryan Chong
ID: 7184636
Well, to ask something to prospective programmer? My idea is first, you should do the preliminary studies on VB.Net as well as ADO.Net. They you're find out what is critical in .Net Technologies and Programming techniques.

For the SQL, definitely prepare a single database with some questions, let them generate the SQL statement according to the question itself. Compare the result to see if the SQL generates is correct or not.

<listening..>
0
 
LVL 2

Expert Comment

by:johnny6
ID: 7185153
One good idea is to buy a set of Microsoft Certified Solution Developer (MCSD) tests for .NET from www.transcender.com.  Here is a quote from their web site: "Transcender Exams...As Tough As The Real Thing"
Here is the full link for Deluxe MCSD Pak for .NET:
http://www.transcender.com/products/pak.asp?SKU=PFCNT0700
I hope this info helps.


John
0
 
LVL 22

Accepted Solution

by:
rspahitz earned 20 total points
ID: 7185964
It's always difficult for a non-technical person to find technical expertise.  This is true in any field.

One place to start is technical references.  Ask these people to let you talk to those who have worked with them.  Find out what types of projects were performed, and their scope.

Since you won't be able to understand the technical aspects, you should ask more generic questions in the same way you would, for example, interview a construction company to build you a house.  How many projects have they done?  What was the scope (size) of those projects?  What sort of problems did they encounter and how did they handle them?

--
Specific to VB, vb.net is very close to Java in the way it's organized.  Ask if they've ever done Java.  Also ask them to explain the object-oriented model and see if they understand the concepts of encapsulation (self-contained), inheritance (get info from "parents"), and polymorphism (can change).  Make sure they can explain the difference between properties (things about an object), methods (things an object can do) and events (things that can happen to an object.)

Ask them how long they've worked with .net.  If they tell you more than 2 years, they're probably lying.  How long have they been programming in VB?  What other languages are they familiar with?  On what platforms have they programmed?

--
For ADO, start with definition of ADO: ActiveX Data Object.  How experienced are you with building database tables?  When designing a name & address table(s) what would you consider:

1) Names in foreign markets can be complex.
2) Addresses are often obscure, especially in foreign markets
3) If US-only, the state listing should be in a separate lookup table rather than hard-coded so that validation can be performed.
4) For a larger database, it's worthwhile to even place cities into a separate table.  How would you organize the address table if it has links to cities and states?  (Answer all you need is a city ID, which would in turn get the state.)  This could also apply to a country table for foreign markets.
5) Where would you put the phone number?  Old answer: as a field in the address table.  New answer: as a separate table with a "phone type" table to indicate home phone, alternate home phone, personal/cell phone, pager, car phone (future), PDA, etc.  Home phones are attached to the address whereas cellphones are attached to the person.  i.e. multiple people can share a home phone number but one one person (usually) has a cell phone number.
0
 
LVL 22

Expert Comment

by:rspahitz
ID: 7186297
Thanks for the "A".

I'd love for you to give us a follow-up comment and let us know what was useful and what additional things you learned during the interview process... :)
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now