T-Sql Beginning !!

  • Hello

    Can anybody direct me to good site/article for T-sql beginners.Only sites/article which is helpful in your view from a beginners prespective?

    Thanks

    Rafi-

  • http://www.databasejournal.com/features/mssql/archives.php

    archive goodies, dig-in and all sort of tips & tricks 

     

  • That is not bad,But it is a mess of every thing.I am asking any site/Article  devoted for T-sql which anybody found useful in their learning (Beginning)

    Thanks

    Rafi-

  • Well Books On Line is where I began to learn some like stored procedures etc.

  • BOL is fine and useful,but my point is anybody from their personal experience can point out any site/article for T-sql beginners which is simple and easy to learn with exercise.Google around the net will produce more links but Due to information overload it is difficult to find which is good and bad,thst is why i am relaying on experienced hands here.

    Thanks

    Rafi-

  • Best way to learn T-SQL? No contest. Access wins.

    Use MS Access Northwind database, or connect to your own database. Using Access query wizards, to create queries, open them in the SQL view, and you'll quickly learn the syntax.

    If you don't have MS Access, use MS Excel, and connect to your data with the built in MS Query.

     

    Good Luck.

  • I don't know if you are intested in books, but SQL for SQL Server (Murach) is a great intro to T-SQL. I really like their format (normal textbook stuff on the left page, examples on the rght side).

     

     

  • Try this site:

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

  • I second the nomination on...

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

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

  • Hi All,

    This is nice and interesting.This type of links and sharing of experience i am looking for.Any body has any further idea please respond so that this will become a good contribution for beginners in T-Sql.

    Thanks

    Rafi-

Viewing 10 posts - 1 through 9 (of 9 total)

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