MySQL books

From Wikipedia, the free encyclopedia


Below is an alphabetical list of books on the database software, MySQL. This is not a complete list and many more books need to be included. However, this is a start.


Beginning MySQL Database Design and Optimization: From Novice to Professional

  • Authors: Jon Stephens & Chad Russell
  • Publisher: Apress
  • Published: 2004
  • ISBN: 1-59059-332-4
  • Pages: 520

"Beginning MySQL Database Design and Optimization shows you how to identify, overcome, and avoid gross inefficiencies. It demonstrates how to maximize the many data manipulation features that MySQL includes. This book explains how to include tests and branches in your queries, how to normalize your database, and how to issue concurrent queries to boost performance, among many other design and optimization topics. You'll also learn about some features new to MySQL 4.1 and 5.0 like subqueries, stored procedures, and views, all of which will help you build even more efficient applications." -publisher description


Build Your Own Database Driven Website Using PHP and MySQL, Third Edition

  • Author: Kevin Yank
  • Publisher: SitePoint
  • Published: 2004
  • ISBN: 0-9752402-1-8
  • Pages: 373

"A practical guide for first-time users of PHP & MySQL that teaches readers by creating a fully working Content Management System, Shopping Cart and other real-world applications. This bestseller has been updated to reflect best practice web development using PHP 5 and MySQL 4. The third edition also includes a bonus chapter on structured PHP Programming." -publisher description


The Definitive Guide to MySQL 5, Third Edition

  • Author: Michael Kofler
  • Publisher: Apress
  • Published: 2005
  • ISBN: 1-59059-535-1
  • Pages: 784

"The Definitive Guide to MySQL 5, Third Edition, is the newest revision of Michael Kofler’s popular book. Updated to reflect changes in MySQL version 5, this book will expose you to MySQL’s impressive array of new features: views, stored procedures, triggers, and spatial data types. Whether you’re a novice or intermediate user, you will benefit from extensive coverage of core MySQL features like user administration, basic and advanced querying, and security." -publisher description



Expert MySQL

  • Author: Dr. Charles A. Bell
  • Publisher: Apress
  • Published: 2002
  • ISBN: 1-59059-741-9
  • Pages: 525

"Expert MySQL is the first book to show you how to wield maximum control over this powerful open source database. You’ll learn how to create your own custom storage handlers, ensuring maximum flexibility and speed within your specialized applications. You’ll also gain valuable insight into MySQL’s architecture and learn how to tweak its behavior through custom changes to the source code." -publisher description



High Performance MySQL

  • Authors: Jeremy Zawodny and Derek J. Balling
  • Publisher: O'Reilly Media
  • Published: 2004
  • ISBN: 0-596-00306-4
  • Pages: 294

"In High Performance MySQL you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs." -publisher description


Managing & Using MySQL, Second Edition

  • Authors: George Reese, Randy Jay Yarger, Tim King
  • Publisher: O'Reilly Media
  • Published: 2002
  • ISBN: 0-596-00211-4
  • Pages: 442

"Easy to take and use anywhere, the MySQL Pocket Reference provides instant reminders on how to use important MySQL functions in conjunction with key parts of the LAMP open source infrastructure. The book covers installation of MySQL and includes a description of SQL commands, data types, operators, and functions. In this small book, you get a handy reference to the enormous feature set of MySQL, the dominant database in the open source world." -publisher description



MySQL Administrator's Guide & Reference Manual

  • Authors: MySQL Documentation department
  • Publisher: MySQL Press
  • Published: 2006
  • ISBN: 0-672-32870-4
  • Pages: 888

"Written by the creators of MySQL and edited by one of the most highly respected MySQL authors, the MySQL Administrator's Guide and Language Reference is the official guide to installing MySQL, to setting up and administering MySQL databases, and to storing and retrieving data in these databases. This new edition combines into one book the MySQL Language Reference (on CD) with the practical information of the MySQL Administrator's Guide book." -publisher description


Learning PHP & MySQL

  • Authors: Michele Davis, Jon Phillips
  • Publisher: O'Reilly Media
  • Published: 2006
  • ISBN: 0-596-10110-4
  • Pages: 376

