IT programming books related reviews
Title: PHP and MySQL Web Development
Publisher: Sams
Authors: Luke Welling, Laura Thomson
Rating: 5/5
I needed to quickly create an advanced, dynamic database driven website for work.This book was an excellent starting point, taking the reader who knows nothing about PHP to being able to create medium to advanced scripts in a minimum of time.The included advanced tutorials are invaluable.It would be unfair to not mention that it also includes a very good reference on MySQL, from configuring it to using it.If you need to learn PHP/MySQL get this book and a copy of the reference manual from php.netI would give it 6 stars if I could.
Title: Oracle Web Applications: Pl/Sql Developer's Introduction
Publisher:
Authors: Andrew Odewahn
Rating: 4/5
This book came out in 1999, and it's now late 2001 as I write this.This publication is a very well written introduction to the spectrum of tools and approaches for using Oracle databases to generate dynamically created web pages - based on 1999 technology. While Oracle has advanced since then, most of this book - especially the PL/SQL web toolkit sections - is still useful. If you're an Oracle developer who's familiar with SQL and PL/SQL, then this book will get you up to speed very quickly (it's only 220 pages - thin by "computer book" standards) on the detail of how the PL/SQL web toolkit is used to combine database data with HTML. If you're an Oracle developer, but you don't know anything about web architecture or HTML, then you'll get a brief yet effective introduction in here of what you need to know.If you don't know PL/SQL, get Steve Feuerstein's book first called Oracle PL/SQL Programming. Use that to learn PL/SQL. Then, once you're familiar with it, you'll get much, much more out of what's presented in this book.The section about the PL/SQL web toolkit is very useful, even today.The overview of WebDB is dated. Oracle's new name for this tool is "Oracle Portal", and while the underlying architecture is the same, and the features taught here still largely apply, there are new features and a completely different interface on the new tool.The chapter about Oracle Application Server (OAS) is still interesting to read for an overall idea of how web architecture is implemented in Oracle's web server family. But the app server has been updated several times since this book, and has very different screen displays. The basic features are still the same, and the brief review provides helpful insight into where Oracle has been, which isn't too far, fundamentally, from where it is now. Finally, the XML chapter is not bad for quickly getting a great general introduction of XML and it's capabilities, but be aware that Oracle has GREATLY extended it's XML support since the publication of this book. Nevertheless, I still find this chapter extremely interesting in that it shows the intricacies of what it really takes to generate an XML document, while the newer Oracle XML utilities do much of this work automatically. While the new utilities are good to use, this chapter will give you a bit more insight into the utility of XML and a database, along with a fuller understanding of what is happening, so that you can be more flexible in your use of XML.There's nothing of substance in this book that addresses Java or Oracle Forms for web use.So - in summary - it's a little dated for 2001, but still very useful. It's brief and to the point. Very helpful for an Oracle developer who needs to come up to speed quickly on web technologies.
Title: PHP Advanced for the World Wide Web Visual QuickPro Guide
Publisher: Peachpit Press
Authors: Larry Ullman
Rating: 4/5
This is the fourth web site design and/or development book that I have purchased that was published by Peachpit Press. All four books are good books.The "PHP Advanced For The World Wide Web" (written by Larry Ullman) has a lot of good information. All of the sample scripts for the book can be downloaded from the web site.... I have tested about all of the sample scripts and they work good.Also if you have a question the DMC Insights web site has a message board where you can get answers.If you are a beginner like myself it will take longer for you to learn the material in this book. I recommend purchasing the first book on this topic (published by Peachpit Press and also written by Larry Ullman) entitled "PHP For The World Wide Web" which is a visual quick start guide and more of an entry level book and then use the first book as a reference manual.I recommend starting from the beginning of this book and studying each of the chapters. In recommend studying the material and examples as though you were studying for a collegiate level examination. That is the type of study that it will take to learn this programming language.The examples in the book build on themselves so you really need to start at the beginning. Also as you progress through the book you need to go back periodically and review the earlier chapters. The material in the earlier chapters will become more clear to you after you have studied the book for a while.I hope that this review helps.Regards;H. Pete Norris, MAI
Title: MCSE TestMaster Full Version Six Tests: Core & 2 Electives; SQL Server 6.5 & IIS 4.0
Publisher: PC Age, Inc. Rating: 5/5
Better than Transcender at half the price! Transcender has some bells & whistles, but who cares, the questions and tutorials are what count, and these are excellent.
Title: MCSE Test Success: SQL Server 7 Administration
Publisher: Sybex Inc
Authors: Michael Lee, Rick Sawtell
Rating: 4/5
I bought this book based on the reviews submitted here. As already stated it is not sufficient in itself. I complemented the book with the online books where I felt I needed more knowledge. I do not award it 5 stars because there are significant areas missing. So beware. PS. I'm glad to say I passed.
Title: The Practical SQL Handbook: Using Structured Query Language (3rd Edition)
Publisher: Pearson Education
Authors: Judith S. Bowman, Sandra L. Emerson, Marcy Darnovsky
Rating: 5/5
Outstanding book for beginner looking to learn SQL from scratch. Thrown into an SQL job with no experience whatsoever, this book helped me become functional in a very short period of time. Provides sound fundamental concepts which will help lead to more efficient procedures, scripts, web-design, etc.
Title: Professional SQL Server 7.0 Development Using SQL-DMO, SQL-NS & DTS
Publisher: Wrox Press
Authors: Frank Miller, Rachelle Reese, Martin Harwar
Rating: 4/5
I was discouraged from getting this book for a while because of the other reviews on this page, but when I really needed an additional reference for SQL-DMO, I went ahead for whatever I could get from the book. I have read through the portion of the book (The chapters, not the appendices - they are more for reference).
First, the book is not just a rehash of the SQL SBO, nor of the reference on MSDN. It was my frustration with searching through them, getting explanations that did not always offer enough of an example to really clear up the concept in my mind that led me to seek another book. The chapters in this book do lead the reader through examples, and do solidify the concepts I was looking to have solidified such as the practicalities of the object Heirarchy. Once you have this part firmly in mind, then MSDN, and SQL SBO's endless diagrams and cryptic descriptions begin to make more sense.As for the examples being in VB, I program in C++ and Perl. I very, very seldom use VB or any of its variants, but it is so simple that there is no problem whatsoever in translating the examples from the VB in the book to the languages I use. The object model is the same regardless of the language, the languages just have a little different notation in accessing the properties and methods. For example:VBS:Private dSrv
Private dDb
Set dSrv = CreateObject("SQLDMO.SQLServer")
call AddSurvey("MyCompany", "MySurvey", "MyDbName")
Call dSrv.Connect("(local)", "sa", "changed")
Set dDb = CreateObject("SQLDMO.Database")
dDb.N ame = "myDb"
dSrv.Databases.Add(dDb)'set some db options:
private dbOption
set dbOption = dDb.DBOption
dbOption.SelectIntoBulkC opy = 0
dbOption.TruncateLogOnCheckpoint = 0
dbOption.AutoCreateStat = 0
dbOption.AutoShrink = 1
dbOption.AutoUpdateStat = 0MsgBox dDb.ScriptIs this in Perl:use Win32;
use Win32::OLE;my $srv = Win32::OLE->new('SQLDMO.SQLServer');$ srv->Connect('(local)', 'sa', 'changed');
my $db = Win32::OLE->new('SQLDMO.Database');
$ db->{Name} = 'MyDb';
$srv->Databases->Add($db);<br >my $option = $db->DBOption();
$option->{SelectInto BulkCopy} = 0;
$option->{TruncateLogOnCheckpoint} = 0;
$option->{AutoCreateStat} = 0;
$option->{AutoShrink} = 1;
$option->{AutoUpdateStat} = 0;Win32::MsgBox($db->Script());As anyone can see that takes even a few seconds to look at those two scripts for creating a database, the object model is exactly the same. The scripts are doing exactly the same thing. The only difference is in the language syntax, and there is such a direct correlation even there that it is very easy to translate from the examples in the book into the languages I prefer to use. For C++, chapter 12 is dedicated to setting up and creating projects in C++. From there, it is just using the C++ syntax to access the same object heirarchy.In my opinion, the book does what it says it does, and was helpful, and clear in developing a better understanding within me of using SQL-DMO, SQL-NS, and DTS in my development.Steve Howard
Title: SQL Server 2000 Developer's Guide
Publisher: McGraw-Hill Osborne Media
Authors: Michael Otey, Paul Conte
Rating: 5/5
This book really covers SQL Sever 2000 with clear, uncomplicated explanations and useful examples. I have used it as a reference guide to answer questions that have come up, as well as a jumping off point for writing my own applications to SQL Server 2000. I can cut and paste the code from the CD right into my programs.The authors cover many of SQL Server 2000's features including: T-SQL's DDL and DML, stored procedures and triggers, ADO and ASP, XML, SQL-DMO, DTS, security, backup and recovery, and more. Having so much practical information all in one place has sure been a time saver for me.A very well rounded and easy to read book. Definitely a must have!
Title: SQL for Dummies
Publisher: For Dummies
Authors: Allen G. Taylor
Rating: 4/5
The last time I worked with databases, my entire computer (RAM + mass storage) had less than one MEGAbyte of memory. No hard disk, just two 360 kB floppy disk drives and 128K of RAM. I just got saddled with a data-mining project that will process tens of gigabytes of data in a networked environment. My analysis tools can use SQL to access the data. This book was the first thing I insisted on. (Kind of embarassing for a senior person to be seen carrying a thick yellow and black book with the word "DUMMIES" on it ...)This has proven to be an excellent starting point. I know plenty about computers and programming. I vaguely remember the essentials of relational databases (for those who don't, basic information is in the book, it should be enough to get started, even if you are absolutely ignorant!) Taylor packaged enough of the right information that I could read his book over the weekend and dive into the planning stages of our project on Monday sounding like I knew a thing or two. The book charts a course from the most basic elements of databases to modestly complicated database and query materials. The author discusses common pitfalls and useful strategies. This book isn't enough, by itself, to turn somebody into a database wonk, but it's a great starting point.I got a bit annoyed by some of the "cute" material used to make the subject seem less threatening, but that filler doesn't take up too much space and is easily skipped. Also, the book is overly Microsoft centered--the author uses Windows applications as examples and champions Microsofts ODBC. A section about using SQL in a Unix/Linux environment should have been included (access from shell scripts, PERL, etc?). A solid four-star introduction to SQL and database technology in a Microsoft world.(If you'd like to discuss this book or review in more detail, please click on the "about me" link above and drop me some email. Thanks!)
Title: Dreamweaver MX: PHP Web Development
Publisher: Peer Information
Authors: Bruno Mairlot, Gareth Downes-Powell, Tim Green
Rating: 5/5
I've found this book very useful for a PHP beginner as me. I could make the whole website working with Dreamweaver MX 2004, PHP5 and MySQL 4x on my local machine and test it on a webserver using PHP4x and MySQL 3x.
Hints to work with this book:
ON YOUR LOCAL MACHINE:
1. Do not create password for MySQL
2. When creating Database Connection in Dreamweaver, type in the username as root, but do not type the password.
3. For Admin page, if you get an error, use the error handler shown on page 300, 301 to handle it.
ON A WEBSERVER:
Go through pages and specify host, MySQL username and password (don't miss page 254).
I have enjoyed the book very much.
Minh Lam

