Discussion Locked

Looking for a good book on SQL...

0 helpful
15 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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!

15 replies

by scmgithd

I guess I kept searching for "training" or "book" and didn't come up with anything that made a lot of sense. I'll spend some time on these sites and I should at least get the basics (which is all I really need).

Thanks for the help!

by mirrormirror

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.

by scmgithd

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!

by ahar

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

by ekammas

Hi, if your are seaching for books on Sql, you don't need to search far; try 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.

by scmgithd

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!

by ekammas

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.

by innocent_bystander

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.

by gnimgnuk

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.

by Member 34793965

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

This discussion is closed to new replies.