"Featuring basic concepts explained in plain English, Learning PHP and MySQL is the ideal guide for newcomers attracted to the popular PHP and MySQL combination. Learn how to generate dynamic web content in a slow, easy-to-follow fashion. Also covers error handling, security, HTTP authentication, and more." -publisher description


Learning MySQL

  • Authors: Seyed M.M. "Saied" Tahaghoghi, Hugh E. Williams
  • Publisher: O'Reilly Media
  • Published: 2006
  • ISBN: 0-596-00864-3
  • Pages: 618

"Learning MySQL provides all the tools you need to set up and design an effective database. This richly detailed tutorial will help you design scalable and flexible databases, create powerful queries using SQL, and configure MySQL for improved security. After covering the basics, the book travels far into MySQL's subtleties, including complex queries and joins, how to interact with the database over the Web using PHP or Perl, and important house-keeping such as backups and security." -publisher description



MySQL Certification Study Guide

  • Authors: Paul DuBois, Stefan Hinz, and Carsten Pedersen
  • Publisher: MySQL Press
  • Published: 2005
  • ISBN: 0-672-32812-7
  • Pages: 672

"This is the official guide to passing the two MySQL certification tests for MySQL 5, the long-awaited major revision of MySQL. It includes a voucher for 25 percent off either exam-a $50 value! The number of MySQL certification exams taken has doubled in the last six months." -publisher description


MySQL Clustering

  • Authors: Alex Davies, Harrison Fisk
  • Publisher: MySQL Press
  • Published: 2006
  • ISBN: 0-672-32855-0
  • Pages: 216

"Clustering is the final component of MySQL that makes it truly enterprise-level and able to compete fully with proprietary databases such as Oracle and Microsoft SQL Server. The increased number of high-demand, high-productivity corporations and institutions choosing MySQL, including MIT, the Department of Homeland Security, NASA, and Nokia, to name a few, need the benefit of clustering databases for high performance and scalability." -publisher description


MySQL: The Complete Reference

  • Authors: Vikram Vaswani, Pamela Smith
  • Publisher: Osborne
  • Published: 2003
  • ISBN: 0-072-22477-0
  • Pages: 544

"MySQL: The Complete Reference has been designed as a comprehensive reference for MySQL users, developers, and database administrators. It contains extensive information on the MySQL RDBMS (including MySQL 4.x), and provides one-stop coverage of all topics related to MySQL deployment, right from software installation and configuration to data backup and replication." -publisher description


MySQL Cookbook, 2nd Ed.

  • Authors: Paul DuBois
  • Publisher: MySQL Press
  • Published: 2006
  • ISBN: 0-596-52708-X
  • Pages: 975

"A handy resource when you need quick solutions or techniques, this Cookbook addresses specific questions in using MySQL. You'll find dozens of short, focused pieces of code and hundreds of worked-out examples that are perfect for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch. The new edition covers MySQL 5.0 and the older but still widespread MySQL 4.1. " -publisher description


MySQL Database Design and Tuning

  • Authors: Robert D. Schneider
  • Publisher: MySQL Press
  • Published: 2005
  • ISBN: 1-59059-332-4
  • Pages: 432

"The authoritative, hands-on guide to advanced MySQL programming and administration techniques for high performance is here. MySQL Database Design and Tuning is the only guide with coverage of both the basics and advanced topics, including reliability, performance, optimization and tuning for MySQL. This clear, concise and unique source for the most reliable MySQL performance information will show you how to deploy the right MySQL product for your performance needs; set up a performance management and monitoring environment using tools from MySQL; implement the right indexing strategy; apply good performance strategy when developing software to work with the MySQL database; and configure dozens of variable to correctly tune the MySQL engine." -publisher description


MySQL Enterprise Solutions

  • Authors: Alexander "Sasha" Pachev
  • Publisher: Wiley
  • Published: 2003
  • ISBN: 978-0-471-26922-9
  • Pages: 416

"With more than three million users, MySQL is the most popular open-source database server in the world, providing an extremely fast, reliable, and inexpensive alternative to commercial database management systems. This book gives corporate users a complete guide to building enterprise-level database applications with MySQL; covers the pros and cons of adopting MySQL and installing, testing, and configuring the MySQL server. It's written by one of the lead programmers of the MySQL product and reviewed by Monty Widenius, the creator of MySQL." -publisher description


