IT programming books related reviews
Title: Ocp: Oracle8I Dba SQL and Pl/SQL Study Guide : Exam 1Z0-001 (OCP Study Guide)
Publisher: Sybex Inc
Authors: Chip Dawes, Biju Thomas
Rating: 5/5
This book is really good for the exam preparation. The practice tests are thorough and complete. I would recommend keeping the Complete Reference book handy when preparing. I just took the exam and scored high. This book addresses all topics in the exam.
Title: Beginning SQL Server 2000 for Visual Basic Developers
Publisher: Peer Information Inc.
Authors: Thearon Willis
Rating: 5/5
It's very good Books with good Price and (Wrox Press)
Title: Apache: The Definitive Guide (3rd Edition)
Publisher: O'Reilly
Authors: Ben Laurie, Peter Laurie
Rating: 4/5
This is a fairly comprehensive, 600-page guide to the Apache web server software. The book begins with an overview of what a web server and browser clients do, how they work, and planning/installing Apache. The book covers versions 1.3.x and 2.0.x, and the differences between them. After installation, the next few chapters explain the initial configuration required to get a working webserver, including the various directives blocks, access control, and setting up virtual hosts.
Chapter 5 discusses how to implement authentication, passwords, and more on access control, such as using .htaccess files. Following chapters describe how to change settings for various web filetypes, indexing, imagemaps, and redirection of web page requests. Chapters 9 and 10 explain using a proxy, and the multitude of logging and status options which can be configured.
One of the longer (and important) chapters, Chapter 11, goes into excellent detail about the security aspects of running a webserver. It includes discussion and examples on signatures, certificates, using SSL, and firewalls. General security precautions, real life scenarios, and even potential legal issues are addressed.
The next section goes over building and administering a large website, and the issues associated with that. Also there is a chapter on adding web applications to your site to allow flexible user interaction, such as forms submission. There are then several chapters regarding add-ons and extensions to get even more from the webserver. These include PHP, CGI, Perl, mod_perl, XML, and Cocoon. There are numerous examples of coding provided, although most of them are somewhat basic in nature. One subject that I thought should have been addressed more was integrating the webserver with a database (such as MySQL), as this is a very common requirement.
The last two chapters go over the Apache Application Programming Interface (API), and how to write Modules for Apache. This may be useful to more serious developers, but is probably too technical and difficult for the average casual user. The book closes with a good Index and there is also a very handy foldout inside the back cover which contains quick-reference data for the most commonly used configurations and commands.
Overall this book seems to "cover all the bases". It was useful to me as a beginner to set up a testing webserver, and yet has extra details and information for those more advanced webmasters. The quick reference section especially, should be very useful to experienced Apache users. I would highly recommend the book for anyone wanting to start or improve their knowledge in running the Apache webserver.
Title: PHP Bible, 2nd Edition
Publisher: Wiley
Authors: Tim Converse, Joyce Park
Rating: 5/5
this is a great PHP book for beginner since the codes is very clear and its easy to read. besides, there has explanation of the codes so that I know what is going on. However, when I have questions, the author will help me through the E-mail, She helps me alot and I can work better for the PHP. Really thanks for her help.
Title: Sams Teach Yourself SQL in 10 Minutes, Third Edition
Publisher: Sams
Authors: Ben Forta
Rating: 3/5
This book is clearly aimed at the beginning SQL programmer with little or no knowledge of relational databases. It's a good intro that will quickly get the reader up to speed at writing some very simple queries and updates on an existing database.However, in working with other programmers, I've learned that it's true about a little knowledge being a dangerous thing. If your only knowledge of SQL and relational databases comes from this book, you're in danger of missing out on some very basic information, such as how to normalize a database or perform an outer join.If you learn SQL from this book, you'll quickly want to get another book on SQL that's more complete to fill you in on this missing critical information. Unless for some reason you need to start programming in SQL as soon as possible (in other words, before you understand what you're doing), just skip this book and buy just the more complete book.
Title: Microsoft SQL Server 2000 Bible with CD-ROM
Publisher: Wiley
Authors: Paul Nielsen
Rating: 5/5
Used the Best Practices within the work environment. Great to have a guideline from which to work from. Most books say you can do 6 of one half a dozen of another, but not recommend the best approach. I like that the author goes out on a limb to make these "Best Practices".
Title:
Publisher: Rating: 5/5
I bought this book as a complete Oracle novice, transitioning from Microsoft T-SQL to PL/SQL. I was worried about the transition being difficult until I read this book.It is one of those very rare books that presents advanced concepts in a context understandable by users of all experience levels. The author often throws in tips about Oracle PL/SQL quirks to watch out for, as well as some very applicable information about how Oracle works internally.I've since become more comfortable with PL/SQL, and the book also serves as a great reference. I highly encourage you to read this book straight through.I recommend this well-written book to anybody wanting to learn PL/SQL, as well as anyone needing a great reference.
Title: SQL Server 2000 Stored Procedure Programming
Publisher: Osborne/McGraw-Hill
Authors: Dejan Sunderic, Tom Woodhead
Rating: 5/5
Sunderic and Woodhead have written a gem of a book that can earn on place on almost every SQL Server 2000 developer's bookshelf, if not desk. Whether you are an experienced developer new to SQL Server, or an old hand upgrading to 2000, SQL Server 2000 Stored Procedure Programming will introduce you to the features you need to know about. The writing style is clear and easy to read, and the explanations clear, concise and comprehensive.The book starts with 3 chapters on the basics of SQL Server 2000. While not strictly necessary in a book aimed at developers merely upgrading to SQL Server 2000, it does ensure that the book is accessible to a broad range of developers. I believe any developer with a year or two of experience with SQL can pick up this book and get full value from it. However, even experienced developers should read these chapters; some of SQL Server 2000's new features are first explained here.Then we progress steadily into more detail of the SQL Server 2000 environment. The role of stored procedures in a scalable, high-volume environment is outlined along with an explanation of the tools available for designing, building and maintaining them. The TSQL language is outlined and the proper roles of batches, scripts and transactions is detailed. Throughout these chapters the new features of SQL Server 2000 are described, and their effect on recommended practices provided. Professional habits of error handling, debugging, and source-code management are described. Through a full and detailed understanding of the parts, we prepare to understand the whole. The real meat of the book is chapters 9 through 11. Almost a third of the text is here, discussing Stored Procedures, Triggers, and User-Defined Functions; Locking Strategies, Dynamic Queries, Nested Stored Procedures, and Use of Identity Values; COM and Web Interfacing, Job Administration, Email, Database Deployment, and Security; all of these and more are discussed in sufficient detail to provide a good grounding in their capabilities and limitations. Throughout these chapters, as for the entire book, the emphasis remains on professional practices and usages that demonstrate how to write "code for the ages". Code that will scale well; code that is easy to read, diagnose, and repair when problems arise.The book concludes with an excellent chapter on XML support in SQL Server 2000. It starts with a summary of XML, DFDs and Schemas, and Style Sheets, sufficient to allow a reader new to XML at least follow along with the discussion. Then it goes into details of why and how to receive recordsets from SQL Server 200 in XML, so as to facilitate publication to The Web or an intranet. The ease with which customization, and translation into HTML, can be accomplished is readily apparent from the authors' explanation. Any developers new to XML, who desires to easily publish database content, will find this chapter an invaluable introduction.A consistent thread through the book is "Professional Development". The examples, with occasional exceptions, are clearly adapted from real programs. The authors not only explain proper techniques for trapping, throwing, and reporting errors; they steadily lead by example. Developers in any scripting language, who think that consistent error checking is tedious or unnecessary, would do well to heed the authors' example.The book is not without flaws; two handfuls of minor typos could have been caught before printing. The most annoying, however, is Osborne's insistence on setting the code examples in a large typeface, double-spaced. While from their standpoint it bulks up the book a bit, it is most irritating for readers when a code sample stretches over several pages unnecessarily. For the longest examples, it almost makes them unreadable on paper. Fortunately, they are available online for more comfortable study. SMARTEN-UP OSBORNE!In Chapter 8, "Developing Professional Habits", Sunderic reveals his likely 'project', rather than 'product', orientation. I disagree on his dismissal of "pinning" in Visual Source Safe, because I believe it is a better way to manage configuration in a product-oriented environment. But the issue is peripheral to the book, and probably moot for those readers working in a project-oriented environment.One particularly nice feature is the use of boldface in the examples to highlight the point being illustrated. In lengthy examples, one can immediately pinpoint the code being discussed, and then expand one's focus to the surrounding code. It significantly improves the readability of the lengthy examples. Good Work.In conclusion, this book was a most enjoyable read that I expect to keep by my desk for quite some time.
Title: Instant SQL Programming
Publisher: Wrox Press
Authors: Joe Celko
Rating: 1/5
The book starts with installation notes telling reader that instead of using password such and such and id such, as it is described in the software's help, you rathre have to use password "sql" and password "dba". I tried to enter "sql" and "dba" into the password-asking dialog box, and it did not work. Then I realized that it is password "sql" and USERID "dba", and not only it is a misprint, they are listed in a reverse order: first you enter "dba", and second - "sql". That's on the very first page. The page 5 states, that supplied version of Watcom SQL engine will not allow to execute commands CREATE, ALTER, DROP, GRANT or REVOKE. That makes impossible to practice anything you read up to the chapter 5. However, in chapter 6 on p. 162 author offers you to execute command ALTER TABLE, and if you already forgot about page 5, that's a lot of frustration. At this time it helps to return to page 8: "The code in this book has been extensively tested ... so if you encounter an error message ... please thoroughly check that you've typed the code in correctly ... if you don't type in all of the examples, then you may encounter problems later with certain structures or features which haven't been created".
Title: OCP Introduction to Oracle9i: SQL Exam Guide
Publisher: McGraw-Hill Osborne Media
Authors: Jason Couchman
Rating: 2/5
The book is plentiful in erros, to an extent that eventually you feel you need to try every stated fact to be absolutely sure it isn't an error. Book also does not cover iSql*Plus, an area tested in 1Z0-007. Apart from these lapses, I did manage to pass the exam well by using the book.

