- Use promo code PRIMEBOOKS18 to save $5.00 when you spend $20.00 or more on Books offered by Amazon.com. Enter code PRIMEBOOKS18 at checkout. Here's how (restrictions apply)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
DUBOIS: MYSQL 5 CERT STUDY GUIDE _p2 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
See the Best Books of 2018 So Far
Looking for something great to read? Browse our editors' picks for the best books of the year so far in fiction, nonfiction, mysteries, children's books, and much more.
Frequently bought together
Customers who bought this item also bought
Special offers and product promotions
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.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
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
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 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.
I work with MySQL every day, but don't do a whole lot outside of looking at the data. The info in this book was still relevant and was enough to help me pass both tests.
I would recommend this to anyone about to take either exam.
Most recent customer reviews
I used it in preperation for the MySQL 5.Read more