IT programming books related reviews
Title: MCSE SQL Server 2000 Database Design Exam Cram (Exam: 70-229)
Publisher: Coriolis Group Books
Authors: Sean Chase, Richard McMahon
Rating: 5/5
Well, I was learning MS SQL with this book after I had some development experience with MySQL. This actually was the right book for me and I was able to quickly study those aspects of MS SQL that are different from MySQL. I was not only able to pass the exam but also acquired skills that I am currenty using on my job.
You know, I noticed that my fellow developers are trying to programm all database transactions with SELECT, UPDATE, INSERT and DELETE only. When they need to delete a record and all other records that are referenced from it they create a long list of quieries, which works, but is actully a time spent in vain because you can create a better, easier and FASTER solution by implementing only one feature available in MS SQL. So study this book and you will know how to deal with MS SQL Server correctly.
Title: MCSE Database Design on SQL Server 7 Exam Prep (Exam: 70-029)
Publisher: Coriolis Group Books
Authors: Brad Schulz, Greg Woody, Jose Amado-Blanco, Pam Barker, Christopher Leonard, Christopher A. Leonard, Pamela Barker
Rating: 4/5
Each chapter was about 30 pages, so I was able to read one or two chapters each night. I passed the exam in about 2 months of studying using this book, Books Online that comes with SQL, and Transcender. I had very little knowledge of SQL Server when I started (I am an experienced VB programmer).My only criticism is that the chapter summary quiz questions were only on the CD, instead of in the book, so I just printed them out. Also, explanations of the answers on the quizes were seldom provided - other than reviewing the chapter again. (I prefer New Riders Publishing's approach in this regard). I didn't use the practice tests on the CD, so I can't comment on that.(climbing on soapbox) I'm a big fan of Transcender - but don't send me e-mail looking for my copy. If you're aiming to be a software professional, don't rationalize some excuse for ripping off some other software developer. (climbing off soapbox)
Title: Professional SQL Server 7.0 Programming
Publisher: Wrox Press
Authors: Rob Vieira
Rating: 5/5
Professional SQL Programming is an excellent reference book for those developing with SQL 7.0 or 2000 Beta! Vieira really knows his stuff & how to explain it too! The book is organized well enough that it is easy to use as a quick reference -- but it also provides enough information when you need to know more than just syntax. It reads well too ...
Title: Microsoft SQL Server 2000 Administrator's Companion (With CD-ROM)
Publisher: Microsoft Press
Authors: Marcilina Garcia, Jamie Reding, Edward Whalen, Steve Adrien DeLuca
Rating: 3/5
It is the best book I have read for the following areas:Clusters
DTC
RAIDThe problem with this book is that it is a little boring.
It is a good referential book. I do not recommend this book for beginners because it contains a lot of technical details.
Title: Understanding SQL and Java Together : A Guide to SQLJ, JDBC, and Related Technologies (The Morgan Kaufmann Series in Data Management Systems)
Publisher: Morgan Kaufmann
Authors: Jim Melton, Andrew Eisenberg
Rating: 1/5
I found the the C code examples unbelievable in a book that says it's for Java. The SQL is not your standard JDBC SQL its PL/SQL style. I wish I hadn't opened the CD in the back so I could return it. A waste of time and money. Perhaps if you are a very advanced SQL person and have a lot of experience with Java this might be a helpful book, but then you wouldn't want this book either, nothing good here.
Title: Administering Apache (Administering)
Publisher: Osborne/McGraw-Hill
Authors: Mark Allan Arnold, Clint Miller, James Sheetz, Jeff D. Almeida
Rating: 2/5
I got this book to learn on web-servers and Apache was chosen because it's free. After 5 minutes of reading the book and I got Apache 1.3.12 up-n-running and had my first web-site on display. I don't know how this book is on the advanced topics, but it's excellent for all that want to setup a web-server.
Title: Sams Teach Yourself PHP, MySQL and Apache in 24 Hours
Publisher: Sams
Authors: Julie C. Meloni
Rating: 1/5
I'm fairly new to Linux/Unix but I am no newbie to software. The installation instructions for MySQL on Linux are sketchy and basically say read the man page. If the man page was enough I wouldn't be buying a book. After stumbling thru the install there is no explanation of actually starting the MySQL software. Because I can't seem to get MySQL installed and running, PHP won't configure and install. I'm dead in the water so I don't know if the rest of the book was any good or not, I can't make it that far.For troubleshooting there are several recommendations for paid support. It looks like the author assumes a broad knowledge of Linux/Unix because the Windows installation instructions are very detailed.
Title: Oracle PL/SQL Best Practices
Publisher: O'Reilly
Authors: Steven Feuerstein
Rating: 5/5
I found this book to be an excellent (re-)introduction to good programming practices in PL/SQL. After reading the first few pages a little defensively ("I don't make those sorts of mistakes do I?") I soon realised that there was much to learn in this book as well as much that I had forgotten. This book has lead to an instant improvement in the quality of my PL/SQL code. I particularly like the Quick Reference card in the back of the book.
Title: Developing Time-Oriented Database Applications in SQL (Morgan Kaufmann Series in Data Management Systems)
Publisher: Morgan Kaufmann Publishers
Authors: Richard T. Snodgrass, Christian S. Jensen
Rating: 5/5
The one-of-a-kind book is a practical research on how the real world changes over time effect the viability of database design.
The author provides many solutions to real-life problems and (most important!) 'gotchas' of the these solutions. The examples are provided for many popular DBMSs(from MS Access to Oracle).
The reader benefits greatly from the superb organization of material, clear language and good illustrations.
The sidebar notes on history of time-measuring devices provide a nice break from the 'heavy-duty' stuff.
I bought my copy two month ago and it has already became a one of the best-thumbed books on my professional shelf.
Title: Microsoft SQL Server(TM) 2000 Programming Step by Step
Publisher: Microsoft Press
Authors: Rebecca Riordan
Rating: 1/5
If you have never used Microsoft SQL 2000 and would like an introduction to see if you want to get into MS-SQL Programming then this is the book for you. On the other hand if you already know that you want to learn MS-SQL Programming or have done some SQL programming don't waste your money, get Beginning SQL Server 2000 Programming by Robin Dewson ISBN: 1861005237 !Each lesson of this book walks you through step by step performing basic SQL programming techniques. Filled with screen shots to go with just about every step it is a great way to find out something about Microsoft SQL 2000. Once you have finished with the lessons then you will have a better feel for if you want to go further into SQL Programming (It took me a weekend to finish!). If/When you are ready to learn the programming aspect pick up a copy of the book recomended above, you will not be disapointed.Having some experience already with SQL 7.0 from a pure admin support stance I found very little in this book useful for my skill level (I knew what most of the GUI interfaces looked like already). The repetition got old when the writer told you everytime how to go into Design Table View 1 to 5 times for 12+ Chapters strait!

