General discussion
-
CreatorTopic
-
May 17, 2005 at 12:51 pm #2188345
Looking for a good book on SQL…
Lockedby scmgithd · about 18 years, 10 months ago
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!
Topic is locked -
CreatorTopic
All Comments
-
AuthorReplies
-
-
May 17, 2005 at 2:41 pm #3238879
This one’s not bad for starters
by oz_media · about 18 years, 10 months ago
In reply to Looking for a good book on SQL…
A link not a book;
http://www.1keydata.com/sql/sql.htmlor
W3Schools is usually a prety good place to get the straight goods,
http://www.w3schools.com/sql/default.aspThere are quite a few FREE online tutorials and resources that are really good if you do a simple search.
Good luck
-
May 19, 2005 at 6:12 am #3256463
Those are great sites…
by scmgithd · about 18 years, 10 months ago
In reply to This one’s not bad for starters
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!
-
March 23, 2010 at 4:44 am #2831508
Not exactly a book but a good resource
by snk11 · about 14 years ago
In reply to This one’s not bad for starters
You my find this useful; specially if you are interested in building database applications using either of the languages C#.net or Java: http://www.shahriarnk.com/Shahriar-N-K-Research-Embedding-SQL-in-C-Sharp-Java.html
And before I buy any book, I would actually try sampling a few eBooks which are available for free download.
Shahriar Nour Khondokar: http://www.shahriarnk.com/
-
-
May 17, 2005 at 2:54 pm #3238871
MSDE documentation
by mirrormirror · about 18 years, 10 months ago
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.
-
May 19, 2005 at 6:14 am #3256462
Thanks for the info but where is the link?
by scmgithd · about 18 years, 10 months ago
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!
-
-
May 17, 2005 at 11:26 pm #3238695
Reply To: Looking for a good book on SQL…
by ahar · about 18 years, 10 months ago
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
-
May 19, 2005 at 6:15 am #3256461
Thanks…I’ll have to check on the service pack!
by scmgithd · about 18 years, 10 months ago
In reply to Reply To: Looking for a good book on SQL…
n/t
-
-
May 18, 2005 at 8:41 am #3237453
Book on SQL
by ekammas · about 18 years, 10 months ago
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.
-
May 19, 2005 at 6:16 am #3256459
I tried Amazon but couldn’t decide…
by scmgithd · about 18 years, 10 months ago
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!
-
May 25, 2005 at 12:38 am #3239144
Sites as per SQL
by ekammas · about 18 years, 10 months ago
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.
-
June 1, 2005 at 11:58 am #3170163
They are listed in this thread
by scmgithd · about 18 years, 10 months ago
In reply to Sites as per SQL
Just above this post.
Donna
-
-
May 24, 2005 at 6:16 am #3242665
Good SQL Server Book
by jfulgieri · about 18 years, 10 months ago
In reply to Book on SQL
This book has been excellent all around for me. From the gui side to transact sql: see
-
-
May 24, 2005 at 8:49 am #3242570
Research Online Reviews
by innocent_bystander · about 18 years, 10 months ago
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.
-
May 24, 2005 at 9:55 am #3242527
Good MSDE book
by gnimgnuk · about 18 years, 10 months ago
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.
-
May 31, 2005 at 7:26 am #3180561
SQL Basics
by rick-businessdatasolutions · about 18 years, 10 months ago
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).
-
-
AuthorReplies