Vikram Vaswani

MySQL Database Usage & Administration

• Broschiertes Buch

Produktbeschreibung

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.

Produktdetails

• Verlag: McGraw-Hill Osborne / McGraw-Hill Professional
• Seitenzahl: 368
• Erscheinungstermin: 1. November 2009
• Englisch
• Abmessung: 232mm x 188mm x 19mm
• Gewicht: 590g
• ISBN-13: 9780071605496
• ISBN-10: 0071605495
• Artikelnr.: 26860159

Autorenporträt

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.

Inhaltsangabe

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