Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
MySQL Database Usage & Administration

Buy

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.

(HTML tags aren't allowed.)

China's Drug Practices and Policies: Regulating Controlled Substances in a Global Context
China's Drug Practices and Policies: Regulating Controlled Substances in a Global Context

In the context of global efforts to control the production, distribution, and use of narcotic drugs, China's treatment of the problem provides an important means of understanding the social, political, and economic limits of national and international policies to regulate drug practices. In the nineteenth and early twentieth centuries, China was...

Complete Idiot's Guide to the Pilates Method
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
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
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
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 (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...
©2019 LearnIT (support@pdfchm.net) - Privacy Policy