MySQL 5. 0 Certification Study Guide

Name: MySQL 5. 0 Certification Study Guide
Price: 3.96 USD
Availability: InStock
ISBN: 9780672328121

ISBN-10: 0672328127

ISBN-13: 9780672328121

Edition: 2nd 2006

Authors: Paul DuBois, Stefan Hinz, Carsten Pedersen

List price: $64.99

30 day, 100% satisfaction guarantee!

Marketplace

3 new & used from $3.96

what's this?

Rush Rewards U
Members Receive:

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…

Book details

List price: $64.99
Edition: 2nd
Copyright year: 2006
Publisher: Pearson Technology Group
Publication date: 8/24/2005
Binding: Paperback
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.



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