Résumé
- 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
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
Contents
Acknowledgments
Introduction
Pt. 1 MySQL and the Relational Model 1
1 Introduction to MySQL 3
2 Installing MySQ 19
3 Interacting with MySQL 27
4 Database Concepts 35
5 The Relational Model 47
6 Structured Query Language 63
7 Database Design 77
8 Normalization 95
9 Transactions and Concurrency 109
Pt. 2 MySQL Reference 119
10 Data Types, Variables, and Expressions 121
11 Column and Index Types 139
12 Built-in Functions 153
13 SQL Statements 213
14 Command-Line Utilities 283
15 C API 379
Pt. 3 Writing MySQL Clients 433
16 Programming the C API 435
17 JDBC 447
18 VBScript and ODBC 457
19 PHP 467
20 Perl 475
21 Python 483
22 MySQL++ API 489
Pt. 4 Advanced Topics 497
23 Database Administration 499
24 Physical Storage 507
25 Coping with Disaster 527
26 Optimization 539
27 Security 563
28 Transitioning 577
29 Distributed Databases 593
30 Object Mapping 609
31 Adding Functionality 627
App. A: Online Resources 643
App. B: Further Reading 649
App. C Business and Legal Concerns 651
App. D: Reserved Words 663
App. E MySQL Error Codes 667
App. F SQL Style Guide 683
App. G Example Database Design
Extrait du livre
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Prentice Hall |
Auteur(s) | Leon Atkinson |
Parution | 05/03/2002 |
Nb. de pages | 722 |
Format | 18 x 23,5 |
Couverture | Broché |
Poids | 1090g |
Intérieur | Noir et Blanc |
EAN13 | 9780130661906 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse