|
MYSQL BOOKS
Posted in MySQL (Saturday, July 5, 2008)
Written by Wallace B. McClure and Gregory A. Beamer and IV John J. Croft and J. Ambrose Little and Bill Ryan and Phil Winstanley and David Yack and Jeremy Zongker. By Wrox.
The regular list price is $49.99.
Sells new for $6.91.
There are some available for $6.56.
Read more...
Purchase Information
5 comments about Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, and MySQL.
- I was really looking forward to this book, for both ASP.Net and WinForms development, since I really thought that's what the book was really about. Boy was I surprised. if that was all it had, I'd probably be very happy. However - that was just the tip of the iceberg! It has quite a wide focus, so, in some cases, it was kind of dificult to know where the book is going.
However, The reader is somewhat warned right off the bat, that the book focuses mainly on the new features of ADO.Net 2.0, so prior knowledge of ADO.Net is expected, but I believe there is still a lot of text that covers a lot of the basics - just without a hand-held experience.
For those so inclined, there's quite a bit of information concerning subjects like usinc CLR objects, TSQL Enhancements, Notification Services, Service Broker and Reporting Services, though it's definitely not JUST about SQL Server. There is quite a bit on the popular open source databases like MySQL and PostgreSQL, along with a chapter on Oracle, just for good measure.
Many times, on different forums, I find questions concerning how to create a Database/table/etc, in code. Professional ADO.Net 2 has this plus a whole lot more about SQL Server server-side programming
Going into the book, I knew there were quite a few new features of ADO.Net, but I really had no idea concerning the extent of new features. This book contains 584 pages of great information. Though what I'd consider a bit wordy, at times, I'll definitely keep this book around.
If all you do is ASP.Net web page development, maybe this isn't the book for you - but if you do a lot more and really like 'nuts and bolts', and widening your experience, I think it's a go!
- There are a number of great things about this book, from my perspective. For me, perhaps the best chapter was the one on the custom ADO.NET provider. Even if you do not want to create a custom provider (and honestly, I do not think I will), reading through that chapter helps explain how the various standard interfaces work.
In addition to covering ADO.NET 2.0 proper, the book covers specifically how you can use ADO.NET in very practical ways, interacting with SQL Server, as well as doing server side programming in SQL Server. Unlike one other reviewer, I appreciate the book covering these other areas. While the chapters on topics such as SQL Server server-side programming obviously do not cover all that a dedicated SQL Server book will, it covers most of what you need.
I do understand how the term "Professional" in the title might lead a reader to expect one thing or another, but before I buy a book, I tend to read through it and determine if the publisher's idea of "Professional" matches my expectations.
- I had hoped that working through this book would bring extra insight and new techniques. After all, I have been a database consultant for 15 years and designed, programed and implemented many large solutions.
I found that the book left much unsaid and detailed instructions non existant. I had problems with the download code. It appears to be tied up with VS team system, so if you are a home or small business who is unfamiliar with tem system then you may have problems.
I contacted Wiley Customer Support, but they just told me the code works and provided nothing helpful.
I will not be buying any more Wrox / Wiley books.
- I have 16 years experience as an adjunct instructor at a community college. I have a BS in Engineering and I'm 3 credits away from my Master's in Comp Sci.
I'm taking time from my class prep to write this review...
I have been assigned to teach a Visual Basic programming class with this book. Had I been given the opportunity to read the text beforehand, I would have fought hard to use some other book. The example code is formatted so poorly that I am embarassed to use it in class. Some of the example code in the book doesn't even match what's available for download on the WROX web site. The QC staff at WROX should be reassigned. I've QC'd many programming textbooks myself and I can see that this stinker was rushed to print without enough editing.
Don't be fooled by the title. The majority of the examples are SQL Server-specific. OK, Visual Studio has a SQL Server bent, given that both are Microsoft Products. That's no secret. However, if the title of the book references Oracle and MySQL, then all the examples should also. If a particular paradigm can only be implemented in SQL Server, then the authors have a responsibility to provide work-arounds for the other DBMS's that are listed on the cover of the book. Arrrgh.
Chapter 1 covers the History of Data Access. That doesn't fit with the remainder of the book. Part of chapter 2 covers normalization, also not a good fit with the remainder of the book. The authors even admit that the book is aimed at software developers who have prior knowledge of ADO .Net and SQL Server. That implies prior knowledge of normalization and database design.
Recently I was at the bookstore with my 11 year-old. I was agonizing over which ASP .Net book (both WROX titles) to purchase, so I held up two possibilities and asked her to help. She noted that one cover had 3 author's faces on it and the other had two. She concluded that the book with 3 faces must be better. I couldn't argue with that logic. This book has seven faces on it, but it just doesn't deliver.
- This book has a lot of good information. I found myself skimming forward just a little but there was still lots of good info to make me want to keep reading. I wish there was sometimes more explanation of why the author feels a certain way but all and all this is book worth owning.
Read more...
Posted in MySQL (Saturday, July 5, 2008)
Written by Jono Bacon. By Prentice Hall PTR.
The regular list price is $39.99.
Sells new for $19.83.
There are some available for $16.99.
Read more...
Purchase Information
5 comments about Practical PHP and MySQL(R): Building Eight Dynamic Web Applications (Negus Live Linux Series).
- I would give this -ZERO- stars if I could.
The demos in the book are pretty good. They are simple and basic but they are more than the useless examples you get in most programming books. That is the bait, but the promises made on the cover are not kept. Stay away from this book.
The problem is that this book pretends to offer you the programs to examine, use, modify, and copy. It is a big problem for the simple reason that you must boot from the CD and know quite a bit about Linux to find and get the programs.
When I went to the author's website it is crawling with bugs virus and my browser immediately died and had problem ... from a new install freshly updated WinXP.
This author is a rip-off and a liar as far as I can see. If he was honest he would have a clean web page with a pointer to the programs that did not play games for serious users to load and play with.
DO NOT BUY THIS CRAPPY BOOK! AND THE ATTITUDE OF THE AUTHOR IS BAD SO I WOULD NEVER BUY ANYTHING FROM HIM AGAIN.
- Hello, if anyone has this book and has the ability to get into the CD, I would greatly appreciate it if someone can forward me the example files. My email is advancedgraphics at hotmail dot com.
I booted from the CD, ran through all these loading thigs, then when it's ready to run, tells me some error and from there I'm lost into script hell...
The book is understandable, seen some errors, I wouldn't recomend buying this book if you are a beginner like me looking to learn php.
- I picked this book up from the local libary and was quite excited. 70 pages later and I gave up in disgust. A great concept completely destroyed by terrible editing. The code, tables and diagrams that are provided are absolutely riddled with errors and none of the projects actually work. I guess that's one day of my life I won't get back.
Avoid this book like the plague.
- This book promises to be good. The delivery was very quick and I am looking forward to an exciting study sessions.
As always, it was a Good business.
Thanks a lot for this material
- Wait for the 2nd edition. If the book had gone through a thorough tech editing (type in and run the code!) before going to the presses, this might have been a 4-star book.
If you are the type of person that can learn by just looking at code and getting a broad sense of how it works, then there might still be some useful information in here for you. I learn by doing, which made typing in the buggy examples a frustrating experience. While I also learned some by debugging this book, but that is not the experience I paid for. There is no online errata for this book that I am able to find.
If you just want view code without typing it in, the "Live CD" might be of use to you. The code on the CD is apparently a more debugged version of the code shown in the text of the book. The concept of booting up into Linux on a CD to do your own coding PHP and MySQL is not as useful as the publisher makes it out to be, because there is no way to easily save anything you do there.
I started to do my own tech editing of the book around page 40. Here are examples of some of the types of errors you can expect:
Page 42: Database name incorrectly referred to as "perfectproducts." Should be "productsdb."
Page 43: Database column name incorrectly referred to as "if." Should be "id."
Page 45: Missing steps in instructions for setting up database connection. Reader needs to set up user permissions in phpMyAdmin, and also edit code to include the new user information.
Page 68: Table 4-2 column header should be "BLOG_ID" instead of "CAT_ID."
Page 77-78: The sample code will output invalid HTML unless you move around where it writes out the opening and closing paragraph tags.
Page 81: The sample code will output invalid HTML unless you move around where it writes out the closing UL tag.
Page 99: Missing the required opening and closing PHP tags around the code that includes the footer PHP file.
Page 100: Last paragraph should refer to adding code under the "home" link instead of the "categories" link. Instructions say to add the code inside the PHP block, but the non-bolded text above the PHP block needs to be added as well.
Those were freebies. Prentice Hall, the "world's leading educational publisher" should foot the bill to edit the rest.
Read more...
Posted in MySQL (Saturday, July 5, 2008)
Written by Marc DeLisle. By Packt Publishing.
The regular list price is $19.99.
Sells new for $17.99.
There are some available for $19.50.
Read more...
Purchase Information
1 comments about Creating your MySQL Database: Practical Design Tips and Techniques.
- In a nutshell, this book is pretty worthless. Potential readers would be much better off with the "MySQL Tutorial" book.
Read more...
Posted in MySQL (Saturday, July 5, 2008)
Written by Rob Allen and Nick Lo and Steven Brown. By Manning Publications.
The regular list price is $44.99.
Sells new for $29.69.
Read more...
Purchase Information
No comments about Zend Framework in Action.
Posted in MySQL (Saturday, July 5, 2008)
Written by Rick F. van der Lans. By Addison-Wesley Professional.
The regular list price is $49.99.
Sells new for $38.13.
There are some available for $39.33.
Read more...
Purchase Information
2 comments about SQL for MySQL Developers: A Comprehensive Tutorial and Reference.
- Van der Lans offers an impressively thorough education in MySQL 5. It is remarkable how much capability is offered for free in the open source MySQL. The book can also be used to learn generic SQL from scratch. Some early chapters give a quick recap, that should be understandable to an experienced programmer, who does not know SQL. If this describes you, the biggest adjustment to learning it might be its declarative nature, as opposed to the procedural ethos of most programming languages.
One striking feature of the book is the extensive explanation of SELECT. This is the key statement of SQL, and you need to be facile with it. Nine [sic] chapters are devoted to SELECT. Gives you some idea of both the power and complexity of the command. Rarely do other SQL books allocate so much space to a rendition of SELECT. Often, they teach you the basic modes of using it, and then you are left on your own. (Gee, thanks!) Whereas here, for example, an entire chapter is about the SELECT HAVING clause, and another chapter is on the SELECT LIMIT clause. Across these nine chapters are enough worked examples that you can fruitfully mine.
Later chapters delve into more specialised aspects of SQL. Sure, these are all significant. But maybe the most useful is the idea of stored procedures and functions. Vital to optimising performance.
Lest this very mass of detail prove offputting, keep in mind the "Reference" in the book's title. You don't have to read it all at once. As you go thru it, you should develop an intuition of what can be safely relegated to a later reading, when you have specific need of those topics.
- Over the last 5 years, I would say I've at least read every book available on MySQL and bought my fair share.
This book is by far the best one available on some of the advanced features of MySQL. It's better than even the Bible and Cookbook series on things like stored procedures, even though it spends too much time on the basics. I loved the large text, but wish there had been more meat on stored procedures, triggers and events (which is why I picked it up to begin with). There are insider knowledge gems sprinkled throughout that will definitely add spice to your SQL, so it's worth a look.
I don't know why even in 2007 authors insist on repeating the MySQL documentation,--it's a MASSIVE amount of wasted space, since anyone using this stuff will be familiar with the online documentation and helpful user commentary. There were a few typos, but that's pretty par for the course. The section on PHP, though, was pretty useless and not particularly good code-wise (in my humble opinion).
One day someone will put out a really advanced cookbook, that doesn't waste space explaining super simple things like "select * from table," but until then it's a great resource. If you can get it at a discount, like on a Borders reward coupon (which they give out like candy) grab it. Clearly, the Europeans still have something to teach us about MySQL! :o))
Read more...
Posted in MySQL (Saturday, July 5, 2008)
Written by Cristian Darie and Mihai Bucica. By Apress.
The regular list price is $44.99.
Sells new for $15.40.
There are some available for $9.87.
Read more...
Purchase Information
5 comments about Beginning PHP 5 and MySQL E-Commerce: From Novice to Professional.
- I dont usually spend time writting this stuff, and when i did it, it was not for good reasons. But this time, i'm really really really happy about the material in the book, it not only teaches you about the code, it get depth really depth in how you must implement, think, best practices, and a lot of things that even if you are an experienced programer havent thought about.
If i could give the book 10 stars, i would.
- I have purchased a multitude of books from Amazon over the years. However, I have never written a book review, no matter how bad the book turned out to be. But, there is always a first time. This is one of the worst - if not the worst - tech books I have ever read, and with over 25 years of Engineering and Software development experience I have read a lot of books.
Now I know why Apress doesn't let you look inside their books on the Amazon website before you purchase. If they did there might not be an Apress at all. First, there is nothing "novice" about this book. Second, you had better know how to use Smarty, and I mean use it well. Don't rely on the Smarty website documentation to help and there are not many definitive books on the subject either. I only found one title devoted to Smarty on Amazon and that would cost another 39.99.
I typically like to review books in the local bookstore and take a gander at Amazon "reviews" before purchase. However, I couldn't find the book locally (which should have told me something) and I failed to pay proper attention to the reviews, i.e., take a look at Michael Brand's review. The editorial book review doesn't even mention Smarty which is a major part of this book.
This book reviews at 4.5 stars. From this, I can only assume the large majority of those reviewing the book work at Apress or are kin to the authors. After the first three chapters I was seeing stars. Don't be suckered in to buying this book unless you are thoroughly familiar with Smarty.
So, if your an experienced -not novice- php/mysql programmer and Smarty wizard, and love to read(and debug) code with little useful explanatory info, then by all means buy this book. Oh, did I mention it makes a great coaster for coffee?
JC.
- I've read, and enjoyed, other books by Cristian Darie. This book is no different. This book shows how to use PHP 5 and the Smarty framework to produce an E-Commerce site. The Smarty framework is a good choice for PHP developers seeking to implement a good template. This book fills a gap by being a good introduction to this framework as well.
If you are not familiar with Smarty, the following description is from their web site:
Smarty is a template engine for PHP. More specifically, it facilitates a manageable way to separate application logic and content from its presentation. This is best described in a situation where the application programmer and the template designer play different roles, or in most cases are not the same person.
This book guides you as the author develops an advanced E-Commerce system. Think of something such as Amazon, complete with product reviews, customer and catalog management. Once the user is finished reading the book they are left with working catalog order system that they can modify to suit their needs. Or completely create their own similar system.
The table of contents for the book follows:
Chapter 1: Starting an E-Commerce Site
Chapter 2: Laying Out the Foundations
Chapter 3: Creating the Product Catalog: Part I
Chapter 4: Creating the Product Catalog: Part II
Chapter 5: Searching the Catalog
Chapter 6: Receiving Payments using PayPal
Chapter 7: Catalog Administration
Chapter 8: The Shopping Basket
Chapter 9: Dealing with Customer Orders
Chapter 10: Product Recommendations
Chapter 11: Customer Details
Chapter 12: Implementing the Order Pipline: Part I
Chapter 13: Implementing the Order Pipeline: Part II
Chapter 14: Credit Card Transactions
Chapter 15: Product Reviews
Chapter 16: Connecting to Web Services
- Although I am having A LOT of trouble implementing all the code, this is the only book I have seen that will actually walk you through all the steps. And the author actually does reply to his emails. I would definitely recomend his second edition of this book.
- I've been using this book for the past few business weeks. Yes, weeks.
First and foremost, this book is extremely well written, well cited, and clear. Examples are concise, and it rarely leaves you floundering to understand a topic. The ideas are presented in a logical order, proceed clearly, and generally, consist of helpful hints and instructions.
UNFORTUNATELY, all of the code in this book is pretty much worthless. Every bit of it is outdated, and in the 134 pages of the book that I have suffered through, I have had major problems at every step. From having major issues with integrating PEAR (installation has completely changed since the writing of this book, and the major database functions it uses have changed, and the documentation in the book and on the PEAR website are not clear on this), to having to track down irregular and outdated code, not a single feature has been implemented easily or correctly on the first attempt (even ignoring any errors that I made myself due to my inexperience).
I have wasted hours on this book, thinking that it will eventually get to the point where I'm not running into compatibility issues. This may end up being the case, but taking several business days (2.5 weeks invested in just this book) worth of my time to get through 134 pages (mainly spent debugging and perusing forums to find solutions) is just not worth it.
I will be buying the second edition, and I hope that it fixes these issues.
It's really a shame, because the theory in this book is truly awesome. Implementing it, however, is a nightmare, especially for a beginner.
Read more...
Posted in MySQL (Saturday, July 5, 2008)
Written by Steven Holzner. By McGraw-Hill Osborne Media.
The regular list price is $49.99.
Sells new for $24.77.
There are some available for $20.18.
Read more...
Purchase Information
2 comments about PHP: The Complete Reference.
- As a software developer, I primarily work with the ASP.NET technology and have been learning to apply Ajax to my work. A small segment of my work is with PHP/MySQL. I picked-up this book at Barnes & Noble (my Sunday library and Starbucks experience) and found the subject of Ajax to be very well explained.
I purchased this book solely for the Chapters 12 and 13 coverage of Ajax and have found it to be worth the purchase price alone. I look forward to reading the rest of the book as a refresher for my PHP development.
- This book is okay as a beginning reference. The title may give the impression that it's a book you'll want to keep on your shelf and return to frequently for years to come. That probably won't be the case for most readers who go on to write a lot of PHP, so a better title might have been "Getting Started with PHP", or something like that. The banner on the back of the book, which says "Your One-Stop Guide to Web Development with PHP", is a lot more predictive of the book's contents.
It contains a lot of fluff that fills way more pages than are justified for the amount of information given, such as examples built-up in stages, leading to a lot of needlessly redundant example code. This might make sense for complex examples, but the examples in this book are all very simple, so the extra use of paper is wasteful.
Personally, I don't like the author's tendency to follow his own explanations with expressions like "Not bad!", "Nice!", and "Pretty good!". I appreciate when authors use a conversational tone to some extent (Scott Meyers is the best at this, I think), but doing this constantly throughout the book goes too far for my taste. Others might enjoy this style of writing though.
I would say this book seems to be targeted toward readers who are absolutely new to programming. If you're coming from any kind of programming background at all, or like to be challenged, then you might not be very satisfied with this book. One good thing is that it's so simple and the examples take up so much space, you can read the whole thing in just a few hours.
I've also noticed quite a few typos, even in the example code (e.g. "close" where they meant "clone"), but I don't see an erratum posted on the McGraw-Hill website yet. I'm sure that's because the book was published only recently. The source code is all there though, as advertised. Still, it would have been nice if they'd done a better job of editing the text.
Maybe the overall nature of this book is consistent with "The Complete Reference" series by McGraw-Hill. This was the first title I'd read in that series, so I had no certain expectations. In the future, I'll know better what to expect from "The Complete Reference" books.
Read more...
Posted in MySQL (Saturday, July 5, 2008)
Written by Chris Lea and Mike Buzzard and Dilip Thomas and Jessey White-Cinis. By Apress.
The regular list price is $49.99.
Sells new for $4.00.
There are some available for $2.54.
Read more...
Purchase Information
5 comments about PHP MySQL Website Programming: Problem - Design - Solution.
- This is the most rock solid computer science programming text that i have read in the last decade.Period.No one should miss out on this buy.
- OK Guys,
I recognized that every review is always so clean (no spelling mistakes, no grammar errors). Sometimes I think the Team itself writes some of them to impress readers. ;-) I can agree that this Book is not to bad, but if somebody says it's the best way to learn PHP then he's not completely right. There is no way that you can see thro the whole php-code without having read a "PHP-only" book before. I don't say that every little step has to be explained (the book would be 2000 and more pages big), but i couldn't find that this book is not made for beginners anywhere on the book-explanation page. Nice book, but please when you are a beginner, try a more explaining book first. Then go and buy this one. Thank you
- (This review is of the Wrox Press 2002 edition)
This book gives you a thorough course in building a PHP-MySQL website, working up a complete system in stages. The book contains lots of useful code and techniques that can be used in your own websites. As a previous reviewer said, it is not for complete beginners in PHP/MySQL, but in combination with a good fast intro to these topics (I used SAMS "Teach Yourself PHP, MySQL and Apache in 24 Hours"), I reckon this book should be all you need to get your cool interactive database-driven site out onto the web. And when I contacted the authors to find the download code (which is available from Apress now that Wrox no longer publish it), they were extremely helpful. So go on - the software cost you nothing after all: why not splash out a few pennies on this excellent book?
- I know all of the other reviews are glowing, but I was actully disappointed by this book. While it is very thorough, I found the structure of the book to be haphazard and unintuitive. There are a lot of occurances of "but first, lets go back a bit," a sure sign of poor writing. While trying to keep to the problem-design-solution framework, the authors often introduced ideas in the problem phase, but never clearly addressed them in the design and solution phase -- often vaguely tying it all together with a statement like "and we took care of this problem as well" without really referencing it.
There is a great deal of information in this book, but I found it very difficult to extract coherently. And saying "but its not for beginners" is no excuse for poor writing.
- There is absolutely no PHP or My-Sql teaching in this book. If your looking to see how a professional group of programmers use functions and how they outline their sites then this book is for you. BUT if you're looking for a book to learn any PHP My-Sql programming, don't buy this book. But if you do buy it, buy it used... It's not worth the new book price.
Read more...
Posted in MySQL (Saturday, July 5, 2008)
Written by Michael K. Glass and Yann Le Scouarnec and Elizabeth Naramore and Gary Mailer and Jeremy Stolz and Jason Gerner. By Wrox.
The regular list price is $39.99.
Sells new for $17.45.
There are some available for $9.89.
Read more...
Purchase Information
5 comments about Beginning PHP, Apache, MySQL Web Development.
- Worst book of all time, sorry guys and gals but whoever wrote and edited this book should buy a book themselves "Learn to Write and Edit by DUMMIES". To many typo's and script errors which did not work!
Actually I would give the book a 5 star rating if they changed the name to Trouble Shooting Script Errors, Test Your Skills!
- I used this book as a tutorial on the subject with graduate students who had only basic programming experience and we all agreed that it was a great way to get started with database-backed PHP work.
- This book is really quite good. It's very interesting & definitely very readable. When I read it, I got straight down to business, so to speak. It gives very practical examples starting you off with making a movie review site which was very interesting! All in all, an excellent book to give you a working knowledge of PHP & MySQL.
That said, there are some shortcomings.
-Significant amount of typos in the code
-Some minor parts of the code requires redoing (which I found out through a forum dedicated for the book)
-For those of you with absolutely no experience in programming, you might find some concepts aren't covered enough in detail
As I said before, overall, great book.
-ive 1 star for the shortcomings.
Richard
- The authors are great PHP programmers, I have no doubt, but terrible writers. I do not recommend this book. Like most bad technical writers, they make a big production about trivial concepts, then gloss over difficult concepts without explaining them in detail.
- Well its been on my shelf for a couple years and how I've opened it. I am on page 165 and back to Amazon to search for a book to replace it.
The book is outdated. The forum for the book is not well visited. The support code for the book is failing images and some files. The code is written inconsistantly, different authors, and there is no mention of this or proper coding examples. Variables are created on the fly and creates some error messages with uptodate PHP. The explanations of certain things requires several readings sometimes to fill in blanks that a beginner should have explained. The use of CSS is not even mentioned so far and the html does not meet Xhtml standards. We must not forget the book was copyrighted in 2004.
I have purchased "Beginning PHP and MySQL 5" by Jason Gilmore and it seems to be a resonable book but leans more towards a reference text. The search continues...
Namaste,
Kevin Tough
Read more...
Posted in MySQL (Saturday, July 5, 2008)
Written by Chad Russell and Jon Stephens. By Apress.
The regular list price is $44.99.
Sells new for $13.91.
There are some available for $13.91.
Read more...
Purchase Information
5 comments about Beginning MySQL Database Design and Optimization: From Novice to Professional.
- I was hoping that there would be more about designing databases. Though I was pleasantly surprised at the solid introduction to MySQL that the book gives. In fact it spends the first two thirds of the book on the basics, before getting into optimization and finally programming.
The design aspect of the book is in the third chapter, which is one of the books best. There is some good high level material on the fundamentals of schema design, and then material on relation mapping, and then into it's implementation in MySQL.
There is a lot to like in this book. And I like the fact that someone is finally giving some attention to MySQL, which, if it's not the most advanced database in the world, is probably the most ubiquitous. This is a fine book for anyone who works with MySQL.
- If you already know the basics of MySQL, then this book can be a nifty boost to your productivity. The authors plow straight into giving good tips for better table design. For example, the first chapter covers MySQL basics. But it furnishes very understandable advice. Like never using spaces in identifier names. While MySQL permits this, it greatly increases chances of logic errors.
Later in the book are far more complicated tips. Crucially, on how to optimise complex queries. While SQL notation is standard across vendors, each database has different ways to best phrase queries. So since you have committed to using MySQL, it helps to know what are best here.
The authors also instruct in how to hook up to external languages like PHP, Perl and Python. (What is it about all these languages that start with P?) Each has its adherents and is quite popular. So they try to give coverage of the combinations with MySQL.
- The first three chapters of this book deal with the basics of MySQL including basic concepts, column and table types, keys, indexes, and normalization. The authors have written an excellent introduction to MySQL that provides all the core information you need to start using it right away. The chapter on finding the bottlenecks is one of the best sections in the book and details some of the finer points to be considered when creating your database. On the other hand, the part on optimizing queries is excellent for the beginning MySQL student (which is the target audience for this book) but not as good as it could be for the more experienced MySQL user. Perhaps I am just more sensitive to this area because of all the badly done queries I have had to deal with before. A good understanding of just this part can make a tremendous difference in optimization. If you are new to SQL queries the authors have done a great job of explaining why this is important and how to understand it when a query takes under a minute to run and then after a small change takes twenty. The last section covers accessing the MySQL database via other programming languages such as PHP. Beginning MySQL Database Design and Optimization is a recommended read for its target audience - the beginning MySQL programmer.
- As a beginner to MySQL I bought this book to gain an insight into the how's and why's of using MySQL. Overall having read the book from cover to cover ( a first for me as far as computer books go ) I can thoroughly recommend this book to anyone new to using MySQL. The layout is clear, the text easily readable, not too techie at first but still a great deal of examples for you to get up and running.
The writing style is easy going but not preaching and all topics are treated in an easy to grasp manner.
The only down side is that it doesn't cover programming MySQL using Visual Basic although several other languages are covered well.
Overall a great book for the newbie and intermediate user.
- As a working professional database developer/DBA, I should have noticed that every other review about this book is at least three years old, most almost four. This book was written to be used with MySQL V4.0, with look-aheads to 4.1 and 5.0. Version 5.0 has been released for almost two years now, and V6 is on the near horizon. A lot has changed in terms of optimization and feature sets. I sincerely hope that the authors will consider updating this work so that it is more current in terms of tuning and features. If you are new to MySQL, use the book as a basis for solid SQL and design principles; if you are more experienced, perhaps just reading and studying the 5.1 and 6.0 docs from MySQL AB would serve you better.
Lee Parmenter, CMA
Read more...
|
|
|
Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, and MySQL
Practical PHP and MySQL(R): Building Eight Dynamic Web Applications (Negus Live Linux Series)
Creating your MySQL Database: Practical Design Tips and Techniques
Zend Framework in Action
SQL for MySQL Developers: A Comprehensive Tutorial and Reference
Beginning PHP 5 and MySQL E-Commerce: From Novice to Professional
PHP: The Complete Reference
PHP MySQL Website Programming: Problem - Design - Solution
Beginning PHP, Apache, MySQL Web Development
Beginning MySQL Database Design and Optimization: From Novice to Professional
|