MySQL and Java Developer's Guide

  • Authors: Mark Matthews, Jim Cole, Joseph D. Gradecki
  • Publisher: Wiley
  • Published: 2003
  • ISBN: 978-0-471-26923-6
  • Pages: 432

"This book shows Java developers everything they need to know to build Java database applications with MySQL; and takes a hands-on, code-intensive approach in which readers will learn how to build a sophisticated Web database management application. It begins with a review of the fundamentals of MySQL. It explains using Java's JDBC with MySQL, as well as servlet and JSP programming with MySQL. The text provides a code-rich tutorial on how to build the sample Java database application using EJBs." -publisher description


MySQL in a Nutshell

  • Author: Russell J.T. Dyer
  • Publisher: O'Reilly Media
  • Published: 2005
  • ISBN: 0-596-00789-2
  • Pages: 348

"MySQL in a Nutshell covers all MySQL functions, as well as MySQL administration, and listings for the most important language APIs available to programmers. This wealth of information is packed into the concise, comprehensive, and extraordinarily easy-to-use format for which the in a Nutshell guides are renowned. It clearly documents every detail you need to master MySQL. " -publisher description


MySQL Pocket Reference

  • Authors: George Reese
  • Publisher: O'Reilly Media
  • Published: 2003
  • ISBN: 0-596-00446-X
  • Pages: 94

"Easy to take and use anywhere, the MySQL Pocket Reference provides instant reminders on how to use important MySQL functions in conjunction with key parts of the LAMP open source infrastructure. The book covers installation of MySQL and includes a description of SQL commands, data types, operators, and functions. In this small book, you get a handy reference to the enormous feature set of MySQL, the dominant database in the open source world." -publisher description



MySQL Stored Procedure Programming

  • Authors: Guy Harrison, Steven Feuerstein
  • Publisher: O'Reilly Media
  • Published: 2006
  • ISBN: 0-596-10089-2
  • Pages: 636

"MySQL Stored Procedure Programming covers a lot of ground. The book starts with a thorough introduction to stored procedures programming and functions, covering the fundamentals of data types, operators, and using SQL in stored procedures. You'll learn how to build and maintain stored programs -- covering transactions, stored functions, and triggers -- and how to call and use MySQL-based stored procedures in a variety of languages, including PHP, Perl, Python, .NET, and Java. This book, destined to be the bible of stored procedure development, is a resource that no real MySQL programmer can afford to do without." -publisher description


MySQL Tutorial

  • Authors: Luke Welling and Laura Thomson
  • Publisher: MySQL Press
  • Published: 2003
  • ISBN: 0-672-32584-5
  • Pages: 288

"MySQL Tutorial is a clear, concise introduction to the fundamental concepts and techniques of working with MySQL. It teaches the beginning MySQL user how to create and administer powerful databases that can be used at home, at work, and on the Web. Whether you are a novice to databases or a technical professional looking to find out more about how MySQL works, MySQL Tutorial efficiently guides you through the information you need in order to get started with MySQL and quickly become proficient." -publisher description


Pro MySQL

  • Author: Michael Kruckenberg, Jay Pipes
  • Publisher: Apress
  • Published: 2005
  • ISBN: 1-590-59505-X
  • Pages: 525

"Pro MySQL is the first book that exclusively covers intermediate and advanced features of MySQL, the world's most popular open source database server. Whether you are a seasoned MySQL user looking to take your skills to the next level, or you’re a database expert searching for a fast-paced introduction to MySQL's advanced features, this book is for you." -publisher description



Web Database Applications with PHP and MySQL, Second Edition

  • Authors: Hugh E. Williams, David Lane
  • Publisher: O'Reilly Media
  • Published: 2004
  • ISBN: 0-596-00543-1
  • Pages: 816

"This new edition has been redesigned around the rich offerings of PEAR. Several of these, including the Template package and the database-independent query API, are fully integrated into examples and thoroughly described in the text. In addition, through a complex sample application--Hugh and Dave's Wine Store--all the important techniques of dynamic content are introduced. Good design is emphasized, such as dividing logic from presentation. The book introduces PHP 5 and MySQL 4.1 features, while providing techniques that can be used on older versions of the software that are still in widespread use. " -publisher description