Good SQL Books

[mflancour]

My company has used MS Access for all it's database up to this point. We are looking into micrating to sql. Which is great except I dont have a whole lot of experience with it. I know sql query language well enough, but not much else other than putzing with one of our servers here and there.

My question is could some of you suggest books which will be helpfull for me at this point? I've found a ton of them searching the internet, but dont really know what ones I'll really need. On a side note, if I can get familiar enough with the product I am also thinking of taking a boot camp for MCDBA, so any suggestions for books specific to this would be helpfull as well.

Thanks a ton

 

[entaroadun]

The course materials used by IMG University are good. They consistently win Microsoft's best trainer award or whatever it's called.

No, I am not affiliated with them in any way.

If you want to sample books on the cheap, sign up with safari.oreilly.com. It's an online lending library. For a nominal fee, you get the right to read books from their extensive library. It contains all of O'Reilly's offerings, which are excellent.

It doesn't contain the publisher WROX, which is also consistently good.

Hope this helps.

 

[Rob999]

I really liked Wrox's Beginning SQL Server 2000 for Visual Basic Developers by Willis - if you know some Visual Basic. It does a good job of covering the essentials of SQL Server 2000 and how to interact with it using VB 6.0.

If you leave Access and were creating user forms, reports, and queries (which will now be stored procedures) using these features of Access, VB is a good substitute.

If you were just using it for data storage and the occasional data manipulation, you can certainly get by with SQL Server alone, but there are a lot of considerations with respect to the other tools Access provides intrinsically the Sql Server doesn't.

I believe the best high end stand alone SQL server book is Rob Viera's Professional SQL Server 2000, also by Wrox. But then again, I never buy a book without checking the reviews in Amazon.com. Good luck!

 

[miq]

"mastering sql server 2000" by mike Gunderloy/Joseph l. jorden from sybex is an excellent book. The best i have ever seen on sql server. It has something for everyone including Administrators , Developers etc. It also have introductory chapters for biggeners including databse concepts, normalization and also T-SQL reference.


I really love this book


Bye
miq

 

[JayKusch]

Don't forget to take a look at "Inside SQL Server 2000" by Karen Delaney. If the move from Access to SS2K is for sure, i would also suggest picking up the "Microsoft SQL Server 2000 Reference Library ". you can pick a copy, 6 book volume, up for around $75 on Ebay. Thanks

J. Kusch

 

[SQLBill]

Check out thread183-108206 for some other comments about books for SQL Server.

-SQLBill