Best way to learn T-SQL for MS SQL Server?

  • Hello Everyone,

    At work, I've been getting more involved with hosting and database stuff. I currently do some very minor admin work with my limited SQL knowledge from college 11 years ago, but I'd like to expand my abilities in this area. It's all Microsoft SQL Server, so apparently it's Transact-SQL.

    As someone who went to school for programming, but never ended up working as a programmer, what books or web sites would you recommend for me to get acquainted with T-SQL? I'm looking for more of an introductory-level resource, which can prepare me for something more advanced once I'm comfortable. To give you an idea of my current knowledge and understanding, I struggle with understanding JOINs, and wouldn't be able to write my own stored procedure.

    Thanks very much.

  • If you have difficulty understanding joins you may want to start with a basic general SQL tutorial:

    https://www.w3schools.com/sql/

    If you want to learn t-sql you can read Itzik Ben-Gan's books. Maybe start with:

    https://www.microsoftpressstore.com/store/t-sql-fundamentals-9781509302000

    If you are interested in production DBA work, Brent Ozar has an outline DBA training plan:

    https://www.brentozar.com/archive/category/production-database-administration/dba-training-plan/page/2/

  • "Best way to learn T-SQL for MS SQL Server"?

    Start at the beginning.  See the following link with the understanding that it does cover more than just T-SQL and some of the functionality is not available in T-SQL  It's one of the best "start here" tutorials that I've found.

    https://www.w3schools.com/sql/default.asp

    A bit of a warning... UPDATE in T-SQL is quite different than some of the other database engines and the tutorial does NOT cover that (Joined Updates/Updating one table from another).

    Also, if you want to see a list of what's in SQL Server, they have a list on the left size if you scroll all the way to the bottom to see it.

     

    --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)
    Intro to Tally Tables and Functions

  • This was removed by the editor as SPAM

Viewing 4 posts - 1 through 4 (of 4 total)

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