Synopses & Reviews
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 and 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.
The most authoritative reference on the MySQL database server. The MySQL development team will review and provide a foreword for the book.
About the Author
Vikram Vaswani 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.
Table of Contents
Part I: Usage
; Chapter 1.
An Introduction to MySQL; Chapter 2.
Understanding Basic Commands; Chapter 3.
Making Design Decisions; Chapter 4.
Using Joins, Subqueries, and Views; Chapter 5.
Using Transactions; Chapter 6.
Using Stored Procedures and Functions; Chapter 7.
Using Triggers and Scheduled Events; Chapter 8.
Working with Data in Different Formats; Chapter 9.
Optimizing Performance; Part II: Administration
; Chapter 10.
Performing Basic Server Administration; Chapter 11.
Managing Users and Controlling Access; Chapter 12.
Performing Maintenance, Backup, and Recovery; Chapter 13.
Replicating Data; Appendix A.
Installing MySQL and the Sample Database; Index