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.<ul><li>Understand MySQL's features technical architecture subsystems and commands<li>Make database design decisions that optimizre performance storage and reliability<li>Write complex queries using joins subqueries and views<li>Group SQL statements into transactions and execute them atomically<li>Build and use sophisticated stored procedures and functions<li>Automate database operations with triggers and scheduled events<li>Import and export data in different formats includiong SQL CSV and XML<li>Optimize server and query performance<li>Administer a secure high availability MySQL RDBMS<li>Manage users and control access<li>Perform database maintenance replication backup and recovery</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>.