Appropriate for all courses on MySQL, and all courses preparing students for the new MySQL certification exams-both Core Certification and Professional Certification.
Direct from MySQL AB Press-and thoroughly reviewed for accuracy by MySQL-this is the authoritative preparation guide for MySQLs new Core Certification and Professional Certification exams. Leading MySQL experts Paul DuBois, Stefan Hinz, and Carsten Pedersen review every concept, principle, and technique covered in both exams, encompassing using MySQL, maintaining it, and administering it. Coverage includes: understanding the MySQL database engine, architecture, and client programs; DDL; SELECT, UPDATE, and basic SQL; joins; importing and exporting data; installation and configuration; security; optimizing query speed; MyISAM and InnoDB tables; advanced server features, and more. Each chapter contains hands-on exercises to help students assess and confirm their knowledge. The book also contains references to SQL Statements and functions, column types, and server system variables, as well as a complete MySQL certificate candidates guide. An array of learning aids and real-world examples are provided to help students prepare for their exams as rapidly and effectively as possible.
With more than four million active installations, MySQL is the world's most popular open-source database. Written by Paul DuBois, the leading author of books on MySQL topics, and reviewed for technical accuracy by MySQL AB, this study guide is the fastest, most reliable way for MySQL users to prepare for either of the MySQL tests.