Post reply

Books OnLine?

  • March 22, 2009 at 4:29 pm

    #201418

    Hi,

    What do you think about learning method/book for SQL Server!

    Is BOL best "book" where you can learn SQL Server?

    Regards!

  • March 23, 2009 at 12:56 am

    #964257

    check these links might be helpful for you

    1. http://vyaskn.tripod.com/coding_conventions.htm

    2. http://www.mssqltips.com/

    3. http://www.sql-ex.ru/exercises.php or http://www.sql-ex.ru --> Nice link to practice sql

    4. http://www.sqlcourse.com

    5. http://www.sqlcourse2.com

    6. http://databases.aspfaq.com/database/should-i-use-a-view-a-stored-procedure-or-a-user-defined-function.html

    7. http://www.sommarskog.se/index.html

    8. http://blog.sqlauthority.com/2007/04/21/sql-server-interview-questions-and-answers-complete-list-download/

    9. http://www.dbazine.com/sql/sql-articles/larsen5

    10. http://www.jumpstarttv.com/Media.aspx?vid=76

  • March 23, 2009 at 3:38 am

    #964289

    Hi Betim

    No, I would say to really learn SQL Server you should use another book. BOL are a great reference or to study new features. But basically to learn SQL Server (I think you speak about SSE) you should use a real book.

    To Rajesh:

    Nice link collection! 🙂

    Greets

    Flo

  • March 23, 2009 at 6:35 am

    #964358

    Hi guys,

    Thanks a lot for your posts!

    First I am not SQL Server newbie, and 2nd I am asking in the kind of poll!

    Thanks!

  • March 23, 2009 at 7:04 am

    #964378

    I don't know if it's the best place to learn SQL Server from, but I do know that it's open on my desktop most days and it's the first place I go any time I have a question or want to learn about something related to SQL Server. It's a fantastic resource.

    "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

  • March 23, 2009 at 7:09 am

    #964385

    I'm with Grant on this one.

    I don't think a day goes past without me using BOL, however I wouldn't recommended to someone learning SQL for the first time.

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

  • March 23, 2009 at 7:37 am

    #964404

    BOL is a little to sparse and summarized for someone who doesn't already know their way around SQL Server a bit. I recommend an actual book on the subject to learn it, then BOL to get specifics when you want to use a feature you don't already have memorized.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • March 23, 2009 at 2:50 pm

    #964797

    websites like SSC, discussion groups, BOL, 'old fashioned' books and the like are great resources. However there is one important piece of the puzzle missing, that is a mentor. This is someone more knowledgable than you that you can speak with and discuss things with. If there are none suitable where you work at, try local SQL Server user groups for a start and get to networking and meet that 'mentor'.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • March 23, 2009 at 4:29 pm

    #964862

    Betim Drenica (3/23/2009)

    Hi guys,

    Thanks a lot for your posts!

    First I am not SQL Server newbie, and 2nd I am asking in the kind of poll!

    Thanks!

    Heh... you should have stated that in your original post. If you want to learn about real world problems and some of the awesome solutions there are, then start hanging around here... some of the best and brightest work their magic on the hallowed pages of this forum... stuff you'll likely never see in a book anywhere.

    And, to answer your question... no... Books Online isn't the best... it's just one you can't do without.

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

  • March 23, 2009 at 4:53 pm

    #964875

    Jeff Moden (3/23/2009)

    If you want to learn about real world problems and some of the awesome solutions there are, then start hanging around here... some of the best and brightest work their magic on the hallowed pages of this forum... stuff you'll likely never see in a book anywhere.

    Jeff, I have to agree with your comments about the talent contibuting here, I've been working with SQL Server since 6.0 and I know something about it. But you guys help increase that every day.

    It's a huge subject, we all know different stuff, and we can all learn from each other.

    I try to help in the same way, when I can contribute.

    .

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

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