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

  • 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

  • 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
  • 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

  • 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

  • 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/

  • thanks guys. nice response!

    Fushan

  • 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)

  • 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

  • For the basics ....

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

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

  • 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/

  • 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

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

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

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