Skip to content

MySQL 5. 0 Certification Study Guide

Spend $50 to get a free DVD!

ISBN-10: 0672328127

ISBN-13: 9780672328121

Edition: 2nd 2006

Authors: Paul DuBois, Stefan Hinz, Carsten Pedersen

List price: $64.99
Shipping box This item qualifies for FREE shipping.
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!


This is the official guide to passing the two MySQL certification tests for MySQL 5, the long-awaited major revision of MySQL. It includes a voucher for 25 percent off either exam-a $50 value! The number of MySQL certification exams taken has doubled in the last six months. 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…    
Customers also bought

Book details

List price: $64.99
Edition: 2nd
Copyright year: 2006
Publisher: Pearson Technology Group
Publication date: 8/24/2005
Binding: Mixed Media
Pages: 672
Size: 7.00" wide x 8.75" long x 1.75" tall
Weight: 2.288
Language: English

Paul DuBois is the leading author of books on MySQL topics. His MySQL (0672326736, third edition soon to be published), 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.

About This Book
Sample Exercises
Other Required Reading
Sample Data
Study Guide Errata
Certification Information at
The MySQL Certification Candidate Guide
The Certification Mailing List
Conventions Used in This Book
Running MySQL on Microsoft Windows
About the Exams
Registering for an Exam
Going to the Exam
Taking the Exam
Reading Questions
Answering Questions
After the Exam
Retaking Exams
Interpreting DESCRIBE Output
Sample Tables
MySQL Developer Exams
MySQL Developer I Exam
Client/Server Concepts
The mysql Client Program
MySQL Query Browser
MySQL Connectors
Data Types
Tables and Indexes
Querying for Data
SQL Expressions
Updating Data
MySQL Developer II Exam
Importing and Exporting Data
User Variables
Prepared Statements
Stored Procedures and Functions
Obtaining Database Metadata
Debugging MySQL Applications
Basic Optimizations
MySQL Architecture
Starting, Stopping, and Configuring MySQL
Client Programs for DBA Work
MySQL Administrator
Character Set Support
Storage Engines
Table Maintenance
The Information_Schema Database
Data Backup and Recovery Methods
Using Stored Routines and Triggers for Administration
User Management
Securing the MySQL Installation
Upgrade-Related Security Issues
Optimizing Queries
Optimizing Databases
Optimizing the Server
Interpreting Diagnostic Messages
Optimizing the Environment
Scaling MySQL
Other Offers