Any good online tutorials to practice joins/selects etc?

  • Suggestions appreciated,

    JB

  • A pretty good source is w3schools. This site offers lots of differnent tutorials and practices, with easy to understand examples.

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

  • I would like to also add that some of the best practice you can get is by helping others solve problems on sites such as SQL Server Central. Solving problems and reading solutions is what got me to where I am.... even if that is not so far 🙂

  • One of the best resources online is Safari (not the browser):

    Safari Books Online[/url]

    Basically, for print books on-line for a monthly subscription fee. Some professional organizations, like ACM (see Andy Warren's blog posts), offer one of the Safari subscriptions as part of the membership.

    Other than that, look for Itzik Ben-Gan's column at SQLMag.com as well as just trying to help folks solve T-SQL issues on forums like this one (as has been previously mentioned).

    K. Brian Kelley
    @kbriankelley

  • Adam Haines (3/31/2008)


    A pretty good source is w3schools. This site offers lots of differnent tutorials and practices, with easy to understand examples.

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

    Yeah... just remember... that's not T-SQL... and the UPDATE examples are really lame... they never show you how to update based on a JOIN. But I agree with Adam... the basics are all there and the examples are simple.

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

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

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