Core MySQL
Leon Atkinson
- 出版商: Prentice Hall
- 出版日期: 2001-12-15
- 定價: $1,575
- 售價: 2.5 折 $399
- 語言: 英文
- 頁數: 752
- 裝訂: Paperback
- ISBN: 0130661902
- ISBN-13: 9780130661906
-
相關分類:
MySQL、SQL
立即出貨(限量) (庫存=1)
買這商品的人也買了...
-
$1,240$1,178 -
$1,029Fundamentals of Data Structures in C
-
$2,190$2,081 -
$399Core JSP (Paperback)
-
$1,450$1,378 -
$650$650 -
$399The FreeBSD Corporate Networker's Guide
-
$399Advanced JavaServer Pages (Paperback)
-
$399MySQL: Building User Interfaces
-
$1,880$1,786 -
$990Core JFC, 2/e (Paperback)
-
$1,140Advanced Java 2 How to Program (Paperback)
-
$199Upgrading Microsoft Visual Basic 6.0 to Microsoft Visual Basic .NET (Paperback)
-
$1,320$1,254 -
$1,260Core Perl (Paperback)
-
$1,990$1,891 -
$1,540$1,463 -
$399Web Security Field Guide
-
$850Terminal Services for Microsoft Windows Server 2003: Advanced Technical Design Guide
-
$1,083Java How to Program, 6/e (IE)(美國版ISBN:0131483986)
-
$650$507 -
$490$382 -
$490$382 -
$450$351 -
$680$537
相關主題
商品描述
The comprehensive, code-rich MySQL guide for expert developers.
- Contains in-depth explanations and example code for designing and building enterprise-level systems
- Includes advanced coverage of security, data storage, optimization, distributed databases, and other complex topics
- Presented by leading open-source expert Leon Atkinson—author of the best-selling Core PHP Programming
Experienced developers worldwide are choosing MySQL as a low-cost, open-source foundation for their key Web applications. Now, here's a book that gives them all the code and insight they need to build enterprise-class MySQL applications—fast.
Core MySQL starts by introducing the fundamentals of MySQL: SQL queries, database design, normalization, transactions, and concurrency. It then systematically reviews each of MySQL's most important features, and presents efficient techniques for interacting with MySQL databases directly from C, Java, PHP, Perl, Python, and other programming environments. Coverage includes:
- Installing and interacting with MySQL—including a detailed introduction to MySQL's SQL implementation
- Data types, variables, column types, built-in functions, and command-line utilities
- Comprehensive coverage of using MySQL's C API
- MySQL administration, backup, and disaster recovery
- Application optimization and security
- Distributed database development
- Extending MySQL with added functionality
- Building databases that can be transitioned to other database platforms
Thoroughly reviewed by MySQL lead developer Michael Widenius, Core MySQL gives professionals exactly what they've been searching for: an authoritative, thorough, example-rich guide to enterprise-class MySQL application development.
Table of
Contents
Acknowledgments.
Introduction.
I. MYSQL AND THE RELATIONAL MODEL.
1. Introduction to MySQL.
2. Installing MySQ.
3. Interacting with MySQL.
4. Database Concepts.
5. The Relational Model.
6. Structured Query Language.
7. Database Design.
8. Normalization.
9. Transactions and Concurrency.
II. MYSQL REFERENCE.
10. DATA TYPES, VARIABLES, AND EXPRESSIONS.
11. Column and Index Types.
12. Built-in Functions.
13. SQL Statements.
14. Command-Line Utilities.
15. C API.
III. WRITING MYSQL CLIENTS.
16. programming the C API.
17. JDBC.
18. VBScript and ODBC.
19. PHP.
20. Perl.
21. Python.
22. MySQL++ API.
IV. ADVANCED TOPICS.
23. Database Administration.
24. Physical Storage.
25. Coping with Disaster.
26. Optimization.
27. Security.
28. Transitioning.
29. Distributed Databases.
30. Object Mapping.
31. Adding Functionality.
V. APPENDICES.
A. Online Resources.
B. Further Reading.
C. Business and Legal Concerns.
D. Reserved Words.
E. MySQL Error Codes.
F. SQL Style Guide.
G. Example Database Design.
商品描述(中文翻譯)
這本書是一本豐富代碼的MySQL指南,專為熟練開發人員而設計。
它包含了深入的解釋和範例代碼,用於設計和構建企業級系統。
它涵蓋了安全性、數據存儲、優化、分佈式數據庫和其他複雜主題的高級內容。
這本書由領先的開源專家Leon Atkinson撰寫,他是暢銷書《Core PHP Programming》的作者。
全球經驗豐富的開發人員選擇MySQL作為低成本、開源的基礎,用於他們的關鍵Web應用程序。現在,這本書為他們提供了構建企業級MySQL應用程序所需的所有代碼和見解。
《Core MySQL》首先介紹了MySQL的基礎知識:SQL查詢、數據庫設計、規範化、事務和並發。然後,它系統地回顧了MySQL的每個最重要的功能,並提供了從C、Java、PHP、Perl、Python和其他編程環境直接與MySQL數據庫交互的高效技術。內容包括:
- 安裝和與MySQL交互,包括對MySQL的SQL實現的詳細介紹
- 數據類型、變量、列類型、內置函數和命令行工具
- 全面介紹使用MySQL的C API
- MySQL管理、備份和災難恢復
- 應用程序優化和安全性
- 分佈式數據庫開發
- 通過添加功能擴展MySQL
- 構建可以過渡到其他數據庫平台的數據庫
《Core MySQL》經過MySQL首席開發人員Michael Widenius的全面審查,為專業人士提供了他們一直在尋找的東西:一本權威、全面、範例豐富的企業級MySQL應用程序開發指南。
目錄:
- 致謝
- 簡介
- 第一部分:MySQL和關聯模型
- 第1章:MySQL簡介
- 第2章:安裝MySQL
- 第3章:與MySQL交互
- 第4章:數據庫概念
- 第5章:關聯模型
- 第6章:結構化查詢語言
- 第7章:數據庫設計
- 第8章:規範化
- 第9章:事務和並發