Order from a Major Online Bookstore
Ultimate Book Price Comparison Engine
Save Your Time And Money
| AnyBook4Less.com | Order from a Major Online Bookstore |
|
| Home | Store List | FAQ | Contact Us | | ||
| Ultimate Book Price Comparison Engine Save Your Time And Money |
||
 |
Title: Beginning SQL Server 2000 Programming : by Robin Dewson ISBN: 1-59059-252-2 Publisher: APress Pub. Date: 27 August, 2003 Format: Paperback Volumes: 1 List Price(USD): $44.99 |
Average Customer Rating: 3.71 (14 reviews)
Rating: 2
Summary: Not Very Beneficial
Comment: I read this book cover to cover only because I was required to for a graduate level class. Let's be clear about the type of book this is: one of those hand-holding exercises that walk you through every screen of the product, including a fifty-page chapter on installation, and manages to get at least two plugs per chapter in for another book by the same publisher. If you're looking for that sort of thing, it is fairly thorough and well thought-out and does include a significant amount of information on pitfalls to avoid. However, I personally found little here that I couldn't have found myself simply by installing the product and reading the online help. The pitfall warnings could have been condensed into a single chapter (and would have been much more useful than this 700-page tome). If you're looking for database theory, look elsewhere. Those kinds of issues are given short-shrift - normalization, for example, is glossed over in two pages that don't really explain it well, even though this is a key database management concept. I realized something was wrong when by chapter 12 (of 20) I was still reading statements like, "Don't worry too much about the SQL syntax shown here". Really? By the end of the book I was still wondering when we would become concerned. Mr. Dewson is obviously a knowledgeable database developer, and from his picture on the cover appears to be a nice person, but he is not a professional writer, and unfortunately it shows.
Rating: 5
Summary: Great Book for Learning SQL Server 2000
Comment: I went through three books (Learning SQL Server in 21 Days, SQL Server Programming by Microsoft, SQL Server 2000 for Visual Basic Developers) before I got to this one. This book beats all those others hands down. This is definitely the best book to get on learning SQL Server for beginners. It touches on all the areas you need to know to become proficient in managing your databases. I highly recommend it.
Rating: 5
Summary: Good book. Detailed review below...
Comment: This is an excellent beginners book. From installation through to triggers all you need to know to get up and running. Shame it is missing about User Defined Functions but I thought this was a really good book.
Chapter 1 - Good coverage of the versions, whats what. Also liked the installation of SQL Server.
Chapter 2 Covered areas such as Enterprise Manager well and like the Configuring section. Found out how to set some very useful propreties
Chapter 3 - Query Analyzer. Went through every item that a beginner should need as well as an intermediate. Helped me figure out and set up as I wanted
Chapter 4 - This chapter for DB design etc is very clear and concise. I liked the Normalization section as well as relationships as to how these work
Chapter 5/6/7 - Enough coverage and good warnings about the system databases and building the sample db. Also loved the defining tables and the different data types and finally all about the different indexes you can have. Very useful.
Chapter 8 - This was my favourite chapter as it showed how to build relationships between tables.
Chapter 9 - didnt think this was really necessary
Chapter 10 - Good basics of backups. Not much on network backups.
Chapter 11 - Good basics again of maintenance
Chapter 12 - Images!! Yes!! No-one else I know touches this.
chapter 13-15 - Loved transactions in the Insert chapter. all the others cover good basics of T-SQL
Chapter 16 - Could have done a bit more on indexing a view but apart from that shows how to create a view well. Also how to use it
Chapter 17/18 - Would have liked to see more about nested stored procedures but again good coverage. Dealing with errors was my favourite part
Chapter 19 - XML - The way so much is going. Maybe book needs updating for SQLXML 3.0?
chapter 20 - A bit advanced for beginners but triggers are a great plus.
As I say, this is the best beginning SQL Server book I bought (this was my third!) and I loved the authors style and content. Wasnt confused at any point and found all that was being said to be clear. Wish I had bought it first
Its downfalls? Well images it does say you need a binary stream to input an image but doesnt show any VB code to pass it in. No UDF's or UDT's and no coverage of SQL XML 3. Dedication was interesting but a bit long....
Excellent coverage on how to complete each action in any method you wish so this does lead to excellent T-SQL coverage.
Loved it
 |
Title: Professional SQL Server 2000 Programming by Robert Vieira ISBN: 0764543792 Publisher: Wrox Pub. Date: 15 November, 2000 List Price(USD): $59.99 |
 |
Title: Professional SQL Server 2000 Database Design by Louis Davidson ISBN: 1861004761 Publisher: Wrox Press Inc Pub. Date: March, 2001 List Price(USD): $49.99 |
 |
Title: SQL Server 2000 Programming by Example by Carlos Rojas, Fernando Guerrero ISBN: 0789724499 Publisher: Que Pub. Date: 17 April, 2001 List Price(USD): $39.99 |
 |
Title: Beginning SQL Server 2000 for Visual Basic Developers by Thearon Willis ISBN: 1861004672 Publisher: Wrox Press Inc Pub. Date: 15 January, 2000 List Price(USD): $39.99 |
 |
Title: The Guru's Guide to Transact-SQL by Ken Henderson ISBN: 0201615762 Publisher: Addison-Wesley Pub Co Pub. Date: 23 February, 2000 List Price(USD): $54.99 |
Thank you for visiting www.AnyBook4Less.com and enjoy your savings!
Copyright� 2001-2021 Send your comments
