SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server T-SQL in 10 Minutes


SQL Server T-SQL in 10 Minutes

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: Administrators
Points: 62837 Visits: 19111
Comments posted to this topic are about the item SQL Server T-SQL in 10 Minutes

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
greg.kubat
greg.kubat
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 4350
I appreciate the review and agree that the web information is not well organized and can sometimes be a hair pulling experience tracking down the information you want without having to dig through a lot of information that is not needed. What would you then consider a good overall T-SQL book for those of us that want to better understand the differences with 2005?
Jerry Sommerville
Jerry Sommerville
SSC Rookie
SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)

Group: General Forum Members
Points: 38 Visits: 189
This particular artice caught my eye because I am looking for a good reference that covers the language, but is not the unabridged tome that you sometimes come across when looking for a good reference book. So my question to Steve is this - What would you recommend as a good reference book? One that does cover the language well including try, catch, apply, etc, etc...
Rod Harten
Rod Harten
SSC Rookie
SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)

Group: General Forum Members
Points: 44 Visits: 166
Steve Jones' review is accurate but misses the target audience of the book. The book is for people who are not programmers and not DB types. I wouldn't recommend it to anyone reading this forum because it is too basic.

That said, I have bought probably a hundred copies of the 1st and 2nd edition of this book for classes I teach to people here at work. It is an ideal introduction to T-SQL for those people who are comfortable using computers and need to know a little bit about queries but don't plan on writing them very often.

The writing in the first two editions book is very good -brief but clear. Each chapter does literally take only 10 minutes to go through.

As for books for people who are new to SQL Server but not new to the technical world. Here are my recommendations:

Rob Vieira's written Beginning SQL Server 2005 Programming and Professional SQL Server 2005 Programming. Both are well-written and cover a wide range of topics at an intermediate level of depth. You'll learn about creating a stored procedure, views, and triggers. There are chapters on normalization, Reporting Services, Integration Services, etc. Overall, these are good books for getting a good understanding about a concept or object. Then if you find you need more detailed information you can use that understanding to look in Books onLine or elsewhere. The difference between the Beginning book and the Professional book is mostly topic selection. So the Professional version has a chapter on Security, Cursors, and .Net which the Beginning book does not. Also, the books are not focussed on Administration or Peformance work.
rharderwijk
rharderwijk
SSC-Enthusiastic
SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)

Group: General Forum Members
Points: 190 Visits: 203
This book may not be what I need. Microsoft has a 'Writing Queries using SQL 2005 Transact-SQL' course (MS2778), but I cannot find a self-study guide or book that will cover the topics in that course. Any pointers to the right lit are highly appreciated!
Rod Harten
Rod Harten
SSC Rookie
SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)

Group: General Forum Members
Points: 44 Visits: 166
Actually, I was just talking with Todd Carrier (you'll find him on the forum lists) yesterday about the need for a book that teaches T-SQL and includes practice work like a high school or college textbook.

All the books that I have seen give you one example of each type of query and then maaaaybe give you a couple of examples of variations.

This is fine if you basically know what you are doing and just need to fill in some blank spots. However, I don't think it is sufficient for learning T-SQL from scratch.

Which is a long-winded way of saying, I don't have any good suggestions on books that focus just on learning how to write T-SQL. So below is what I can suggest not knowing your skill level.

I generally like the books prublished by Wrox and they produce a book called Beginning Transact-SQL. That might be at the appropriate level. If you are used to writing code in other languages, then Vieira's books would probably give you what you need. If you haven't written any code, or did so a long time ago, then check out Forta's book. It is not terribly expensive so if it is too basic not much is lost. Also, you can usually find a copy of Forta's book most Barnes and Nobles and often you can find copies of Vieira's books.

If you aren't familiar with Books onLine, that is a great resource. It is the documentation module that comes with SQL Server that everyone I know who works in SQL Server uses almost every day. In BoL you can scroll down to the examples to get ideas on how the actual code is written.

Lastly, if you start getting comfortable with T-SQL the Inside SQL Server 2005 books on Querying and Programming are well-written and cover a lot of ground. I wouldn't recommend them as your first books though as the assume familiarity and experience with T-SQL already.

Ken Henderson's Guru books for SQL 2000 are also very good but on the same high level.

Good luck with it.
Anipaul
Anipaul
SSCertifiable
SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)

Group: General Forum Members
Points: 7335 Visits: 1407
This is a good book to start with but to improve your skills in T-SQL you should refer other books. So better start with other books only instead of this one.



Steve Jones
Steve Jones
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: Administrators
Points: 62837 Visits: 19111
It is a good basic T-SQL book, but it doesn't cover 2005 stuff very well, which is disappointing with the sticker on the front that says it does.

I'm working my way through some other 2005 books, but I don't have a good T-SQL one to recommend. Rob is a good writer, so his books listed above are probably worth looking through.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
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