| Author |
Topic |
|
cat_jesus
Aged Yak Warrior
547 Posts |
 Posted - 2005-02-10 : 10:54:03
|
| I have been tasked with training a new developer in SQL server. This guy is a recent college grad and has a no database experience but a little C programming experience. I have mentored quite a few people in T-SQL(thanks to many of you fine folks) but those people were intermediate programmers and they were already in the middle of coding something.I'm not sure where to begin. Any ideas or suggestions? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-02-10 : 10:56:59
|
start at the begginig  that is:1. teach him normalization2. teach him set based thinking3. teach him normalization  4. teach him sql syntax5. quizz him6. do some other stuff you like...Go with the flow & have fun! Else fight the flow |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-02-10 : 11:10:02
|
| Part of spirit1's step 4 can be to have the new person do all example steps in BOL's:Accessing and Changing Relational Data | Query FundamentalsAccessing and Changing Relational Data | Advanced Query ConceptsBe One with the OptimizerTG |
|
|
|
Auric
Yak Posting Veteran
70 Posts |
Posted - 2005-02-10 : 11:16:31
|
| You know cat, I think the best way to get your feet wet with a database is MS Access :S If he has NO previous database experience at all. You can learn a lot playing with Access. Create a small relational database of 4 or 5 tables to start. It is simple, and would teach SQL basics. I have a small VB App given to me by my teacher to practise SQL insert, update, delete and select statements if you want a copy let me know. it has two tables and a word doc describing basic sql functions.Select * from users where clue > 0 |
|
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2005-02-10 : 11:25:28
|
| I guess I should have pointed out that this developer has already installed SQL 2000 Dev Ed on his machine. We stay away from Access if we can help it.I already started writing some SQL to demonstrate set processing VS cursor based processing. I've become so accustomed to thinking this way that it was more difficult to write the code the wrong way. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-02-10 : 11:29:54
|
| modular system design can be useful trait to know. there should be some english books on that i don't know of any but still...Go with the flow & have fun! Else fight the flow |
|
|
|
Xerxes
Aged Yak Warrior
666 Posts |
Posted - 2005-02-10 : 12:37:09
|
| What about Northwind?Semper fi, Xerxes, USMC(Ret.)----------------------------------------------Acclaimed Cursoring Yak Master"If cursors were nickels, I could park in town--all year!" |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-02-10 : 12:57:53
|
quote:
If cursors were nickels, I could park in town--all year!
Xerxes, if cursors were nickels it would take you all year to find a parking spot!Be One with the OptimizerTG |
|
|
|
Xerxes
Aged Yak Warrior
666 Posts |
Posted - 2005-02-10 : 13:11:36
|
quote:
Originally posted by TG
quote:
If cursors were nickels, I could park in town--all year!
Xerxes, if cursors were nickels it would take you all year to find a parking spot!Be One with the OptimizerTG
Looping through one parking lot at a time!Think I'll mod the prof.Semper fi, Xerxes, USMC(Ret.)----------------------------------------------Acclaimed Cursoring Yak Master"If cursors were nickels, I could park in town--all year!" |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-02-10 : 21:16:42
|
| Teach him what BOL is and how to use it. Tell him that he can ask any question he wants but he has to tell you what he found in BOL on that topic first.HTH=================================================================Egotism is the anesthetic that dulls the pain of stupidity. -Frank William Leahy, football coach (1908-1973) |
|
|
|
Ex
Posting Yak Master
166 Posts |
Posted - 2005-02-11 : 00:17:01
|
| there are great sql server cd's www.learnkey.com that is what i learnt fromif you didnt want to outlay the cashhere is the flyerhttp://www.learnkey.com/store/images/pdfs/SQL2000ImpDBDes.Flyer.pdfif you whent through each of those points (which the cd does) i am sure the programmer will have no problems with sql server after that |
|
|
|
|
Training a new developer