Page 1 of 2 12 LastLast
Results 1 to 15 of 17

Thread: SQL (all)

  1. #1
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SQL (all)

    I guess this is the closest thing here to an SQL forum.

    A number of years ago, I had heard that Joe Cleko's books were the best place to start for SQL.

    What are the recommended beginning, intermediate and advanced SQL books these daze?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SQL (all)

    SQL the language or SQL Server? Joe Celko is still the acknowledged guru of the SQL language, and SQL For Smarties is a good book. If you want a quick reference that applies to most of the SQL dialects, try O'Reilly's SQL in a Nutshell, by Kevin Kline.
    Charlotte

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SQL (all)

    If you are a beginner and using Microsoft's SQL Server, then Murach's SQL for SQL Server (2002) by Bryan Syverson is a good book. Otherwise, SQL for Smarties is also my recommendation. --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  4. #4
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL (all)

    I've heard that a new edition of Smarties is due in May (ISBN 1556609202).
    Guess I'll wait fer that.

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL (all)

    The book due in May is not the same book, rather it is "Joe Celko's Trees and Hierarchies in SQL for Smarties".
    And the current book seems to address SQL 92, not SQL 99.

  6. #6
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL (all)

    Any opinions on Apress title "The Programmer's Guide to SQL" by Christian
    Darie and Karli Watson?

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SQL (all)

    I'm sure I have that book, but I can't find it at the moment, and I don't recall specifically anything about it. Of course, I can't lay hands on any of my SQL books at the moment, but if you want to know about ADO books ... <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Charlotte

  8. #8
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL (all)

    I too periodically "misplace" books.

    Actually, I often find that they are not really misplaced, rather they are buried in a bile of papers, hiding their position.

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: SQL (all)

    > a bile of papers

    <img src=/S/barf.gif border=0 alt=barf width=64 height=23>

  10. #10
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL (all)

    Choose from:

    bile, file, mile, nile, pile, rile, tile, vile

  11. #11
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL (all)

    I'm kinda surprised that Charlotte is the only one familiar with that book.

  12. #12
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: SQL (all)

    Given that nobody has reviewed it on Amazon, I'm not too surprised. Most of us work with only one or two variants of SQL, and there are usually resources in books on the specific product you are using that give you most of the details. In addition, SQL is not a procedural programming language per se in many respects, though most vendors have implemented some procedural concepts in order to do things such as stored procedures. I think you would find it a good book to start with - you might begin by playing with mySQL, as it is an open source product, and many website use it for their data store. A final note - most database products do not conform to SQL-99 as it is a standard introduced long after the products were available - in fact most are not strictly compliant with its 92 predecessor.
    Wendell

  13. #13
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL (all)

    One of my concerns is the book may be one of the titles that Apress purchased when Wrox Press went out of business.

    I've never been satisfied with most books from Wrox.

  14. #14
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SQL (all)

    I, on the contrary, have been *very* happy with WROX titles. But then, I buy books after looking through them (except the ones where I know the authors), so I know in advance whether the book generally covers the topics that are of interest to me.
    Charlotte

  15. #15
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SQL (all)

    Hi, my name is Charlotte and I buy books ... and I read most of them, too. <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

    I loaned out some books to a friend who was working with SQL Server, and I don't think all of them found their way home. I know that now I'm working with SQL myself, I can't seem to find any of the books I bought a couple of years ago. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>
    Charlotte

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •