MySQL 5.0 Certification Study Guide (Mysql Press) ペーパーバック – 2005/8/24
Kindle 端末は必要ありません。無料 Kindle アプリのいずれかをダウンロードすると、スマートフォン、タブレットPCで Kindle 本をお読みいただけます。
This is the official guide to passing the two MySQL certification tests for MySQL 5, the long-awaited major revision of MySQL. The number of MySQL certification exams taken has doubled in the last six months.
Certcities.com lists the MySQL certification as one of the top 10 certifications to grow in 2005. MySQL professionals need a way to distinguish themselves from the vast majority of database administrators and developers. With more than 4 million active installations, MySQL is the world's most popular open-source database. Known for its speed, reliability and case of use, MySQL has become a low-cost alternative to expensive database systems such as Oracle, IBM and Microsoft. MySQL AB has aggressively improved the feature set of MySQL with MySQL 5, making it more suitable for enterprise-level applications and uses. The MySQL certification tests, available at over 3,000 PearsonVUE testing centers, is a key component of this enterprise growth strategy, establishing a base level of skills for database users, administrators and programmers.
The MySQL Core Certification is aimed at the database user who wants proof of his or her abilities in such fundamental areas as SQL, data entry and maintenance, and data extraction. The MySQL Professional Certification test is designed for the advanced user who wants to prove his or her knowledge in such areas as database management, installation, security, disaster prevention and optimization. Both tests are thoroughly covered in the MySQL 5.0 Certification Study Guide . Written by Paul DuBois, the leading author of books on MySQL topics, and reviewed for technical accuracy by MySQL AB, this book is the fastest, most reliable way for MySQL users, developers, and administrators to prepare for either of the MySQL tests.
Paul DuBois is the leading author of books on MySQL topics. His book, entitled MySQL, is widely considered the definitive work on MySQL. He is a developer for MySQL AB, where he edits and maintains the official English-language documentation for MySQL. Stefan Hinz is leads the MySQL documentation team, is a MySQL trainer and consultant, and the German translator of the MySQL Reference Manual. He is also the translator of Paul's MySQL Cookbook (O'Reilly and Associates) and translator and author of MySQL-related German books. Stefan passed the MySQL Certification exam before he joined MySQL AB.
That said, you will likely need to supplement the book by reading the MySQL documentation if you wish to get as much knowledge as possible from the study process. Certainly try out each command on a test MySQL instance multiple times using version 5.x (NOT 5.1 where some behaviors have changed).
The practice questions provided are not all in multiple-choice format as you will encounter on the exam, which can be a good mental exercise for review, but the answer formats can be frustrating in some cases, as in the case of a multiple-choice question with five possible letter choices, wherein the answer is a paragraph that doesn't indicate the correct letter choices. Trivial but annoying.
Be sure you complete all practice questions from the accompanying CD and understand why your answers were right or wrong. There are no labs or practical exercises included, although a sample schema is included from which many of the practice questions are drawn.
If you are not taking the exams, this is still a good primer on MySQL.
I reviewed the areas tested on this exam as described on MySQL's web site, then planned my study around those areas. As most people retain only about 30% of what they read, I read each chapter twice. I read it a third time while typing notes from the book. I then read my notes twice. I worked the exercises on a spare computer I have that runs Ubuntu Server 12.04 64-Bit, a flavor of Linux. The book oft references the 'world' database in its examples. The database is available for download from MySQL's web site, along with information on importing it into the server.
You *will* need to learn the formatting of queries and statements. It's no different from learning any other new skill - book knowledge can only carry you so far. Some practical, hands-on work will absolutely make a difference. If you're disinclined to dedicate a physical machine to this, download a free copy of Oracle's VM VirtualBox.
I passed the test in under 40 minutes with a score of 88%.
Chapter 00: Introduction
Chapter 01: Client/Server Concepts
Chapter 02: The MySQL Client Program
Chapter 34: User Management
Chapter 23: MySQL Architecture
Chapter 24: Starting, Stopping & Configuring MySQL
Chapter 07: Databases
Chapter 08: Tables & Indexes
Chapter 05: Data Types
Chapter 09: Querying for Data
Chapter 10: SQL Expressions
Chapter 12: Joins
Chapter 14: Views
Chapter 11: Updating Data
Chapter 15: Importing & Exporting Data
I also liked the style very much. It's very proffesional but not too dry and reading is not boring.
There are a few glitches here and there (table of content is off, the CD ROM didn't work well), but they are not really impacting your study.
Overall, I liked it very much and I wish more vendors would adopt that format and style.
And, by the way, I passed both exams at the first try using this book only (well, I've been working with MySQL a bit in the past, but I clearly had holes in my knowledge before).
So I highly recommend this book as a perfect MySQL certification guide and general reference.