Saturday, 7 April 2012

The good source to study for MySql 5.0 examination.

Well, this book from MySQL press. The good source to study for MySql 5.0 examination. This book is a must if your want to pass Mysql Certification. This book will guide you in detail how to use MySql command in a complex scenario. The Mysql database in explain in depth so you will appreciate MySql better.


Book Description
Publication Date: September 3, 2005 | ISBN-10: 0672328127 | ISBN-13: 978-0672328121

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.




Quite simply, this book should be on the shelf of anyone who intends to take the MySQL Certification exams.

The book was written by Paul DuBois, certainly the top author of MySQL related books. Paul's style is very readable and the book provides extensive coverage of the exam material.

In fact, the book is so extensive because it was written not only by Paul, but by Carsten Pedersen, certification manager at MySQL AB. The book was written by the people who created the exam, and it shows. I can tell you right now that if you read the certification study guide and know its content, you will pass the certification exam. There is not a question on the exam that is not covered by this study guide.

The exercises are good, though not always formatted the same as what you will encounter on the actual exam. Doing the exercises should reveal how well you understand a given topic in the guide.

Here's an overview of what the book covers:

* MySQL and MySQL AB

* MySQL Software

* Using MySQL Client Programs

* Data Definition Language

* The SELECT Statement

* Basic SQL

* Update Statements

* Joins

* Importing and Exporting Data

* MySQL Architecture

* MySQL Installation and Configuration

* Security Issues

* Optimizing for Query Speed

* MyISAM Tables

* InnoDB Tables

* Advanced Server Features

Finally, here is the best part about the MySQL Certification Study Guide: it's free. In the back of the guide is a voucher code for 25% off the cost of a certification exam, or roughly the price of the book. If you are serious about taking the MySQL Certification exams, you can't go wrong with this book.



No comments:

Post a Comment