{"product_id":"9780071605502","title":"MySQL Database Usage \u0026 Administration","description":"Take your MySQL skills to the top tier  \u003cp\u003eMaximize 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. \u003ci\u003eMySQL Database Usage \u0026amp; Administration\u003c\/i\u003e 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.\u003c\/p\u003e  \u003cul\u003e \u003cli\u003eUnderstand MySQL's features, technical architecture, subsystems, and commands\u003c\/li\u003e  \u003cli\u003eMake database design decisions that optimizre performance, storage, and reliability\u003c\/li\u003e  \u003cli\u003eWrite complex queries using joins, subqueries, and views\u003c\/li\u003e  \u003cli\u003eGroup SQL statements into transactions and execute them atomically\u003c\/li\u003e  \u003cli\u003eBuild and use sophisticated stored procedures and functions\u003c\/li\u003e  \u003cli\u003eAutomate database operations with triggers and scheduled events\u003c\/li\u003e  \u003cli\u003eImport and export data in different formats, includiong SQL, CSV, and XML\u003c\/li\u003e  \u003cli\u003eOptimize server and query performance\u003c\/li\u003e  \u003cli\u003eAdminister a secure, high availability MySQL RDBMS\u003c\/li\u003e  \u003cli\u003eManage users and control access\u003c\/li\u003e  \u003cli\u003ePerform database maintenance, replication, backup, and recovery\u003c\/li\u003e  \u003c\/ul\u003e  \u003cp\u003e\u003cb\u003eVikram Vaswani\u003c\/b\u003e 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 \u003ci\u003eMySQL: The Complete Reference, PHP: A Beginner's Guide\u003c\/i\u003e, and \u003ci\u003ePHP Programming Solutions\u003c\/i\u003e.\u003c\/p\u003e","brand":"McGraw Hill LLC","offers":[{"title":"Default Title","offer_id":47148146852080,"sku":"9780071605502","price":58.5,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780071605502_p0.jpg?v=1763635919","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780071605502","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}