Please recommend SQL book with excercises

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • vmnvmcxbv

    Please recommend SQL book with excercises

    I have beginner knowledge of SQL (I use MS SQL Server). I recently finished
    "SQL for dummies" book and now need something more advanced with a lot of
    exercises writing queries.

    Can anyone recommend such a book?


  • Stuart Ainsworth

    #2
    Re: Please recommend SQL book with excercises

    On Apr 13, 10:45 am, "vmnvmcxbv" <ruyeir...@fhsd khf.netwrote:
    I have beginner knowledge of SQL (I use MS SQL Server). I recently finished
    "SQL for dummies" book and now need something more advanced with a lot of
    exercises writing queries.
    >
    Can anyone recommend such a book?
    When I first started learning SQL, there were two books that I thought
    were excellent:

    John Patrick's SQL Fundamentals, a workbook with lots of hands-on
    exercises. Material was good, but his editor for the first edition
    should have been replaced; there were mistakes everywhere, including
    an editor's note embedded in the actual text (I believe the second
    edition corrected these problems).


    Ben Forta's 10 Minute Guide to SQL is also an excellent guide for
    beginners; he really focuses on the language and concepts without
    getting too involved in database maintenance issues.



    HTH,
    Stu

    Comment

    • --CELKO--

      #3
      Re: Please recommend SQL book with excercises

      >Can anyone recommend such a book? <<

      Rick van der Lans INTRODUCTION TO SQL has been around for 20+ years
      and each chapter has lots of simple SQL exercises with answers.
      Warning! He uses some dialect (MySQL mostly) in places, so you have
      to be careful.

      My SQL PUZZLES & ANSWERS describes itself in the title. You get a
      problem, then a set of possible queries with a discussion of each
      answer. It just got translated into Japanese and Chinese. I had two
      really good editors who fixed minor errors and added some more
      solutions of their own. If you read Japanese or Chinese, these are
      better versions than the English edition. Warning! A lot of the
      puzzles are weird, tricky things that make good puzzles, but are not
      the sort of thing you would want to have in production code.

      Since you are still a beginner, I would get a copy of SQL FOR SMARTIES
      for advanced programming tips. But you might want to start with
      THINKING IN SETS; the big problem that newbies have is switching from
      file systems and procedural coding to sets and declarative
      programming. Remember how hard is was to get your head around
      recursion? It is that kind of mindset change.

      Comment

      Working...