General discussion

  • Creator
    Topic
  • #2188345

    Looking for a good book on SQL…

    Locked

    by scmgithd ·

    This is an elementary question, but we have MSDE 2000, which I understand is a “crippled” version of SQL. Would a SQL book still be helpful? Any opinions on good books? Our software vendor is offering a seminar on using MSDE with Great Plains but I’m annoyed at them after their last user group and would rather just find a good book.

    I have no experience with SQL and very little with the Windows 2003 server.

    Any advice would be great. Thanks!

All Comments

  • Author
    Replies
    • #3238879

      This one’s not bad for starters

      by oz_media ·

      In reply to Looking for a good book on SQL…

      A link not a book;
      http://www.1keydata.com/sql/sql.html

      or

      W3Schools is usually a prety good place to get the straight goods,
      http://www.w3schools.com/sql/default.asp

      There are quite a few FREE online tutorials and resources that are really good if you do a simple search.

      Good luck

    • #3238871

      MSDE documentation

      by mirrormirror ·

      In reply to Looking for a good book on SQL…

      Here is the link for the MSDE docuementation from Microsoft. MSDE is not a crippled verson but it does have some limitations. You have to know the SQL DBCC commands and regular SQL to query from it but otherwise it is a good free product. If you have Enterprise Manager, you can register a MSDE instance and can manage it with EM. All of the SQL books will be devoted to full blown SQL Server with a GUI or at least ISQL that I know of. Good luck in your search.

      • #3256462

        Thanks for the info but where is the link?

        by scmgithd ·

        In reply to MSDE documentation

        I’m feeling like a complete moron right now. LOL I’m new to the site…did I miss the link? I’ve tried searching the microsoft site but didn’t come up with much. I guess I need to refine my searching skills 😉

        Thanks again!

    • #3238695

      Reply To: Looking for a good book on SQL…

      by ahar ·

      In reply to Looking for a good book on SQL…

      Get the current Version of the M$ SQL-Server Online-Documentation. BTW there is a new ServicePack for the SQL-Server and also for the MSDE

    • #3237453

      Book on SQL

      by ekammas ·

      In reply to Looking for a good book on SQL…

      Hi, if your are seaching for books on Sql, you don’t need to search far; try http://www.amazon.com

      They have in stock books for both novices and experts at very affordable prices.

      And a large rang in stock too. I had the same problem with .NET technologies. I got all my materials to help me in developing .Net applications from there.

      ‘hope this helps.

      • #3256459

        I tried Amazon but couldn’t decide…

        by scmgithd ·

        In reply to Book on SQL

        I don’t want to get into programming, don’t need to set it up, just wanted to know how to query, basic troubleshooting, etc.

        Oz gave me a couple good sites that I think will suffice. Thanks for your help!

        • #3239144

          Sites as per SQL

          by ekammas ·

          In reply to I tried Amazon but couldn’t decide…

          OK, it’s good you’ve gotten some kind of help. I’m only just a started. What sites did Oz suggest? Perhaps it will help me advance in my level of SQL knowledge.

          Thanks.

        • #3170163

          They are listed in this thread

          by scmgithd ·

          In reply to Sites as per SQL

          Just above this post.

          Donna

      • #3242665

        Good SQL Server Book

        by jfulgieri ·

        In reply to Book on SQL

        This book has been excellent all around for me. From the gui side to transact sql: see

    • #3242570

      Research Online Reviews

      by innocent_bystander ·

      In reply to Looking for a good book on SQL…

      I search for the topic I want on Amazon. Then I look at only the highest rated selections. For each of those I read all the user comments. It has to have raves from nearly everyone. If there are a few bad reviews I look at the nature of the review and the profile of the reviewer. Since I started doing that I have not been burned on a book.

      Another option is to get a trial subscription to O’Reilly/Safari. Do a search and sort by descending copyright date. Then you can look at the latest releases first and review them on Amazon. I would advise you to subscribe to Safari and take advantage of being to look at a large number of references on a given subject. I have no connection with Safari or O’Reilly. I haven’t bought a technical book since I started subscribing. I just change the books on my online bookshelf as required.

    • #3242527

      Good MSDE book

      by gnimgnuk ·

      In reply to Looking for a good book on SQL…

      I think you need more than just a SQL primer. There is a book called ‘MSDE Developer’s Guide’ by Dan Rahmel that covers a lot of area for someone with no database experience…and it is specific for MSDE. BTW, the upcoming SQL Express 2005 will be virtually identical to SQL Server. So any SQL Server resource will apply.

    • #3180561

      SQL Basics

      by rick-businessdatasolutions ·

      In reply to Looking for a good book on SQL…

      I used to teach an SQL course at the college level and used “Understanding SQL” by Martin Gruber (Sybex ISBN 0895886448) as the course text. I’m sure there must be a newer edition out.

      Lots of people use SQL (the language) and Microsoft SQL Server as if they are one and the same. They aren’t. I would recommend you learn SQL the language first, then learn about Microsoft’s version of it.

      You didn’t mention how much database experience you have, but if you are an Access developer, a good book for you might be “Professional SQL Server Development with Access 2000” by Rick Dobson (WROX ISBN 1861004834).

Viewing 6 reply threads