Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How did you learn SQL


How did you learn SQL

Author
Message
Michael Valentine Jones
Michael Valentine Jones
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3254 Visits: 11771
Here are three free online tutorials:
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

These are the primary Microsoft SQL Server References:
SQL Server 2000 Books Online
http://msdn2.microsoft.com/en-us/library/aa257103(SQL.80).aspx
SQL Server 2005 Books Online
http://msdn2.microsoft.com/en-us/library/ms130214.aspx
alucas-824230
alucas-824230
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 27
and like Charlton Heston said in Planet of the Apes:

"Never trust anyone over 30!" (for advice on how to learn SQL 2005).

Tongue
Michael Valentine Jones
Michael Valentine Jones
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3254 Visits: 11771
alucas (7/30/2008)
and like Charlton Heston said in Planet of the Apes:

"Never trust anyone over 30!" (for advice on how to learn SQL 2005).

Tongue


Since Charlton Heston didn't say that, I'm not sure what your point is.
RBarryYoung
RBarryYoung
SSCrazy Eights
SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)

Group: General Forum Members
Points: 9438 Visits: 9517
alucas (7/30/2008)
and like Charlton Heston said in Planet of the Apes:

"Never trust anyone over 30!"


This is generally credited to Jerry Rubin, not Charlton Heston. and certainly not in Planet of the Apes.

Perhaps you meant "Take your stinking paws off me, you damn dirty ape!", which Charlton Heston DID say in Planet of the Apes. I know I often say that when someone asks me for advice on learning SQL Server.

Tongue

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
MarlonRibunal
MarlonRibunal
SSC Journeyman
SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)

Group: General Forum Members
Points: 75 Visits: 354
In addition to what have been provided here:

http://www.exforsys.com/tutorials/sql-server-2005.html

You can also visit my blog

http://dbalink.wordpress.com

-Marlon Ribunal

Marlon Ribunal
http://marlonribunal.com
Twitter @MarlonRibunal
alucas-824230
alucas-824230
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 27
Go ahead and watch Planet of the Apes, guys. FF to the end of the movie when they're on the beach, and C.Heston & his new GF have just been cut loose to go do their own thing, and listen to what he says to the the young ape.

I guess it was just the second thing to come to mind, after the Faroult book, because I was taught SQL by someone over 30 (70, actually), then re-taught by someone under 30, and it went much better the second time.

And then...Tongue
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8782 Visits: 16555
rbarryyoung (7/30/2008)
I know I often say that when someone asks me for advice on learning SQL Server.

Tongue

i would have thought judging by your avatar you would say
"i find your lack of faith most disturbing"

Laugh

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
RBarryYoung
RBarryYoung
SSCrazy Eights
SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)

Group: General Forum Members
Points: 9438 Visits: 9517
Perry Whittle (8/6/2008)
rbarryyoung (7/30/2008)
I know I often say that when someone asks me for advice on learning SQL Server.

Tongue

i would have thought judging by your avatar you would say
"i find your lack of faith most disturbing"

Laugh


That's what I say when they question me or don't take my advice. Smile

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
GSquared
GSquared
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14375 Visits: 9729
Since I'm over 30, and "learned me some SQL" from someone over 30, I guess you should disregard anything I have to say on this, but here goes:

Spend time on this and other SQL web pages.

Go to a bookstore with a list of specific SQL questions, check as many books as you can for answers to those questions. You'll probably find one that answers the most, and that you can understand the answers. For me, that was SQL Server 2000 Bible, by Paul Neilsen. (Get the 2005 version of the book, of course.)

Do searches in Books Online when you have questions.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
myke
myke
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 8
I think the most important thing, is actually doing it.

One of the biggest problems i've seen people face learning SQL is that they'll have the technical aspects nailed down pretty well, but they just don't quite "get it". Knowing how to select data is one thing, but being able to sit down and think about what data to pull out and how is another.

Definately use the tutorials and any educational material that works for you - but use that as a starting point. Play around with it a little bit, come up with queries on your own to see what you can do. Try to think of real-life scenarios, and see if you can come up with solutions on your own. Then try to find alternative solutions to the same problem.

Experience > Education a good majority of the time.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search