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.
Complete Idiot's Guide to the Pilates Method
This book teaches the basics of the Pilates method of fitness, a whole body workout that strengthens the abs and back and straightens the posture. Practiced worldwide by dance companies, physical therapists, and health clubs, the method is especially good for pregnant women, for people who have special fitness needs because of chronic back...
Advances in Computers, Volume 91
Since its first volume in 1960, Advances in Computers has presented detailed coverage of innovations in computer hardware, software, theory, design, and applications. It has also provided contributors with a medium in which they can explore their subjects in greater depth and breadth than journal articles usually allow. As a result,...
Building the Global Fiber Optics Superhighway
Many wonderful stories have contributed to the growth and worldwide renown of the fiber optics industry. From its improbable roots in the 1960s and the important early laser work by Stewart Miller and colleagues at Bell Laboratories to seminal discoveries by Coming’s Don Keck, Robert Maurer, and Peter Schultz in 1970 demonstrating that...
Robot Vision: Strategies, Algorithms and Motion Planning
The field of robot vision guidance is developing rapidly. The benefits of sophisticated vision technology include savings, improved quality, reliability, safety and productivity. Robot vision is used for part identification and navigation. Vision applications generally deal with finding a part and orienting it for robotic handling or...
Microsoft Windows XP Step by Step (With CD-ROM) MICROSOFT WINDOWS XP STEP BY STEP offers self-paced instruction to the beginning-to-intermediate user who wants to get the most out of Windows XP. This personal training system offers easy-to-follow lessons full of clear objectives, a wealth of task-oriented procedures, and dozens of real-world business scenarios. MICROSOFT WINDOWS XP STEP BY STEP...