MySQL Database Usage & Administration
Will be published approx. on 16. December 2009
Book
Paperback/Softback
368 pages
978-0-07-160549-6 (ISBN)
Description
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 tierMaximize 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.
Take your MySQL skills to the top tierMaximize 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.
More details
Language
English
Place of publication
New York
United States
Publishing group
McGraw-Hill Education - Europe
Target group
Professional and scholarly
Illustrations
0 Illustrations
Dimensions
Height: 235 mm
Width: 191 mm
Thickness: 20 mm
Weight
690 gr
ISBN-13
978-0-07-160549-6 (9780071605496)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Person
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.
Content
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