Home >

MySQL Database Usage & Administration
MySQL Database Usage & Administration
List Price: $53.00
Our Price: $45.05
You save $7.95!

Product Code: 0-07-160549-5

Product Details
Pages: 368
Product Type: Book
ISBN-13: 978-0-07-160549-6

A complete, authoritative reference on the MySQL database server

Written by a MySQL expert, this book contains extensive information on the latest version of the world's most popular open-source database. MySQL Database Usage & Administration provides comprehensive coverage of all topics related to MySQL deployment, from installation to data backup and optimization. Information on workplace deployment and development on the MySQL architecture is also included.

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

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.

Share your knowledge of this product with other customers... Be the first to write a review

IT and Professional Certification

Welcome to mindhub, from Pearson VUE – your one stop online shopping resource for IT and Professional certification exam preparation material. Here you will find the latest study guides and course material for a wide range of certifications including network certification, professional certification, and system administration. Our products come from industry leading publishers such as Cisco Press, MeasureUp, Pearson, Sybex, Transcender, and many more.

Certification Exam Practice

Choose from our large collection of certification prep guides and study books to help you succeed on your next certification exam. Once you have completed studying, make sure you are ready for the exam with a certification exam practice test. Our selection of practice tests provide realistic and accurate simulations of the live exams. They also include sample questions and explanations of the answers so you can be sure you are ready for the big exam.

At mindhub, we offer the widest range of test prep and study products to help you succeed when it comes time to take your certification exam.


Join the conversation for special offers and coupons!


Get exclusive offers, sales and
special deals delivered to your inbox!