IT programming books related reviews
Product: Book Paperback
Title: Oracle High-Performance SQL Tuning
Publisher: McGraw-Hill Osborne Media
Authors: Donald K. Burleson
Rating: 5/5
Title: Oracle High-Performance SQL Tuning
Publisher: McGraw-Hill Osborne Media
Authors: Donald K. Burleson
Rating: 5/5
After having tuned our server, network, and database it was clear that the remaining slow performance was due to the SQL.
This led me to the purchase of this book which has not disapointed. This book goes into great detail about how sql statements effect database performance and how to correct it.
After just the first few chapters, I was able to quickly find 'hot' sql statements and see how they were causing bad performance due to full table scans, merge joins, slow index scans, hints, built in functions, sorting etc. This book gives a good explanation to the various table / index access methods and thus improved my ability to look at an explain plan and quickly see problem areas. With this book I have better understanding of the options to correct them without messing with the sql code. Infact, most all of these are correctable without changing the sql code - my favorite part.
There is of course a lot written on tuning to the code that can make great strides in performance as well, but as a dba and not a developer, I was more focused on things I could do to improve performance without changing the code.The scrips with the book are especially good - pull sql out of the library cache on the fly, or out of statspack tables for hisorical analysis - and get reports on full table scans, various index scan reports, etc. These alone make the usefulness of this book fast and easy - worth it.In short, I recomend this book to anyone wanting a better understanding of how sql code is affecting your DB performance as well as options to correct it. This is good if you have applications where you can't change the code (or just don't want to) but see improvements in performance need be made.
Product: Book Paperback
Title: Oracle PL/SQL Programming, Third Edition
Publisher: O'Reilly
Authors: Steven Feuerstein
Rating: 1/5
Title: Oracle PL/SQL Programming, Third Edition
Publisher: O'Reilly
Authors: Steven Feuerstein
Rating: 1/5
O'Reilly publishes good reference books. I always look for one of their books first when I am looking for a book in a given subject area. No one book in their Oracle series has it all, though. Each book covers it's subject area in depth...just make sure you get the right book! If you like the "Whatever For Dummies" kind of books, then O'Reilly books aren't for you. My only knock is that there are more books in the Oracle series than is really necessary...marketing at it's worst! Some of the seperate PL/SQL related books should have been combined into one volume.
Product: Book Paperback
Title: MySQL and PHP From Scratch
Publisher: Que
Authors: Wade Maxfield
Rating: 1/5
Title: MySQL and PHP From Scratch
Publisher: Que
Authors: Wade Maxfield
Rating: 1/5
I bought this book hoping to learn PHP and MySQL from scratch....that didn't happen.This is not a tutorial, unless you want to set up a web based e-mail client that is.I do use this book as a syntax reference quite often but I could have printed that out from the web.Save your money.
Product: Book Paperback
Title: The Comprehensive Guide to the JDBC SQL API: Develop High-Powered Database Solutions for Your Site
Publisher: Ventana Communications Group
Authors: Daniel I. Joshi, Rodney Runolfson, Ramesh Chandak
Rating: 2/5
Title: The Comprehensive Guide to the JDBC SQL API: Develop High-Powered Database Solutions for Your Site
Publisher: Ventana Communications Group
Authors: Daniel I. Joshi, Rodney Runolfson, Ramesh Chandak
Rating: 2/5
The book actually covers how to program
java in the first five chapters. Only
the last one/third covers jdbc. Wait
for a better selection.
Product: Book Hardcover
Title: Advanced ANSI SQL Data Modeling and Structure Processing
Publisher: Artech House Publishers
Authors: Michael M. David
Rating: 4/5
Title: Advanced ANSI SQL Data Modeling and Structure Processing
Publisher: Artech House Publishers
Authors: Michael M. David
Rating: 4/5
I got a chance to read this book from an library in atlanta, and guess what? The next week I went and bought this book. Has a very systematic approach, with good diagrams.A must for all serious data modellers and SQL programmers
Product: Book Paperback
Title: SQL Server 7 Data Warehousing
Publisher: Osborne Publishing
Authors: Michael J. Corey, Michael Abbey, Ian Abramson, Larry Barnes, Benjamin Taub, Rajan Venkitachalam
Rating: 3/5
Title: SQL Server 7 Data Warehousing
Publisher: Osborne Publishing
Authors: Michael J. Corey, Michael Abbey, Ian Abramson, Larry Barnes, Benjamin Taub, Rajan Venkitachalam
Rating: 3/5
I found the book to be well written. Its a good starting point for learning about DW. I would have liked to see some additional examples on the snowflake schema and some more details of performance issues.
Product: Book Paperback
Title: SQL Server DTS
Publisher: Sams
Authors: Jim Samuelson, M. Santos, S. Miller, S. Hughes, B. Sullivan
Rating: 2/5
Title: SQL Server DTS
Publisher: Sams
Authors: Jim Samuelson, M. Santos, S. Miller, S. Hughes, B. Sullivan
Rating: 2/5
This one is strictly for amateurs. Perhaps the last section on customized Visual Basic programming is better. The first 4/5 ths of the book are Very Superficial. No details at all. I cannot believe a team of "high-powered Sql Server experts" came up with this cotton candy. Okay for an introduction if nothing else.
Product: Book Paperback
Title: Mastering PHP 4.1 with CDROM
Publisher: Sybex
Authors: Jeremy Allen, Charles Hornberger
Rating: 5/5
Title: Mastering PHP 4.1 with CDROM
Publisher: Sybex
Authors: Jeremy Allen, Charles Hornberger
Rating: 5/5
This is a review of two books. I'm going to tell you why I bought Mastering PHP 4.1, and why I did not buy PHP Bible, 2nd edition.First, I have the PHP Bible 1st edition, and a bunch of other PHP books. But they're all outdated now. One thing that has changed dramatically in the PHP language is the use of forms. PHP used to turn a form field named "comment" into a variable called $comment. But then for a while, $HTTP_POST_VARS['comment'] was preferred. And now $_POST['comment'] is the best way to get that form field (I think, I'm not even sure, it has changed so much).So I go looking for books that can really walk me through all these changes, and teach me the newest, best way to handle forms. PHP Bible mentions $_POST, and if that's all you're looking for -- the newest additions to the language -- then the Bible is worth considering. It's the most current. But PHP Bible really skimmed over forms. It doesn't even have "forms" in the table of contents (well, it does mention processing GET and POST input, all grouped in Chapter 9, "Passing Information Between Pages"). But that chapter is doing so many other things, forms get shortchanged.So I look at Mastering PHP 4.1, and right in the table of contents is a chapter on forms. I go through the chapter, and it's really good, even mentioning all the new variables for forms. The weak spot is that some of their code examples still rely on "register globals" -- but then they followup with a section on why to keep "register globals" off and they show an example of how to rewrite one of the scripts. That's pretty close to exactly what I wanted: I know the old way but want to learn the new stuff; they showed the old way, then they showed the new stuff.But there's more, and this is what solidified my choice. I tried looking up how to handle file uploads, either by PUT or POST. I looked in the index of the PHP Bible for $HTTP_POST_FILES, looked under "forms" for anything close, looked under "files" for anything close, looked for the "is_uploaded_file" function. Nothing. I skimmed Chapter 9, and did find mention of this, but pretty minimal. Then I looked to Mastering PHP 4.1. In the index under "forms" I see "uploading files" and turn to a page that has a nice walkthough with code. It also has a half-page discussion of some things you can do to secure the PHP code that handles file-uploading. While I'm reading this, I realize that any place there is some HTML in an example, it's actually XHTML compliant. Nice. I decide to buy Mastering PHP 4.1. I give PHP Bible 3 stars because a lot of the good stuff from the 1st edition is still there, and if you don't have specific needs, it's an OK book to use to learn PHP programming. But I give Mastering PHP 4.1 5 stars, even though it's a few months older, because it has a lot of the new info in a well-laid out format with a good index, good Table of Contents, and more well-developed content.
Product: Book Paperback
Title: The Practical SQL Handbook: Using SQL Variants (4th Edition)
Publisher: Addison-Wesley Professional
Authors: Judith S. Bowman, Sandra L. Emerson, Marcy Darnovsky
Rating: 5/5
Title: The Practical SQL Handbook: Using SQL Variants (4th Edition)
Publisher: Addison-Wesley Professional
Authors: Judith S. Bowman, Sandra L. Emerson, Marcy Darnovsky
Rating: 5/5
Smart, well reasoned, and covered what I needed.
Excellent book, I development multimedia software, and use SQL, for my programs, easy to read, form mystery to mastery!this book is my head book!
Product: Book Paperback
Title: Programacion PHP: Manuales Users, en Espanol / Spanish (Manuales Users)
Publisher: M P Ediciones S.A.
Authors: Martin Ramos Monso
Rating: 5/5
Title: Programacion PHP: Manuales Users, en Espanol / Spanish (Manuales Users)
Publisher: M P Ediciones S.A.
Authors: Martin Ramos Monso
Rating: 5/5
A pesar de que yo ya programaba con PHP antes, decid? comprar el libro como 'biblia' de consulta, y realmente me sirvi?. Pude solucionar algunos conflictos con mi p?gina web (un foro armado en PHP) muy rapidamente, que de otra manera me hubiera tardado varios d?as en detectar el problema.
Tambi?n me parece ?til como gu?a de aprendizaje, tiene la mayor parte de las funciones del lenguaje incluidas, y no ser?a necesario comprar otros manuales para completarlo.
