MySQL Database Usage & Administration (Paperback)
暫譯: MySQL 資料庫使用與管理 (平裝本)
Vikram Vaswani
- 出版商: McGraw-Hill Education
- 出版日期: 2009-11-01
- 定價: $1,650
- 售價: 8.0 折 $1,320
- 語言: 英文
- 頁數: 368
- 裝訂: Paperback
- ISBN: 0071605495
- ISBN-13: 9780071605496
-
相關分類:
MySQL、SQL、資料庫
立即出貨 (庫存=1)
買這商品的人也買了...
-
$1,782XML: The Complete Reference (Paperback)
-
$990Mathematics and Physics for Programmers (Paperback)
-
$990$891 -
$990Windows Administration Resource Kit : Productivity Solutions for IT Professionals (Paperback)
-
$620$527 -
$788Beginning Ubuntu LTS Server Administration: From Novice to Professional, 2/e
-
$875AJAX: A Beginner's Guide
-
$780$663 -
$650$553 -
$399JavaScript: A Beginner's Guide, 3/e (Paperback)
-
$680$537 -
$420$328 -
$820$648 -
$890$757 -
$490$387 -
$490$417 -
$950$741 -
$490$382 -
$960Discovering SQL: A Hands-On Guide for Beginners (Paperback)
-
$780$616 -
$550$435 -
$1,130$893 -
$450$356 -
$500$425 -
$940$700
商品描述
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.
商品描述(中文翻譯)
將您的 MySQL 技能提升至頂尖水平
透過 MySQL 專家的實作指導,最大化 MySQL 5.1 中每一個強大的功能。本指南詳細介紹如何使用 MySQL 的高級數據管理工具,優化性能和可靠性,並安全地管理一個穩健的關聯式資料庫管理系統 (RDBMS)。MySQL 數據庫使用與管理 每章節中包含詳細的程式碼範例,以突顯所涵蓋材料的實際應用。如果您想充分利用 MySQL,這本實用手冊是您必備的資源。
- 了解 MySQL 的功能、技術架構、子系統和命令
- 做出優化性能、儲存和可靠性的資料庫設計決策
- 使用聯接、子查詢和視圖撰寫複雜查詢
- 將 SQL 語句分組為交易並原子性執行
- 建立並使用複雜的儲存程序和函數
- 使用觸發器和排程事件自動化資料庫操作
- 以不同格式(包括 SQL、CSV 和 XML)進行數據的匯入和匯出
- 優化伺服器和查詢性能
- 管理安全的高可用性 MySQL RDBMS
- 管理用戶並控制訪問權限
- 執行資料庫維護、複製、備份和恢復
Vikram Vaswani 是 Melonfire (www.melonfire.com) 的創辦人兼執行長,該公司專注於開源工具和技術的諮詢服務。他的前著作包括 MySQL: The Complete Reference, PHP: A Beginner's Guide 和 PHP Programming Solutions。