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
GSquared
GSquared
SSC Guru
SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)

Group: General Forum Members
Points: 55355 Visits: 9730
myke (8/7/2008)
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.


Definitely good advice.

I keep a Proof of Concept database. Use it to test new ideas, help on stuff on this page, etc.

I'm always building new tables in there, and then testing all kinds of options on querying them.

On the subject of experience vs education, I think both works best. Best cycle I've ever seen is educate, get experience, educate again, rinse, repeat.

People with no education gain experience more slowly. People with some experience educate more rapidly. But, since you have to start somewhere, some slight education is a great place to start.

- 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
Coyote Blue
Coyote Blue
SSC-Enthusiastic
SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)

Group: General Forum Members
Points: 186 Visits: 44
Still learning SQL -- consider myself a newbie still after 2 yrs becuase I am still learning new things every day -- but I found ; for me and my learning style -
so here are my late-night rambling son the topic....

Understand how the front end app for the given Db works (for me, it is a tracking system).
Study each and every table (ERD be damned). Look at the indexes and triggers for those tables, so you know how the tables 'interact' with each other.

Learn how to do distinct selects.
Learn how to do table samplings (just learned this the other day! pretty coolWink )

Learn how to trap your mistakes, and roll them back.

Learn JOINS. Learn how to write your own views. Learn how to recursively modify data in a given table to fix the inevitable data errors your wonderful programmers will create. (No discussion of cursors.... Choose your own poison).


Learn how to use the tools (execution plans, optimizer, etc). I don;t think they do much good until you understand the underlying nature of the beast.... And our tracking db is a beast....
tyson.price
tyson.price
Old Hand
Old Hand (319 reputation)Old Hand (319 reputation)Old Hand (319 reputation)Old Hand (319 reputation)Old Hand (319 reputation)Old Hand (319 reputation)Old Hand (319 reputation)Old Hand (319 reputation)

Group: General Forum Members
Points: 319 Visits: 642
Run through this just to get the flavor:

http://www.w3schools.com/sql/default.asp
GSquared
GSquared
SSC Guru
SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)

Group: General Forum Members
Points: 55355 Visits: 9730
Still learning SQL -- consider myself a newbie still after 2 yrs becuase I am still learning new things every day....


I'm still learning new things nearly every day, and I've been doing this for nearly 8 years. Hard to consider myself a newbie, but really, I am.

- 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
MarlonRibunal
MarlonRibunal
SSC Veteran
SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)

Group: General Forum Members
Points: 291 Visits: 387

Learn how to use the tools (execution plans, optimizer, etc). I don;t think they do much good until you understand the underlying nature of the beast.... And our tracking db is a beast....


Execution Plans? See my post in my blog: http://dbalink.wordpress.com/2008/08/08/dissecting-sql-server-execution-plans-free-ebook/

-Marlon Ribunal

Marlon Ribunal
http://marlonribunal.com
Twitter @MarlonRibunal
Coyote Blue
Coyote Blue
SSC-Enthusiastic
SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)

Group: General Forum Members
Points: 186 Visits: 44
GSquared (8/8/2008)
Still learning SQL -- consider myself a newbie still after 2 yrs becuase I am still learning new things every day....


I'm still learning new things nearly every day, and I've been doing this for nearly 8 years. Hard to consider myself a newbie, but really, I am.


GS-
Still a newbie after 8 years makes me feel better... One of the things I love is when our db programmer has me do code reviews... Went from "ummm... whats this mean" to "Why are you joining these 4 tables that way!" & "Hmm.. this query/update procedure he wrote will benefit from a more covered index"... So maybe I am still a newbie, just not a newerbie.. Wink Smile
tyson.price
tyson.price
Old Hand
Old Hand (319 reputation)Old Hand (319 reputation)Old Hand (319 reputation)Old Hand (319 reputation)Old Hand (319 reputation)Old Hand (319 reputation)Old Hand (319 reputation)Old Hand (319 reputation)

Group: General Forum Members
Points: 319 Visits: 642
tutblog1 (9/19/2012)
Want to learn SQL?

Goto easysqlguide.blogspot.in

Easily learn SQL with the help of images.


The OP asked four years ago so maybe he/she picked up on it by now :-D
Snigdha Vartak
Snigdha Vartak
Say Hey Kid
Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)Say Hey Kid (692 reputation)

Group: General Forum Members
Points: 692 Visits: 247
Try

http://www.pinaldave.com/
http://www.w3schools.com/sql/
davinder2406
davinder2406
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 Visits: 293
Use Microsoft Virtual labs to practice SQL Server from below link
http://www.zilckh.com/learn-practice-or-explore-windows-softwares-on-microsoft-virtual-labs/
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