good book or webite to learn the basic on TSQL and/or SQL server

Question

good book or webite to learn the basic on TSQL and/or SQL server

Fushan

Valued Member

Points: 68
More actions
August 6, 2013 at 4:35 pm

#296480

Hi : I have been oracle developer for some years. Recently, I start to support SQL server using TSQL. I need a book or not too expensive online course to learn the TSQL 101. I found some material online to learn the SQL Server as database enginer or SQL server managment stuido as a tool. But I need to go back to TSQL to learn how to write a function, package... how to declare variable....etc
Any suggestion?
Fushan

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Itzik Ben-Gan's T-SQL Fundamentals. Available from Amazon, there's a 2008 version and a 2012 version

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

craig.dixon Say Hey Kid Points: 688 More actions · Answer 2

Hi Ora,

Gail always has great advice so if the book isn't to expensive I'd order it. If your looking for somewhere with a very basic step by step approach with some tools to test the outputs of simple queries etc. you could check out w3schools until the book arrives in the post 🙂

http://www.w3schools.com/sql/

Hope it helps,

Craig

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

GilaMonster (8/6/2013)
Itzik Ben-Gan's T-SQL Fundamentals. Available from Amazon, there's a 2008 version and a 2012 version

+1 Any book by Itzik is well worth the read.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

You might also click on the Stairways over on the left side. There are a number of series that start out basic and get more advanced as they go.

Also, make sure you check out the question of the day (QotD) on the left side. It is a great learning tool about a variety of topics. Make sure you follow the discussions. Often times the discussion is more informative than the question itself.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Fushan Valued Member Points: 68 More actions · Answer 5

Fushan

Valued Member

Points: 68

August 7, 2013 at 11:47 am

#1639494

thanks guys. nice response!

Fushan

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 6

Sean Lange (8/7/2013)
You might also click on the Stairways over on the left side. There are a number of series that start out basic and get more advanced as they go.
Also, make sure you check out the question of the day (QotD) on the left side. It is a great learning tool about a variety of topics. Make sure you follow the discussions. Often times the discussion is more informative than the question itself.

Be advised that at least one author over on the "stairway" has an extremely annular fixation on the use of ANSI-only code. Of course, that's great for the basics but it won't cover things like how to use the proprietary UPDATE of SQL Server, which can be a whole lot faster than an ANSI standard update when trying to update many columns. The UPDATE statement in SQL Server doesn't actually meet ANSI standards since you can't list multiple columns around a single "=".

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 7

Jeff Moden (8/7/2013)
Sean Lange (8/7/2013)
You might also click on the Stairways over on the left side. There are a number of series that start out basic and get more advanced as they go.
Also, make sure you check out the question of the day (QotD) on the left side. It is a great learning tool about a variety of topics. Make sure you follow the discussions. Often times the discussion is more informative than the question itself.
Be advised that at least one author over on the "stairway" has an extremely annular fixation on the use of ANSI-only code.

I wonder who that might be. :hehe:

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

RichardIfUwill Valued Member Points: 54 More actions · Answer 8

For the basics ....

http://www.w3schools.com/sql/

"To be 'The Man,' you gotta beat the man!" ~The Nature Boy

Sean Lange SSC Guru Points: 286590 More actions · Answer 9

Jeff Moden (8/7/2013)
Sean Lange (8/7/2013)
You might also click on the Stairways over on the left side. There are a number of series that start out basic and get more advanced as they go.
Also, make sure you check out the question of the day (QotD) on the left side. It is a great learning tool about a variety of topics. Make sure you follow the discussions. Often times the discussion is more informative than the question itself.
Be advised that at least one author over on the "stairway" has an extremely annular fixation on the use of ANSI-only code. Of course, that's great for the basics but it won't cover things like how to use the proprietary UPDATE of SQL Server, which can be a whole lot faster than an ANSI standard update when trying to update many columns. The UPDATE statement in SQL Server doesn't actually meet ANSI standards since you can't list multiple columns around a single "=".

This is specifically why I mentioned to read the discussions. 😉

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Dawn W Ten Centuries Points: 1010 More actions · Answer 10

Have you checked out the MSDN site? Search for T-SQL and you can find lists of commands and what they do. There is also good developer centric information too. If your employer will pay for it, check out getting a MSDN subscription.

http://msdn.microsoft.com/en-us/default.aspx

OTF SSCertifiable Points: 6104 More actions · Answer 11

A +1 on the Itzik TSql Fundamentals book. Money well worth spending.