New To SQL Server / Help Starting

  • Hi,

    I am new to SQL and for that matter to databases. Where do I start, any good books there

  • Itzik Ben-Gan just released a new book on TSQL Fundamentals. I can recommend that. Once you've got the fundamentals down, you might want to get his book called Inside Tsql Querying. He also has one on TSql Programming, but it might not be what you need right now. After that, I'm not sure. You'd need something on the basics of backups & restores, indexes, etc. I'm constantly chasing after advanced books on those topics, so I'm that familiar with what's available at the introductory level.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • What do you need to do? Are you administering SQL or developing?

  • Start here...

    http://www.sqlcourse.com/

    ... then move to Books Online which comes free with SQL Server... concentrate on the "Contents" tab.

    SQL Server is a big subject... don't try to learn it all at once. I recommend you stick with just the database engine and T-SQL for at least the first 3-6 months.

    --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 4 posts - 1 through 4 (of 4 total)

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