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!

Description:

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. 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 Certification Study Guide." Written by Paul DuBois, the leading author of books on MySQL topics, and reviewed for technical accuracy byMySQL AB, this book is the fastest, most reliable way for MySQL users, developers, and administrators to prepare for either of the MySQL tests.
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.01" wide x 9.06" long x 1.54" 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.

Introduction
About This Book
Sample Exercises
Other Required Reading
Manuals
Sample Data
Study Guide Errata
Certification Information at www.mysql.com
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
Warning
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
Identifiers
Databases
Tables and Indexes
Querying for Data
SQL Expressions
Updating Data
MySQL Developer II Exam
Joins
Subqueries
Views
Importing and Exporting Data
User Variables
Prepared Statements
Stored Procedures and Functions
Triggers
Obtaining Database Metadata
Debugging MySQL Applications
Basic Optimizations
MySQL DBA Exams
MySQL DBA I Exam
MySQL Architecture
Starting, Stopping, and Configuring MySQL
Client Programs for DBA Work
MySQL Administrator
Character Set Support
Locking
Storage Engines
Table Maintenance
The Information_Schema Database
Data Backup and Recovery Methods
Using Stored Routines and Triggers for Administration
MySQL DBA II EXAM
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
Appendixes
References
Other Offers
Index