| Author |
Topic |
|
Que
Starting Member
4 Posts |
 Posted - 2004-07-01 : 09:52:36
|
| Currently our developers are not strong enough to write the majority of the stored procedures required for a project. Our DBA's must complete these procedures. I would like to find out if there is a online tutorial that I can institute to get everyone up to speed to write these queries. Can anyone send me in the right direction? |
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2004-07-01 : 14:10:56
|
| Here is a great reference[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=16770[/url]It is a rich creamy color with a high fat content of 5-7 percent. Being so high in fat, it is usually processed into butter, cheese, or yogurt. An average cow will produce 110 kg. Milk in a lactation period of an average of 149 days |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-07-01 : 15:23:27
|
| Can you show us what a dba wrote?I'd be curious....Brett8-) |
|
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2004-07-01 : 15:35:57
|
| That's funny Brett I was thinking the same thing 'cause I originally posted that it probably wouldn't be a plug'nplay experience 'cause I tried, begged and couldn't buy it.I gave some examples of "thought shift" and one of 'em was "you mean I don't need to loop through that". Then I realized some folks working as dba's might cursor all over the place. At that point I deleted it referenced the contributions by others.It is a rich creamy color with a high fat content of 5-7 percent. Being so high in fat, it is usually processed into butter, cheese, or yogurt. An average cow will produce 110 kg. Milk in a lactation period of an average of 149 days |
|
|
|
Que
Starting Member
4 Posts |
Posted - 2004-07-01 : 15:39:02
|
| I cannot. I am just looking for a solution to bring the developers up to par. |
|
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2004-07-01 : 16:15:56
|
| Hey Que that link I gave might not provide the answer you are looking for but I beg of you not to get frustrated because there really isn't a 'We are sending them on training next week solution' buried in there. I know the feeling. I scoured the intenet and still do looking for little tidbits to let me become better or more directed. But you are in a unique position to have a group take on the challenge together. Many struggle alone and in this case the amount of faith required to leap into the relational abyss is best served by a group. The main point is don't get ticked or frustrated when you read. "You need to develop a relational approach" and then you look in the Learning Tree book and there is no 'Relational Approach for Programmers - passing the Codd to the OOP crowd.' It's a bit subtler than that, probably because how would you measure the success of that training? The success is when you hit your self on the forehead because a different part of the brain just kicked in.It is a rich creamy color with a high fat content of 5-7 percent. Being so high in fat, it is usually processed into butter, cheese, or yogurt. An average cow will produce 110 kg. Milk in a lactation period of an average of 149 days |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-07-01 : 16:17:35
|
| MEMO To: Development personnel From: Upper management It has come to our attention we have hired developers who cannot write simple SQL query’s .Your all fired!!!!!--------------------------------------------------------------No insult intended. Sorry I have had a day cleaning up after people who should know better but do not. JimUsers <> Logic |
|
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2004-07-01 : 16:36:18
|
| Yeah JimL I was going to call "harsh" on that one. This request is close to me cause I came here with the same one but just for myself.This site saved me and gave me great joy. Fortunately I was new to programming in general and didn't have a stubborn mindset.I hear (and have seen) it can be rougher especially when ego gets in the way.Maybe that is why there is no training for it. What instructor could possibly 'deal. I still think a 'Lyceum' approach would be best but I guess that would mean Que would have to step up and take the first leap of and hope his "flying finger set" would follow.It is a rich creamy color with a high fat content of 5-7 percent. Being so high in fat, it is usually processed into butter, cheese, or yogurt. An average cow will produce 110 kg. Milk in a lactation period of an average of 149 days |
|
|
|
Que
Starting Member
4 Posts |
Posted - 2004-07-01 : 16:47:32
|
| So, essentially, I'm screwed. There has got to be a tutorial somewhere. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-01 : 16:49:11
|
| I'd say purchase the two Ken Henderson books mentioned in that other thread. Pass those around. Each developer should read at least the first few chapters.Tara |
|
|
|
Que
Starting Member
4 Posts |
Posted - 2004-07-01 : 16:56:04
|
| I will look into it. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-01 : 18:36:35
|
| We have training classes here. I refer programmers to the two Ken Henderson books and Sam's Teach Yourself Transact-SQL in 21 Days which is surprisingly a very good book.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2004-07-01 : 21:32:46
|
| [url]http://sqlzoo.net/[/url]I used this before I came here.It is a rich creamy color with a high fat content of 5-7 percent. Being so high in fat, it is usually processed into butter, cheese, or yogurt. An average cow will produce 110 kg. Milk in a lactation period of an average of 149 days |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-01 : 22:13:17
|
| Yet another bookmark. lol I keep thinking I have a pretty complete list of bookmarks, then I'll have weeks where I add three or four in the same week.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-02 : 01:09:59
|
quote:
Originally posted by derrickleggett
I refer programmers to the two Ken Henderson books and Sam's Teach Yourself Transact-SQL in 21 Days which is surprisingly a very good book.
Seconded. Only observation is that Ken Henderson's "Guru" books jump right in - which might put some starters off - but for people with enough basic knowledge to get into them the acceleration is impressive!.I mean, the first example of an SProc is something which reverse engineers existing SProcs from the database to pull out documentation. Fantastically useful, but pretty hard to fathom for a Newbie!Kristen |
|
|
|
|
SQL Developer Training Needed