Vikram Vaswani "MySQL Database Usage & Administration"
McGraw-Hill Companies | English | October 2009 | ISBN: 0071605495 | 368 pages | PDF | 2,4 MB
McGraw-Hill Companies | English | October 2009 | ISBN: 0071605495 | 368 pages | PDF | 2,4 MB
A complete, authoritative reference on the MySQL database server
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.
Vikram Vaswani is the founder and CEO of Melonfire (www.melonfire.com), a software consultancy. He is the author of PHP Programming Solutions and MySQL: The Complete Reference.
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
To start download click HERE: