Take your MySQL skills to the top tier
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. MySQL Database Usage & Administration 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.
Understand MySQL's features, technical architecture, subsystems, and commands
Make database design decisions that optimizre performance, storage, and reliability
Write complex queries using joins, subqueries, and views
Group SQL statements into transactions and execute them atomically
Build and use sophisticated stored procedures and functions
Automate database operations with triggers and scheduled events
Import and export data in different formats, includiong SQL, CSV, and XML
Optimize server and query performance
Administer a secure, high availability MySQL RDBMS
Manage users and control access
Perform database maintenance, replication, backup, and recovery
Vikram Vaswani 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 MySQL: The Complete Reference, PHP: A Beginner's Guide, and PHP Programming Solutions.
is the founder and CEO of Melonfire (www.melonfire.com), a software consultancy. He is the author of
PHP Programming Solutions
and
MySQL: The Complete Reference
.
Keywords: MYSQL, BOOK, GUIDE, HOW TO, INSTALLATION, CONFIGURATION, SUBQUERIES, TRANSACTIONS, TRIGGERS, STORED PROCEDURES, FUNCTIONS, VIEWS, EVENTS, LOCALIZATION, ADMINISTRATION, SECURITY, PRIVILEGES, MAINTENANCE, BACKUP, RECOVERY, OPTIMIZATION, REPLICATION, CLUSTERING, DEVELOPMENT, C, PERL, PHP, API, XML, PHP PROGRAMMING SOLUTIONS, MYSQL THE COMPLETE REFERENCE, HTML & XHTML: THE COMPLETE REFERENCE, PHP 6 A BEGINNER'S GUIDE, PHP THE COMPLETE REFERENCE, HOW TO DO EVERYTHING WITH PHP AND MYSQL, CSS XHTML COMPLETE REFERENCE, AJAX THE COMPLETE REFERENCE, AJAX BEGINNER'S GUIDE, JAVASERVER FACES THE COMPLETE REFERENCE, STRUTS 2 THE COMPLETE REFERENCE, JAVASCRIPT THE COMPLETE REFERENCE, SQL A BEGINNER'S GUIDE