Product Description
Core MySQL gives professionals exactly what they've been searching for: an authoritative, thorough, example-rich guide to enterprise-class MySQL application development. Thoroughly reviewed by MySQL lead developer Michael Widenous, the book starts with the fundamentals of MySQL, then systematically reviews each key feature, and offers in-depth coverage of interacting with MySQL databases directly, from several leading programming environments. Expert open source Web developer and best-selling Core PHP author Leon Atkinson walks through installing and configuring MySQL, and offers a detailed introduction to the capabilities and limitations of MySQL's SQL implementation. Atkinson introduces MySQL data types, variables, column types, built-in functions, queries, database design, normalization, transactions, and concurrency. Core MySQL includes in-depth coverage of application optimization; security; distributed database development; administration, backup, and recovery. Atkinson demonstrates how to extending MySQL's functionality; and even presents database design techniques that make it easier to migrate MySQL databases to other platforms if that becomes necessary. The book also includes full chapters on interacting with MySQL from C, Java, PHP, Perl, Python, and other leading programming environments. For all experienced developers seeking an effective, low-cost, open source solution for Web database development.
From the Back Cover
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.
See all Product Description