Cantitate/Preț
Produs

MySQL Database Usage & Administration

Autor Vikram Vaswani
en Limba Engleză Paperback – 16 dec 2009
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.
Citește tot Restrânge

Preț: 30209 lei

Preț vechi: 37760 lei
-20% Nou

Puncte Express: 453

Preț estimativ în valută:
5781 6005$ 4802£

Carte disponibilă

Livrare economică 11-25 ianuarie 25

Preluare comenzi: 021 569.72.76

Specificații

ISBN-13: 9780071605496
ISBN-10: 0071605495
Pagini: 368
Dimensiuni: 185 x 231 x 18 mm
Greutate: 0.6 kg
Editura: McGraw Hill Education
Colecția McGraw-Hill
Locul publicării:United States

Cuprins

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