database
-
hello, i m at just start to learn SQL.. plz give me guidance from which references i should proceeed! :) :-O
-
hello, i m at just start to learn SQL.. plz give me guidance from which references i should proceeed! :) :-O
Are you learning it fomr a development POV or as a potential DBA, they are 2 VERY different things. For development I would. Buy a beginner book on database design and work through the examples and then Do a search here and on SQLSErverCentral.com for articles on TSQL.
Never underestimate the power of human stupidity RAH
-
hello, i m at just start to learn SQL.. plz give me guidance from which references i should proceeed! :) :-O
Here's what I did to learn TSQL. I first downloaded and installed SQL Server 2008 Express R2 with Advanced Services. At that time I also downloaded the "Books-on-Line" help volume for that inastallation; typically available on the same webpage as the SQL Server Express Edition mentioned above, here-after refered to as the "BOL". Then, I went to codeplex and searched on the term "Adventure Works". The return was a dozen or so flavors of downloadable material available right there at codeplex. Downloading ALL of them, and then installing them on top of the new Express installation you've successfully just gone through results in only a few mixups when referenceing example code from within the BOL. And that's the key. The BOL maintains verbose example for practically everything you can do with SQL Server. Including codeplex's Adventure Works examples. The whole process, downloading, making sure you've got ALL the databases, then installing everything (loads of fun itself), is SO easy that not doing this and instead refering to some hardcopy volume by some third-party entrepreneur shipped with a dinky little disc of samples makes little sense. I guarantee you'll be TSQL coding in no time! And by the way, this BOL IS a HELP FACILILTY OF THE OLD KIND ... Guaranteed to be able to find what you're looking for because there's a list of everything in the left-hand margin. You do know A comes before B which comes before C ... in the alphabet, correct?
-
hello, i m at just start to learn SQL.. plz give me guidance from which references i should proceeed! :) :-O
-
test