MySQL Database Usage & Administration

Vikram Vaswani

ISBN 10: 0071605495 / ISBN 13: 9780071605496

Verlag: Mcgraw Hill LLC Nov 2009, 2009

Beschreibung

Neuware - 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.

Bestandsnummer des Verkäufers 9780071605496

Bibliografische Details

• Titel: MySQL Database Usage & Administration
• Verlag: Mcgraw Hill LLC Nov 2009
• Erscheinungsjahr: 2009
• Sprache: Englisch
• ISBN-10: 0071605495
• ISBN-13: 9780071605496
• Einband: Taschenbuch
• Zustand: Neu

Über diesen Titel

Inhaltsangabe

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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.

Über die Autorin bzw. den Autor

Vikram Vaswani is the founder and CEO of Melonfire (http://www.melonfire.com/), a company specializing in software consultancy and content creation and syndication services. He is also the author of PHP Programming Solutions, How to do Everything with PHP and MySQL, and MySQL: The Complete Reference (all McGraw-Hill/Osborne titles) and XML and PHP (New Riders Publishing). He is also the author of numerous well-received articles on open-source technologies (including Perl, Python, XML and the very popular PHP 101 series), all written with the goal of making complex technologies accessible and understandable to novice users. He has been developing software since 1995, was first introduced to PHP in 1998, and hasn't looked back since. He is regular columnist with Zend Technologies (creators of PHP), as well as with IBM DeveloperWorks, CNET Builder.com, DevX.com and other OSS sites.