View Larger Image	Michael Kruckenberg, Jay Pipes Apress, Paperback, Published July 2005, 734 pages, ISBN 159059505X
	List Price: $49.99 Our Price: $30.50 You Save: $19.49 (39% Off)
	Availability: Out-Of-Stock

Write a Review and tell the world about this title!

People who purchase this book frequently purchase:

• The Definitive Guide to MySQL 5, 3rd Edition; Michael Kofler, $30.50, 39% Off!
• MySQL, 3rd Edition; Paul DuBois, $31.95, 36% Off!
• High Performance MySQL: Optimization, Backups, Replication & Load Balancing; Jeremy Zawodny, et al, $24.50, 39% Off!
• MySQL 5.0 Certification Study Guide; Paul DuBois, et al, $37.95, 37% Off!

• Databases : MySQL
• Other Topics : Open Source

• Apress

This is one of the first books to cover MySQL 5 in depth. It foregoes the usual reiteration of basics that you'll find in other books, instead concentrating on MySQL's advanced applications in enterprise environments. Further, this book doubles as a quick reference guide for configuration directives, commands, and features.

About the Author

Michael Kruckenberg is a senior programmer at Tufts University, working on the Apache/Perl/MySQL-driven Tufts University Sciences Knowledgebase (TUSK), a content repository for faculty and students. He has worked with web technologies since 1994, primarily in open source. He has a passion for exploring new technologies and is awed by the power and progress of the open source community.

Jay Pipes has 11 years' experience architecting and building a variety of applications on both Microsoft and various open source platforms. Following a stint as a senior programmer for RadioShack, Jay has spent the last three years running his own consulting service, where he devotes his time to writing and customizing web applications.

Aug 28, 2006     Frank Stepanski from USA
Best book to learn Advanced MYSQL
For people like me who have a good understanding of MYSQL, the next logical step would be this book. I already know about stored procedures, transactions and the basics of triggers, but I want to learn more about these topics in more real-world scenarios in how to develop larger, enterprise-wide applications. Also I want to know more about other advanced topics that I may not even know to think about. If this sounds like you as well, then read on

The author starts in with reviewing how business requirements and the software development cycle can be part of database development. This a great chapter for people like me who would like to learn how different approaches are taken from different IT perspectives in a team environment (business analysts, application developers, and project managers) This chapter gives you a good understanding of how the other side thinks.

The next chapter focuses on the importance of proper indexing and strategies as pertaining to data storage. Because once your databases reach to the multiple gigabits of storage space, you need to very focused on how long each request takes. A few seconds here and there begin to add up and can cause serious issues if not taken into consideration early in your database design. Like me who only deals with small to an occasional medium-size database I never really had to think about this before.

The next chapter focuses on transaction processing in MYSQL which is one of the more difficult concepts for many and I am in the process now of reading it. I really like the authors explanations and examples. Each point is explained thoroughly and in an easy to read manner.

The rest of the book goes into more advanced topics (system architecture, benchmarking and profiling, security, replication and clustering) as well as giving more detail and explanation to topics that may only be briefly covered in other MYSQL books (stored procedures, functions, and views).

If you already know the basics of MYSQL and want to really advance your knowledge with real-world scenarios, this is the book for you.

Forgot your password? FAQs Shipping Options Returns Your Orders Your Account