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 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
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 develCore MySQL gives professionals exactly what they've been searching an authoritative, thorough, example-rich guide to enterprise-class MySQL application development.