MySQL Database Usage & Administration

MySQL Database Usage & Administration

<h4>Take your MySQL skills to the top tier</h4> <p>Maximize every powerful feature available in MySQL 5.1 with hands-on instruction from a MySQL expert. This definitive guide shows you how to use MySQL's advanced suite of data management tools, optimize performance and reliability, and secure and administer a robust RDBMS. <i>MySQL Database Usage & Administration</i> includes detailed code examples in each chapter to highlight real-world applications of the material covered. If you want to get the most out of MySQL, you need this practical handbook.</p> <ul> <li>Understand MySQL's features, technical architecture, subsystems, and commands</li> <li>Make database design decisions that optimizre performance, storage, and reliability</li> <li>Write complex queries using joins, subqueries, and views</li> <li>Group SQL statements into transactions and execute them atomically</li> <li>Build and use sophisticated stored procedures and functions</li> <li>Automate database operations with triggers and scheduled events</li> <li>Import and export data in different formats, includiong SQL, CSV, and XML</li> <li>Optimize server and query performance</li> <li>Administer a secure, high availability MySQL RDBMS</li> <li>Manage users and control access</li> <li>Perform database maintenance, replication, backup, and recovery</li> </ul> <p><b>Vikram Vaswani</b> is the founder and CEO of Melonfire (www.melonfire.com), a consultancy firm with special expertise in open-source tools and technologies. His previous books include <i>MySQL: The Complete Reference, PHP: A Beginner's Guide</i>, and <i>PHP Programming Solutions</i>.</p>