MySQL Database Usage & Administration / Edition 1

MySQL Database Usage & Administration / Edition 1

by Vikram Vaswani
     
 

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

… See more details below

Overview

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.

Read More

Product Details

ISBN-13:
9780071605496
Publisher:
McGraw-Hill Professional Publishing
Publication date:
10/14/2009
Pages:
368
Product dimensions:
7.20(w) x 9.00(h) x 0.90(d)

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

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >