IT programming books related reviews
Title: Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems)
Publisher: Morgan Kaufmann
Authors: Joe Celko
Rating: 5/5
Celko has an amazing ability of making technical stuff seem readable and easy. A very enjoyable read.
Title: SQL: The Complete Reference, Second Edition
Publisher: McGraw-Hill Osborne Media
Authors: James R Groff, Paul N. Weinberg
Rating: 4/5
This book is, at the same time, too complete and not complete enough. The entire back half of it deals with things I'll never need, but when it came time to learn the functions, there was hardly any discussion. I've noted that this is the major gripe of other people as well.Still, it's many, many, many simple examples are very helpful to a novice/intermediate user such as myself, and I've found it easy to follow because of them.
Title: Microsoft(r) SQL Server(tm) 2000 Reference Library
Publisher: Microsoft Press Rating: 1/5
This book is more than reference, it helped me to understand everything what I needed and to resolve all the problems that I had have on SQL server 2000 (it is not for dummies). Very good organized (reed how to use this book carefully). DVD included inside the book, it is vary helpful. You can install the MSDN 2000 in your computer and if you have time you can watch and listen around 60 hours movies of discourses about MSDN 2000.
I was using different books reading on Replication Chapter but when I bought this book I understood almost every thing about Replication, it has 336 pages to reed and 3 hours movies discussion just for replication.This book is must have for them who gonna work with SQL server.
Title: Web Programming in Python: Techniques for Integrating Linux, Apache and MySQL
Publisher: Prentice Hall PTR
Authors: George K. Thiruvathukal, Thomas W. Christopher, John P. Shafaee
Rating: 5/5
One of the best books around on web programming. A must-read for any programmer trying to build e-commerce applications.
Title: Scripting XML and WMI for Microsoft(r) SQL Server 2000: Professional Developer's Guide
Publisher: John Wiley & Sons
Authors: Tobias Martinsson
Rating: 5/5
Wanted to learn programming SQL Server 2000 with WMI. I'm a programmer, so the book's approach fits me. WMI text and samples worked for me. I learned WMI. I'm happy.XML is not what I bought it for. I know MSXML, XSLT, XPath, yada yada yada. But I found some stuff I can use with ADO and MSXML. It's a bonus.Another bonus: the code samples are available in Perl. Found them on the CD-ROM next to the VBScript samples. A pleasant surprise because the booktext shows example-code in VBScript.
Title: Inside Microsoft SQL Server 6.5 (Microsoft Programming Series)
Publisher: Microsoft Pr
Authors: Ron Soukup
Rating: 5/5
I bought this book based on the good reviews it received here,but I was severely disapointed. Soukup claims that installingSQLServer is easy. "I'm proud to say that even a novice can comfortably install SQLServer in less than 10 minutes", he writes in the book. But nothing could be further from the truth. I've installed databases on UNIX (Linux and SolarisX86) and personal Oracle for Win95, without any problems, but SQLServer stubbornly refused to install on my WinNT 4 Server. In spite of numerous problem reports Soukup doesn't even mention that you might not be able to install SQLServer on your machine, let alone give you any guidance about what to do if you do have problems. In addition to these problems I found that the rest of the book is bloated with advocacy and fluff. I've worked with one SQLServer installation that crashed several times a day. Yet there is no entry for "reliability" in the index. Soukup was general manager for SQLServer and this book appears to be an advocacy job instead of an attempt to address the problems that people have encountered with his "child". Interestingly, he notes the frustrations that some customers have had with SQLServer, but apparently feels no obligation to try and provide fixes or a work around for them. This will be the first book that I've been forced to return for a refund in a long time. And it definitely does not deserve the good reviews it has received.
Title: SQL Server 7 Developer's Guide
Publisher: Osborne Publishing
Authors: Michael Otey, Paul Conte
Rating: 3/5
I've been learning more stuff and I got more books and the new things altered my rating standards.The Access integration and the database integration programming is all too obsolete. Access2000 supports OLE-DB connections to SQL server with .adp files. This book teaches the old Access97 method in using ODBC link tables. Also, outside the function/constant reference, the Microsoft Implementation Trainging Kit (Like a lot, but at $80, needs to be better), and the DBA Survival Guide makes the DBA portion of this book worthless. Inside SQL Server rocks and with the DBA survival guide equates to the best $80 investment for SQL Server Admin/Development.I wasn't really interested in the database integration part of the book. I only bother with ADO and ASP books cover that very well.
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!
Title: XML and SQL Server 2000
Publisher: New Riders Publishing
Authors: John Griffin
Rating: 5/5
I haven't finished reading this yet but I just had to put it down real quick so I could tell eveyone how useful this book is. I'll warn you up front, you have to take the time to read this - it is packed with information. The XSLT chapter goes into great detail and takes the confusion surrounding this topic and blows it away. The rest are very informative, too. This book is far better than the Henderson/Soukup Guru's guide. Buy this one and you won't need anything else.
Title: Web Database Applications with PHP & MySQL, 2nd Edition
Publisher: O'Reilly
Authors: Hugh E. Williams
Rating: 5/5
As the title indicates, this book is all about building websites powered by database applications. The book uses PHP and MySQL for a scripting language and a database technology respectively. Familiarity with programming and computers is assumed but other than that, not much else is assumed. The authors do an excellent job of explaining some of the fundamental concepts underlying database driven websites. All this is done in simple terms without too much jargon. To top it all off, a tutorial style approach is taken to illustrate how all these concepts come together. The tutorial is on building an online retail site that sells wines. The sample code used in the book can be downloaded from the publisher's website. PHP is a powerful language that is open source and that can be used in lieu of Java and .NET technologies for many web applications that aren't too complex. For most small business owners, this should suffice. I am not too sure about using it in large corporations. This is one of the most popular open source technology along with Linux and MySQL. MySQL is an open source database that can be used instead of SQL Server, Access, or Oracle. Once again, when the database application gets complex, I am not confident of its ability to handle the complexity. This is also excellent for small businesses but not large corporations.There are about 13 chapters and 5 appendices spanning 550 pages starting with an introduction to database applications and the web, continuing with an intro to PHP and MySQL, covering the main concepts behind web technologies and ending with the sample wine store application. The main concepts discussed are querying databases, writing to databases, validations on the server and client, session management, user authentication and security. The appendices handle installation, modeling and designing relational databases, managing sessions in the database tier, etc. Overall, the selection of topics is perfect for Intermediate programmers and the explanations are very detailed yet simple. This is probably one of the reasons this book is so popular. I have thoroughly enjoyed using this book and I am not surprised to see such a high quality book from this publisher. I am not familiar with the authors but I am going to keep an eye open in the future for other books by them. I felt it was a bit pricey for a book of this nature but this is the only one I could find that covered these specific topics so I am not going to complain. Enjoy creating your own database driven website!

