Book Description
The serious developer's guide to MySQL!
In-depth explanations and example code for designing and building enterprise-level systems.
Covers security, data storage, optimization, distributed databases, and other advanced topics.
Reviewed and endorsed by Michael Wideneous, the developer of MySQL. 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.
Leon Atkinson is author of Core PHP Programming and columnist for Zend Technologies. He maintains the FreeTrade project, an e-commerce toolkit that uses MySQL and PHP. Atkinson has utilized MySQL for a wide range of Web and e-commerce applications since discovering it in 1997.
Synopsis
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.
See all Product Description