MySQL Database Usage & Administration

MySQL Database Usage & Administration, 9780071605496 (0071605495), McGraw-Hill, 2009

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.

Comments

Amazing Books

Schaum's Easy Outline HTML

McGraw-Hill, 2003

What could be better than the bestselling Schaum's Outline series? For students looking for a quick nuts-and-bolts overview, it would have to be Schaum's Easy Outline series. Every book in this series is a pared-down, simplified, and tightly focused version of its predecessor. With an emphasis on clarity and brevity, each new title features a...

CWTS: Certified Wireless Technology Specialist Official Study Guide: Exam PW0-070 (CWNP Official Study Guides)

Sybex, 2009

This book is intended to provide an introduction to the exciting and emerging world of wireless LAN technology. This technology continues to expand at a phenomenal pace with constant improvements in speed, reliability, and security. Reading this book will teach you the fundamentals of standards-based technology, giving you an overview of the...

XSLT and XPath On The Edge, Unlimited Edition

John Wiley & Sons, 2001

Extensible Stylesheet Language Transformations, along with the XML Path Language, give you the power to transform XML documents into HTML documents, or to other XML documents that you can use in Web-based applications. But how do you implement XSLT in the real world? This book provides the answers. Covering everything from reformatting numbers to...

Pricing, Risk, and Performance Measurement in Practice: The Building Block Approach to Modeling Instruments and Portfolios

Academic Press, 2009

If you are reading this you are probably either considering buying this book or have already done so.

If you have already purchased this book we would like to say thank you, and congratulate you for deciding to join us on our journey toward better, faster, more resilient, and more flexible pricing, risk modelling, and performance...

Dynamic and Advanced Data Mining for Progressing Technological Development: Innovations and Systemic Approaches

Information Science Publishing, 2009

Overcoming many challenges, data mining has already established discipline capability in many domains. discusses advances in modern data mining research in today's rapidly growing global and technological...

Analog Circuit Design: Scalable Analog Circuit Design, High-Speed D/A Converters, RF Power Amplifiers

Springer, 2002

This tenth volume of Analog Circuit Design concentrates on 3 topics: 1. Scalable Analog Circuits, 2. High-Speed D/A Converters, and 3. RF Power Amplifiers. Each topic is covered by 6 papers, written by international recognized experts on that topic. These papers have a tutorial nature aimed at improving the design of analog circuits....