SQL Clone
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
SSCertifiable
SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)

Group: General Forum Members
Points: 5906 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
SSCertifiable
SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)

Group: General Forum Members
Points: 5906 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
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15216 Visits: 9518
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-Enthusiastic
SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)

Group: General Forum Members
Points: 113 Visits: 364
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
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20374 Visits: 17244
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
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15216 Visits: 9518
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
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24147 Visits: 9730
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
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 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